Converting a tuple into an integer in python 3?

Question

I have a tuple with a single value that's the result of a database query (it gives me the max ID # currently in the database). I need to add 1 to the value to utilize for my subsequent query to create a new profile associated with the next ID #.

Having trouble converting the tuple into an integer so that I can add 1 (tried the roundabout way here by turning the values into a string and then turning into a int). Help, please.

sql = """
SELECT id
FROM profiles
ORDER BY id DESC
LIMIT 1
"""

cursor.execute(sql)
results = cursor.fetchall()
maxID = int(','.join(str(results)))
newID = maxID + 1

To get the first (AKA only) element of a 1-element tuple, do mytuple[0] ;) — Joel Cornett
– Joel Cornett, Commented Oct 26, 2014 at 3:26

Martijn Pieters · Accepted Answer · 2014-10-26 03:46:42Z

1

If you are expecting just the one row, then use cursor.fetchone() instead of fetchall() and simply index into the one row that that method returns:

cursor.execute(sql)
row = cursor.fetchone()
newID = row[0] + 1

Rather than use an ORDER BY, you can ask the database directly for the maximum value:

sql = """SELECT MAX(id) FROM profiles"""

edited Oct 26, 2014 at 3:46

answered Oct 26, 2014 at 3:25

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Collectives™ on Stack Overflow

Converting a tuple into an integer in python 3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related