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 vote305 views1 answer
Typescript switch on object type
TypeScript
0 vote348 views2 answers
Ng2003
TypeScript
0 vote323 views1 answer
React inherit html input props
TypeScript
0 vote348 views1 answer
Typescript recursive partial
TypeScript
0 vote336 views1 answer
Event
TypeScript
0 vote319 views1 answer
Typescript generic dictionary
TypeScript
0 vote328 views1 answer
Flutter fab covers widget on keyboard open
TypeScript
0 vote340 views1 answer
Can i use different flutter versions for differnt progjects ?
TypeScript
0 vote341 views4 answers
C++ sort vector of objects by property
TypeScript
1 vote337 views1 answer
Header imitate python
TypeScript