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 vote197 views4 answers
Symfony\Component\Debug\Exception\FatalThrowableError Type error: ReflectionFunction::__construct() expects parameter 1 to be string, array given
TypeScript
0 vote231 views1 answer
Void main() { testWidgets('Counter increments smoke test', (WidgetTester tester) async { // Build our app and trigger a frame. await tester.pumpWidget(MyApp());
TypeScript
0 vote215 views1 answer
Bibtex remove brackets in note field
TypeScript
0 vote199 views1 answer
Typescript document.queryselector type
TypeScript
0 vote210 views1 answer
Rails_env production rake assets precompile
TypeScript
0 vote207 views1 answer
Using es6 set in typescript
TypeScript
1 vote204 views1 answer
How to use command line arguments in java eclipse
TypeScript
2 votes213 views1 answer
Ts-node call function from command line
TypeScript
1 vote235 views1 answer
Increase size of mat dialog
TypeScript
0 vote212 views1 answer
Mat-sort not working in dynamically generated table
TypeScript