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

15 votes237 views3 answers
Can't bind to 'formGroup' since it isn't a known property of 'form
TypeScript
0 vote174 views1 answer
Regexp in typescript types
TypeScript
0 vote171 views1 answer
Testing in different environments
TypeScript
0 vote220 views1 answer
Copy all elements from one list to another ajav
TypeScript
0 vote168 views2 answers
Comparison method violates its general contract!
TypeScript
0 vote128 views2 answers
How to get both key and value of enum in typescript
TypeScript
0 vote164 views1 answer
Node fetch image to base64
TypeScript
0 vote184 views1 answer
Css proferties throught ts
TypeScript
0 vote182 views1 answer
Styled components gatsby
TypeScript
3 votes164 views4 answers
Remove item from array if exists in another array
TypeScript