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 vote150 views1 answer
Response 404 requests python compare
TypeScript
0 vote149 views1 answer
Different types of errors in numerical methods
TypeScript
13 votes112 views7 answers
Lua print table contents
TypeScript
0 vote148 views1 answer
Let say your Project Manager tell you that your database requests are consume a lot of memory, you need to do something to improve the performance. How would you do it in hibernate ?
TypeScript
2 votes146 views2 answers
File_get_contents follow redirect
TypeScript
0 vote218 views2 answers
Java to typescript
TypeScript
4 votes144 views1 answer
Map vs for each
TypeScript
0 vote147 views1 answer
How to find out the amount of ints in c++
TypeScript
0 vote145 views1 answer
Paginator
TypeScript
0 vote167 views2 answers
Typescript-eslint disable
TypeScript