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 vote183 views2 answers
"Type error: ReflectionFunction::__construct() expects parameter 1 to be string, array given"
TypeScript
1 vote240 views1 answer
Cannot find module 'file-saver/FileSaver' or its corresponding type declarations.
TypeScript
1 vote185 views3 answers
How to make all elements in array int python
TypeScript
0 vote169 views1 answer
What are the testing types
TypeScript
1 vote168 views1 answer
Python get elements from list of dictionaries
TypeScript
0 vote155 views1 answer
Typescript api request header
TypeScript
0 vote178 views1 answer
Python application insights azure
TypeScript
0 vote177 views1 answer
Pass command line arguments C#
TypeScript
0 vote182 views1 answer
AFTER RESETTING ANGULAR FORM I AM GETTING RED INVALID FORM
TypeScript
1 vote175 views1 answer
Rscript arguments input
TypeScript