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

9 votes134 views3 answers
Typescript onclick event type props
TypeScript
0 vote133 views1 answer
Print elements of unordered set c++
TypeScript
21 votes165 views6 answers
Ngclass angular
TypeScript
1 vote151 views2 answers
Trim undefined keys from object typescript
TypeScript
0 vote159 views1 answer
Cannot find module 'dotenv' or its corresponding type declarations
TypeScript
18 votes127 views2 answers
Keys of array exist in array
TypeScript
0 vote133 views1 answer
Reddit requests 429
TypeScript
2 votes134 views1 answer
Requests python no proxy
TypeScript
7 votes137 views2 answers
Add new key in array objects using map
TypeScript
1 vote145 views1 answer
Array of object react js useState
TypeScript