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 vote164 views1 answer
Typescript get object value
TypeScript
0 vote303 views1 answer
Deleting conflicting outputs
TypeScript
2 votes184 views3 answers
Mat dialog disable close
TypeScript
1 vote131 views1 answer
What is test management review
TypeScript
2 votes197 views1 answer
Three dots icon flutter
TypeScript
1 vote160 views1 answer
React setstate in hooks to array of objects value
TypeScript
4 votes171 views2 answers
Unity rigidbody constraints unfreeze
TypeScript
3 votes183 views2 answers
Adonis load relationship
TypeScript
0 vote192 views1 answer
How to find the index of property in array of object in typescript
TypeScript
1 vote162 views2 answers
How to sort numbers in typescript
TypeScript