If exits python sql

for name in ('bar','foo'): 
    cursor.execute("SELECT rowid FROM components WHERE name = ?", (name,))
    data=cursor.fetchall()
    if len(data)==0:
        print('There is no component named %s'%name)
    else:
        print('Component %s found with rowids %s'%(name,','.join(map(str, next(zip(*data))))))

Source: stackoverflow.com

Similar codes

0 vote72 views1 answer
Convert number to decimal in react typescript
TypeScript
0 vote113 views1 answer
Htmlspecialchars() expects parameter 1 to be string array given in laravel blade
TypeScript
0 vote100 views2 answers
Large curly brackets latex
TypeScript
2 votes110 views1 answer
Key value pairs typescript
TypeScript
0 vote107 views1 answer
Typescript generic record
TypeScript
0 vote99 views1 answer
Use sample weights fit model multiclass
TypeScript
2 votes144 views1 answer
Type 'Timeout' is not assignable to type 'number'.
TypeScript
2 votes106 views2 answers
React native elements button with icon
TypeScript
0 vote123 views1 answer
Dotcms elasticsearch query
TypeScript
12 votes117 views1 answer
Typescript keyof
TypeScript