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 vote175 views1 answer
Serenity.is set datepicker value on click
TypeScript
0 vote152 views1 answer
Send tcp packets to kubernetes node
TypeScript
0 vote132 views1 answer
Material-ui icon npm
TypeScript
0 vote162 views1 answer
Delete attachments in nodejs
TypeScript
0 vote130 views1 answer
Typeerror: cannot read property 'initialize' of undefined passport
TypeScript
0 vote161 views1 answer
Typescript function return array
TypeScript
2 votes134 views1 answer
Router navigate pass params
TypeScript
1 vote132 views1 answer
:= and = in gdscript
TypeScript
0 vote143 views1 answer
Pending = pending$ async type 'boolean null' is not assignable
TypeScript
2 votes132 views1 answer
How to get index for ngfor
TypeScript