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 vote258 views3 answers
Check table exists in db laravel
TypeScript
1 vote236 views1 answer
Node js process on unhandled promise rejection
TypeScript
0 vote248 views1 answer
Angular tokenize
TypeScript
0 vote258 views1 answer
Google sheets importrange named range
TypeScript
0 vote341 views1 answer
Error NG8002: Can't bind to 'ngbCollapse' since it isn't a known property of 'ul'.
TypeScript
1 vote261 views1 answer
Dev/storage/logs" and its not buildable: Permission denied
TypeScript
0 vote212 views1 answer
Typescript list
TypeScript
1 vote254 views1 answer
Typescript event keyCode
TypeScript
0 vote276 views1 answer
Vba if value exists in range
TypeScript
8 votes274 views3 answers
Your account has reached its concurrent builds limit
TypeScript