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 vote222 views1 answer
Rest api django return value if exists in another table
TypeScript
1 vote252 views1 answer
Js type-check undefined or string
TypeScript
0 vote232 views1 answer
Create n sublists python
TypeScript
0 vote254 views1 answer
Mat-autocomplete options dropdown does not stick when scrolling
TypeScript
0 vote244 views2 answers
Angular 8 ts refresh page
TypeScript
0 vote230 views1 answer
In grunt cannot be loaded because running scripts is disabled on this system
TypeScript
2 votes235 views1 answer
Loop through form controls angular
TypeScript
1 vote223 views1 answer
Fake browser visti python headers
TypeScript
2 votes227 views2 answers
Material dialog disable close
TypeScript
0 vote228 views1 answer
How to send attachments to node mailer file not found
TypeScript