mysqldb SELECT COUNT reurns 1

[SMALLp]

Hy! I nave another problem I can't solve!
<code>

import MySQLdb as mysql

connectionString = {"host":"localhost", "user":"root",
"passwd":"pofuck", "db":"fileshare"}
dataTable = "files"
conn = mysql.connect(host=connectionString["host"],
user=connectionString["user"], passwd=connectionString["passwd"],
db=connectionString["db"])

cursor = conn.cursor()
sql = "SELECT COUNT(*) FROM " + dataTable
res = cursor.execute(sql)
print res

<code>
It prints 1, and there are 88 rows in table. SELECT works fine, but
SELECT COUNT(*) makes problems.

Help! Thanks in advance!

 

[Rob Williscroft]

SMALLp wrote in in comp.lang.python:

Hy! I nave another problem I can't solve!
<code>

import MySQLdb as mysql

cursor = conn.cursor()
sql = "SELECT COUNT(*) FROM " + dataTable
res = cursor.execute(sql)

I think you need to do:
res = cursor.fetchone()[0]

print res

<code>
It prints 1, and there are 88 rows in table. SELECT works fine, but
SELECT COUNT(*) makes problems.

Rob.

 

[SMALLp]

SMALLp wrote in in comp.lang.python:

Hy! I nave another problem I can't solve!
<code>

import MySQLdb as mysql

cursor = conn.cursor()
sql = "SELECT COUNT(*) FROM " + dataTable
res = cursor.execute(sql)

I think you need to do:
res = cursor.fetchone()[0]

print res

<code>
It prints 1, and there are 88 rows in table. SELECT works fine, but
SELECT COUNT(*) makes problems.

Rob.

Of course! Thanks!

 

[John Machin]

Hy! I nave another problem I can't solve!
<code>

import MySQLdb as mysql

connectionString = {"host":"localhost", "user":"root",
"passwd":"pofuck", "db":"fileshare"}
dataTable = "files"
conn = mysql.connect(host=connectionString["host"],
user=connectionString["user"], passwd=connectionString["passwd"],
db=connectionString["db"])

cursor = conn.cursor()
sql = "SELECT COUNT(*) FROM " + dataTable
res = cursor.execute(sql)
print res

<code>
It prints 1, and there are 88 rows in table.

What makes you think that it should return 88?

SELECT works fine, but

In what sense does a bare "SELECT" work fine??

SELECT COUNT(*) makes problems.

Help! Thanks in advance!

Consider helping yourself, e.g.:
(1) search the web for "mysqldb tutorial"
(2) read the MySQLdb documentation
(3) read http://www.python.org/dev/peps/pep-0249/

You need to use one of the cursor.fetchXXXX methods to get your
results. The result from a call to cursor.execute is NOT defined in
the Python DBAPI. If you are interested in portability of your code
across database software, you should not rely on it. The value 1
probably just means that the execute call succeeded.

Do read carefully the descriptions of what is returned by each of the
cursor.fetchXXXX methods.

 

[Ian Clark]

connectionString = {"host":"localhost", "user":"root",
"passwd":"pofuck", "db":"fileshare"}
dataTable = "files"
conn = mysql.connect(host=connectionString["host"],
user=connectionString["user"], passwd=connectionString["passwd"],
db=connectionString["db"])

Just to let you know, that last line can be rewritten as:

conn = mysql.connect(**connectionString)


Ian

 

[mike]

connectionString = {"host":"localhost", "user":"root",
"passwd":"pofuck", "db":"fileshare"}
dataTable = "files"
conn = mysql.connect(host=connectionString["host"],
user=connectionString["user"], passwd=connectionString["passwd"],
db=connectionString["db"])

Just to let you know, that last line can be rewritten as:

conn = mysql.connect(**connectionString)

Ian

Try using cursor.fetchall() instead of cursor.fetchone()