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 vote294 views1 answer
Init Lambda based on typescript
TypeScript
2 votes298 views2 answers
Constraints in sql
TypeScript
0 vote282 views4 answers
Construct a binary tree from inorder and preorder traversal calculator
TypeScript
0 vote313 views1 answer
Check if graphic driver exists ubuntu
TypeScript
-1 vote295 views2 answers
Size of array typescript
TypeScript
16 votes273 views2 answers
Chunk list python
TypeScript
0 vote286 views1 answer
Curl send 100 requests parallel
TypeScript
0 vote347 views1 answer
Downgrade typescript version
TypeScript
0 vote285 views1 answer
Nodejs to send authentication bearer token cowin
TypeScript
1 vote267 views1 answer
Stored procedure that selects in to a table
TypeScript