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 vote295 views1 answer
Can we do system testing at any stage
TypeScript
30 votes316 views3 answers
Empty character
TypeScript
1 vote314 views1 answer
If exists certain line in sql table java condition
TypeScript
0 vote290 views1 answer
How to remove the white space between two plots in r
TypeScript
0 vote378 views1 answer
Error TS2503: Cannot find namespace 'google'. 10 @Input() mapOptions: google.maps.MapOptions;
TypeScript
17 votes263 views1 answer
Lts stands for
TypeScript
0 vote328 views1 answer
OpenCV(4.5.3) C:\Users\runneradmin\AppData\Local\Temp\pip-req-build-q3d_8t8e\opencv\modules\imgproc\src\shapedescr.cpp:315: error: (-215:Assertion failed) npoints >= 0 && (depth == CV_32F || depth == CV_32S) in function 'cv::contourArea'
TypeScript
0 vote310 views1 answer
React inherit html input props
TypeScript
2 votes303 views1 answer
Vscode custom snippets how to use file name
TypeScript
0 vote291 views1 answer
Nativescript date input validation
TypeScript