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

1 vote147 views1 answer
[ERROR] @ionic/app-scripts is required for this command to work properly.
TypeScript
0 vote137 views1 answer
Typescript compare strings
TypeScript
0 vote137 views1 answer
How to use if statemnts c#
TypeScript
0 vote141 views1 answer
No corners in broder css
TypeScript
0 vote129 views1 answer
How to find matching brackets in eclipse
TypeScript
0 vote146 views1 answer
How to create instances of classes godot
TypeScript
2 votes160 views2 answers
Material dialog disable close
TypeScript
0 vote154 views1 answer
Tuple must contain two elements unity
TypeScript
0 vote133 views1 answer
W/TextToSpeech: speak failed: not bound to TTS engine site:stackoverflow.com
TypeScript
9 votes151 views3 answers
Fragments in react
TypeScript