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 vote116 views1 answer
Amcharts angular
TypeScript
5 votes152 views2 answers
Response.json results in pretty data python
TypeScript
0 vote125 views2 answers
How to get both key and value of enum in typescript
TypeScript
0 vote237 views1 answer
1,
TypeScript
1 vote153 views1 answer
How to generate test data
TypeScript
0 vote186 views1 answer
Discuss climate changes during the Tertiary and Quaternary Periods, and the effects of these changes on geology and vegetation.
TypeScript
0 vote155 views1 answer
E typescript
TypeScript
0 vote147 views1 answer
Which of the following object types below cannot be replicated
TypeScript
0 vote172 views1 answer
FIFA 21 esports temas
TypeScript
3 votes175 views1 answer
Typescript add global variable to window
TypeScript