How to store count values in python

Question

I want to compare two tables based on their total number of rows. So i use count(*) to count the total number of rows in both table.

My code is:

cur1.execute ("""SELECT COUNT(*) FROM mytable;""")

In order to store the total count return by this query,

I use

row = cur1.fetchone()

 result1 =  row[0]

but it didn't help. Can anyone suggest me the solution?

What do you mean by *it didn't help*? Did it give you an error? Was the result incorrect or unexpected? — Blair, Apr 15 '11 at 10:43
@Blair: Yeah I got an error, TypeError: 'long' object is unsubscriptable if i use fetchone. — Rohita Khatiwada, Apr 15 '11 at 10:51
Here's what you do. (1) print the results of the fetchone. Print `row`. (2) **update** the question with the results. Don't comment on your own question. Update your question, please. — S.Lott, Apr 15 '11 at 10:53

score 1 · Accepted Answer · answered Apr 15 '11 at 10:58

1

cursor.fetchone()

gives you the result directly..so no need to take its zeroeth element..what you want is given to you directly when you say:

row = cur1.fetchone()

answered Apr 15 '11 at 10:58

Rafi

2

According to Python DB-API standard, fetchone() _should_ return either a sequence or a None. – Janne Karila Apr 15 '11 at 11:51

1 Answers1