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 vote143 views1 answer
Are loop increments private in openmp
TypeScript
-1 vote195 views1 answer
Add three dots to text css
TypeScript
6 votes181 views2 answers
Javascript convert string to character array
TypeScript
0 vote231 views1 answer
Typescript get class properties
TypeScript
0 vote230 views1 answer
Linux copy all directory contents to another directory
TypeScript
0 vote207 views1 answer
Typescript ignore node_modules
TypeScript
1 vote185 views3 answers
Flutter capitalize first letter textfield
TypeScript
1 vote182 views1 answer
Regex ts
TypeScript
0 vote188 views1 answer
Get enum value dynamically typescript
TypeScript
0 vote226 views1 answer
Tar contents of current folder
TypeScript