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

55 votes271 views6 answers
How to get rid of bullet points in css
TypeScript
0 vote137 views1 answer
Reorder inline-block elements css
TypeScript
0 vote153 views1 answer
FIND TOP 3 students from math_11a table
TypeScript
16 votes103 views1 answer
Python for with two arrays
TypeScript
1 vote125 views1 answer
Adonisjs decrement
TypeScript
0 vote122 views1 answer
Typescript interview questions
TypeScript
0 vote137 views1 answer
Sort function in typescript
TypeScript
0 vote112 views1 answer
Property 'carousel' has no initializer and is not definitely assigned in the constructor
TypeScript
0 vote107 views1 answer
How to add id in array javascript
TypeScript
0 vote133 views1 answer
Typescript reduce initial value type
TypeScript