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 vote169 views1 answer
Typescript switch on object type
TypeScript
0 vote188 views1 answer
Get n random elements from list java
TypeScript
1 vote180 views2 answers
Typescript object key enum
TypeScript
9 votes284 views2 answers
Mongodb add array to set
TypeScript
4 votes202 views1 answer
Pub schedule firebase
TypeScript
63 votes534 views6 answers
React router install
TypeScript
-1 vote156 views2 answers
Jquery in angular
TypeScript
9 votes194 views2 answers
Multiple where statements sql
TypeScript
1 vote193 views1 answer
How to send data between components in react with redirect
TypeScript
0 vote174 views1 answer
Plot 3d points in python
TypeScript