How to check the SQL query result for specfic data while using Python+CGI+SQLite3?

Question

I need to check if table which holds credentials has record with matched username and password. I use COUNT because it's easier to parse one int value. How to check (using Python) if there are 1 or more records in credentials table?

    query = "SELECT COUNT(user_name) from credentials user_name='[email protected]' and pwd='123';"
    con = sqlite.connect(databasefile)
    cur = con.cursor()
    cur.execute(query)
    while 1:
        row=cur.fetchone()
        if not row:
            break
        res=res+[row]
#check if there is 1 or more matched records ....

It's the result from server:

sqlite> SELECT COUNT(user_name) from credentials where  user_name='[email protected]' and pwd='1           23';
COUNT(user_name)
----------------
1

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

From PEP 249:

.rowcount

This read-only attribute specifies the number of rows that the last .execute*() produced (for DQL statements like SELECT) or affected (for DML statements like UPDATE or INSERT).

if cur.rowcount > 0:
   ...

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 18, 2013 at 5:23

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

J.Olufsen Over a year ago

cur.rowcount is equal to -1 but I am sure the SQL is correct. Why?

J.Olufsen Over a year ago

I think as far as .rowcount is not working for SELECT I should use len(row) ...

Collectives™ on Stack Overflow

How to check the SQL query result for specfic data while using Python+CGI+SQLite3?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related