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 vote290 views1 answer
Powershell see ports in use
TypeScript
0 vote298 views1 answer
Why important testng xml file
TypeScript
0 vote307 views1 answer
Conditional styled components with media query
TypeScript
21 votes297 views4 answers
Rule::exists with custom message laravel
TypeScript
2 votes278 views1 answer
Google sheets reference cell static
TypeScript
0 vote323 views1 answer
How to specify output directory in TypeScript?
TypeScript
3 votes283 views1 answer
Typescript string contains
TypeScript
7 votes288 views4 answers
Angular set query params
TypeScript
0 vote344 views1 answer
Expected 1 arguments, but got 0. Did you forget to include 'void' in your type argument to 'Promise'?
TypeScript
-1 vote310 views1 answer
Nest custom class validator
TypeScript