On 3/19/2014 8:19 AM, Toni Fuente wrote:
Hello everyone,
I am stack with a problem that I can't find a solution:
I need to create a sqlite schema dynamically, I've got a dictionary with
text keys: "RedHat", "CentOS", "SLES9",..., "etc", "etc"
My intention was at the time of creating the table schema run a loop
through the dictionary keys and incorporate them to the schema:
for os in osDict.items():
cur.execute('''CREATE TABLE mytable(week INTEGER NOT NULL, os TEXT NOT
NULL, number INTEGER NOT NULL)''')
IMHO you are mixing data with column names. Usually the column name in
this case would be just os.
What is your use case for this?
But I don't know how to pass the os key to the sqlite command.
Thank you in advance for any help,
Kind regards,
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
