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 vote282 views2 answers
C++ map key exists
TypeScript
0 vote255 views1 answer
Plot 3d points in python
TypeScript
0 vote263 views2 answers
How to remove brackets from list in python text file
TypeScript
0 vote329 views1 answer
Get distinct elements in table psql
TypeScript
0 vote259 views1 answer
React Draft Wysiwyg typescript
TypeScript
1 vote254 views2 answers
Alerts in material ui
TypeScript
0 vote287 views1 answer
Install typescript homebrew
TypeScript
5 votes269 views1 answer
Sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread
TypeScript
0 vote260 views1 answer
How to check if object is undefined in typescript
TypeScript
0 vote270 views1 answer
Use sample weights fit model multiclass
TypeScript