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 vote149 views1 answer
Can we do system testing at any stage
TypeScript
0 vote165 views1 answer
Sort a list of ints python in descending order
TypeScript
0 vote155 views1 answer
File attachements contac form 7
TypeScript
0 vote158 views1 answer
Open url with pacage.json
TypeScript
0 vote158 views1 answer
Peer of typescript@>=2.8.0
TypeScript
0 vote146 views1 answer
How to search for imports in vscode
TypeScript
0 vote146 views1 answer
Multiline comments coding
TypeScript
0 vote162 views1 answer
Redux typescript mapdispatchtoprops
TypeScript
2 votes133 views1 answer
Where do scientists get their stem cells for research?
TypeScript
0 vote154 views1 answer
Could not find method Properties() for arguments [] on project ':app'
TypeScript