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 vote209 views1 answer
// running tests Your code should no longer have a p tag around the text asking what level ninja a user is. // tests completed category:423
TypeScript
0 vote210 views1 answer
Typescript implement
TypeScript
1 vote194 views1 answer
What is the name of belt around the orbits of earth and mars
TypeScript
14 votes189 views4 answers
Matplotlib subplots size
TypeScript
1 vote234 views3 answers
Inbuild method to sum of an arraylist elements in java
TypeScript
0 vote203 views1 answer
How to pass node arguments in nextjs
TypeScript
1 vote193 views1 answer
Ionic alert controller handler not dimiss
TypeScript
-1 vote183 views1 answer
Typescript array count
TypeScript
3 votes201 views2 answers
Adonis load relationship
TypeScript
0 vote187 views1 answer
Are flights still running
TypeScript