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 vote125 views1 answer
String of bits to integer java
TypeScript
1 vote102 views1 answer
Enabletrace angular
TypeScript
0 vote106 views1 answer
Does not use passive listeners to improve scrolling performance
TypeScript
0 vote109 views3 answers
Check table exists in db laravel
TypeScript
0 vote109 views1 answer
Write getter angular
TypeScript
0 vote112 views1 answer
How to check that tuple A contains all elements of tuple B python?
TypeScript
0 vote109 views1 answer
Loc multiple conditions string and integer
TypeScript
0 vote112 views2 answers
Rails precompile assets in a directory
TypeScript
0 vote122 views1 answer
How to set value to readonly property in typescript while unit testing
TypeScript
1 vote64 views1 answer
What is test management review
TypeScript