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 vote118 views1 answer
Does i5 7th generation processor supports windows 11
TypeScript
0 vote124 views1 answer
Powershell copy contents of keyvault to another keyvault
TypeScript
2 votes122 views2 answers
Remove all the elements from a numpy array python
TypeScript
0 vote124 views1 answer
Some of elements are arrays in python
TypeScript
4 votes131 views1 answer
Axis limits matlab
TypeScript
0 vote150 views1 answer
The derived ungapped alignments are calleed
TypeScript
0 vote125 views1 answer
Electronjs remove menubar
TypeScript
0 vote145 views1 answer
How to check git folder exists or not
TypeScript
8 votes122 views3 answers
Initialize all elements of vector to 0 c++
TypeScript
0 vote129 views1 answer
Accessing widgets in screen manager kivy
TypeScript