Hello.
I'm having some trouble with inserting a new line into an existing
table. The table has 3 columns. Columns 1 & 2 are primary keys. I've
no trouble inserting into the table from scratch using one connection
- if I create the table & populate it in one session. But if the
connection is broken & I connect again using a different script I run
into trouble with inserting new rows.
Lets say i create a Table Object that references the table...
table = Table('TABLE', metadata, autoload = true, schema = 'SCHEMA')
The statement:
print table.insert() - prints all three fields in the compiled SQL
statement...
but the statement
print table.insert( values = {'column1': value1, 'column2':value2,
'column3':value3})
only gives me the fields that are primary keys - the third column is
dropped.
I realize i must be missing something but for the life of me I don't
know what it is... Any help would be greatly appreciated
Thanks in advance, d.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
