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 vote91 views1 answer
Where can I find reports of "reports and data" for free reddit quora
TypeScript
0 vote112 views1 answer
Spilit with comma in ts
TypeScript
2 votes97 views3 answers
Java sort list by attribute
TypeScript
0 vote114 views1 answer
Deleting a comnent from arrays of comments in mongodb
TypeScript
0 vote104 views2 answers
Localstorage getitem angular
TypeScript
0 vote104 views1 answer
Vscode pass argument to registerCommand
TypeScript
0 vote100 views1 answer
Check if two lists have overlap python
TypeScript
-1 vote147 views1 answer
How to separate a string into 2 lists of numbers and letters python
TypeScript
0 vote104 views1 answer
Combine 2 lists to dataframe python
TypeScript
0 vote106 views1 answer
Google places auto-complete
TypeScript