I am learning Python and creating a database connection. While trying to add to the DB, I am thinking of creating tuples out of information and then add them to the DB.
What I am Doing: I am taking information from the user and store it in variables. Can I add these variables into a tuple? Can you please help me with the syntax?
Also if there is an efficient way of doing this, please share...
EDIT Let me edit this question a bit...I only need the tuple to enter info into the DB. Once the information is added to the DB, should I delete the tuple? I mean I don't need the tuple anymore.
Tuples are immutable; you can't change which variables they contain after construction. However, you can concatenate or slice them to form new tuples:
a = (1, 2, 3) b = a + (4, 5, 6) c = b[1:]
And, of course, build them from existing values:
name = "Joe" age = 40 location = "New York" joe = (name, age, location)
You can start with a blank tuple with something like
t = (). You can add with
+, but you have to add another tuple. If you want to add a single element, make it a singleton:
t = t + (element,). You can add a tuple of multiple elements with or without that trailing comma.
>>> t = () >>> t = t + (1,) >>> t (1,) >>> t = t + (2,) >>> t (1, 2) >>> t = t + (3, 4, 5) >>> t (1, 2, 3, 4, 5) >>> t = t + (6, 7, 8,) >>> t (1, 2, 3, 4, 5, 6, 7, 8)