How to make fetch methods return int values for INTEGER columns instead of strings Python sqlite?

Question

I'm tring to use this code to read all temperature values from a sqlite database column, but the output is showing [(u'29',), (u'29',), (u'29',)] and I'm only storing the numeric value in the database. I would like the output to be [29, 29, 29]

import sqlite3

conn = sqlite3.connect("growll.db")
cursor = conn.cursor()

print "\nHere's a listing of all the records in the table:\n"
cursor.execute("select lchar from GrowLLDados")

print cursor.fetchall()

If that is the output then - sure that only numbers are being stored? (As opposed to numeric strings.) SQLite will do some basic type-affinity conversions depending upon column type, but otherwise, what you get is what is in the database. — user166390
– user166390, Commented Dec 27, 2012 at 1:14

Justin Lewis · Accepted Answer · 2012-12-26 23:03:44Z

6

Try this:

import sqlite3

conn = sqlite3.connect("growll.db")
cursor = conn.cursor()

print "\nHere's a listing of all the records in the table:\n"
cursor.execute("select lchar from GrowLLDados")    

print [int(record[0]) for record in cursor.fetchall()]

answered Dec 26, 2012 at 23:03

Justin Lewis

1,6031 gold badge19 silver badges34 bronze badges

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

5 Comments

Aman Over a year ago

Worked Perfectly! thanks Since I'm learning python would you know how I would do the same if I the data was a char like L instead of 29?

Justin Lewis Over a year ago

Sure: print [record[0] for record in cursor.fetchall()] should work if fetchall() returns [(u'L',), (u'L',), (u'L',)] for example. The u in front of the strings just mean that they are unicode strings, by the way.

Aman Over a year ago

To use this data how I can store it in a new variable because if I trie to read the record varialble there is only the last read variable not the list. Thanks

Justin Lewis Over a year ago

To get [29, 29, 29] into a variable, assign it to one instead of printing it, i.e. records = [int(record[0]) for record in cursor.fetchall()]. Is that what you mean?

Aman Over a year ago

Yes thats it I'll use matplot with this data.

hd1 · Accepted Answer · 2012-12-27 00:22:33Z

1

print [int(i[0]) for i in cursor.fetchall()]

Let me know how you get on.

edited Dec 27, 2012 at 0:22

answered Dec 26, 2012 at 23:00

hd1

34.9k5 gold badges83 silver badges95 bronze badges

2 Comments

Justin Lewis Over a year ago

Won't this throw a TypeError? int() needs a string, not a tuple

Justin Lewis Over a year ago

yes I have: TypeError: int() argument must be a string or a number, not 'tuple'

Collectives™ on Stack Overflow

How to make fetch methods return int values for INTEGER columns instead of strings Python sqlite?

2 Answers 2

5 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related