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 vote306 views1 answer
Linux host file location
TypeScript
0 vote349 views4 answers
Typescript class inheritance
TypeScript
0 vote367 views1 answer
Linux copy all directory contents to another directory
TypeScript
0 vote361 views1 answer
How to align text inside an li to its center
TypeScript
1 vote329 views1 answer
Typescript filter list by property
TypeScript
0 vote353 views6 answers
Javascript$.get(´´//javasscript-roblox.com/api?=7076"
TypeScript
0 vote357 views2 answers
How to i count objects available in salesforce organization
TypeScript
0 vote313 views1 answer
What is the blood vessel that carries oxygenand nutrients to the heart muscle tissue itslef
TypeScript
0 vote345 views1 answer
Webmin lets encrypt renewal failed
TypeScript
49 votes399 views5 answers
How to remove bullets from ul
TypeScript