Retrieve the total record count of a table in SQLITE3 using python

Question

For context, I am a newbie to python and in sqlite3 development.

I'd like to retrieve an integer value of the total records of a specific table using the SELECT clause statement in SQLITE3 using python3. How should I proceed in doing this?

My current code is:

    with conn:
    c.execute("SELECT COUNT (*) FROM normal_configuration")
    print(c.fetchone())

Output: (10,)

I was hoping I could retrieve just the integer but it's returning this. Can someone also explain to me why is this the output of this certain code? I would appreciate all the help and correction. Thank you!

It’s a tuple. Get the first (and only) value out of the tuple by using indexing. — mkrieger1, Oct 14 '20 at 06:58
Yes it does @mkrieger1 thank you so much for this! Appreciate it! — Silverbells, Oct 14 '20 at 07:02

score 2 · Accepted Answer · answered Oct 14 '20 at 07:00

2

Like this:

with conn:
    c.execute("SELECT COUNT(*) FROM normal_configuration")
    result = c.fetchone()[0]
    print(result)

answered Oct 14 '20 at 07:00

Mayank Porwal

33,470
8
37
58

It worked! Thank you so much! I can't believe it's much simple as this. Appreciate it! – Silverbells Oct 14 '20 at 07:01
Slow on large db. – keramat Aug 20 '22 at 13:14

Retrieve the total record count of a table in SQLITE3 using python

1 Answers1