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 vote239 views1 answer
Choose random elements from vector without repetition and adding to another vector c++
TypeScript
19 votes196 views4 answers
Material ui icon npm
TypeScript
0 vote221 views1 answer
Disable out of stock products shopify
TypeScript
2 votes187 views1 answer
How to send information from javascript to flask route
TypeScript
1 vote205 views1 answer
How to find the two parts of a vector 2 C++
TypeScript
0 vote148 views1 answer
Echo contents of file to another file
TypeScript
0 vote191 views1 answer
How to Convert MATLAB Scripts to Python
TypeScript
1 vote208 views1 answer
Woocommerce sql query pulls products from category
TypeScript
0 vote295 views4 answers
Typescript class inheritance
TypeScript
0 vote221 views1 answer
Read/write linked lists to file
TypeScript