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

2 votes181 views1 answer
Usedisclosure
TypeScript
1 vote200 views1 answer
Round up number typescript
TypeScript
1 vote214 views1 answer
How to check when a number varibal = nan in ts
TypeScript
6 votes189 views2 answers
Ignore typescript error
TypeScript
1 vote197 views1 answer
Pathmatch angular
TypeScript
5 votes184 views2 answers
How to append to a list of lists in python
TypeScript
0 vote245 views1 answer
Type alias in typescript
TypeScript
0 vote187 views1 answer
Angular currency pipe pt-br as variable
TypeScript
1 vote179 views1 answer
Ract import image
TypeScript
0 vote200 views1 answer
Hackerrank between two sets solution in python
TypeScript