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

-1 vote197 views1 answer
10 elements of gothic literature
TypeScript
0 vote196 views1 answer
Typescript interface key with another type
TypeScript
1 vote197 views1 answer
What is test management review
TypeScript
0 vote196 views1 answer
Custom api endpoints jwt token
TypeScript
0 vote225 views1 answer
Where do you store your test data
TypeScript
0 vote225 views2 answers
Loop over documents in mongoose
TypeScript
0 vote186 views1 answer
Which of the following are elements associated with the html table layout?
TypeScript
0 vote223 views3 answers
Code converter from javascript to typescript
TypeScript
2 votes221 views1 answer
No suitable injection token for parameter 'path' of class 'BaseModel'
TypeScript
0 vote199 views1 answer
'mat-icon' is not a known element:
TypeScript