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

2 votes193 views3 answers
Jquery don't empty specific form field after submit
TypeScript
9 votes119 views3 answers
Ng.ps1 cannot be loaded because running scripts is disabled on this system vscode
TypeScript
8 votes131 views3 answers
Initialize all elements of vector to 0 c++
TypeScript
0 vote150 views1 answer
How to create nest without spec test filefile
TypeScript
-1 vote131 views1 answer
Auto farm
TypeScript
24 votes187 views4 answers
NgFor
TypeScript
0 vote128 views1 answer
Get number of digits in an integer python without converting to string
TypeScript
19 votes132 views3 answers
Yarn.ps1 cannot be loaded because running scripts is disabled on this system
TypeScript
0 vote133 views1 answer
Lite-server cannot be loaded because running scripts is disabled on this system
TypeScript
16 votes121 views2 answers
Chunk list python
TypeScript