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 vote140 views2 answers
Bootstrap dropdown menu not showing
TypeScript
0 vote142 views1 answer
When to choose automation over manual testing
TypeScript
1 vote80 views2 answers
Loop an audio javascript
TypeScript
6 votes133 views1 answer
Typescript map list to new list of objects
TypeScript
19 votes168 views4 answers
Number of digits in a number python
TypeScript
-1 vote131 views3 answers
Connect redis typescript usage
TypeScript
1 vote124 views1 answer
Ion-datetime open programmatically
TypeScript
0 vote129 views1 answer
Flutter fab covers widget on keyboard open
TypeScript
0 vote126 views1 answer
In order to allow non-dict objects to be serialized set the safe parameter to False.
TypeScript
10 votes131 views3 answers
Typescript array of object with types
TypeScript