Hello all
I'd like to insert more than one expression in a table. Some
expressions don't have an entry in every column:
>>> conn = engine.connect()
>>> conn.execute(addresses.insert(), [
... {'name': 'mike', 'email_address' : '[EMAIL PROTECTED]'},
... {'name': 'wendy', 'fullname': 'Wendy Williams',
'email_address' : '[EMAIL PROTECTED]'},
... {'name': 'jack', 'fullname': 'Jack Jones',
'email_address' : '[EMAIL PROTECTED]'},
... {'name': 'julia', 'email_address' : '[EMAIL PROTECTED]'},
... ])
SQLAlchemy generates:
INSERT INTO addresses (name, email_address) VALUES (%s, %s)
[['mike', '[EMAIL PROTECTED]'], ['wendy', '[EMAIL PROTECTED]'], ['jack',
'[EMAIL PROTECTED]'], ['julia', '[EMAIL PROTECTED]']]
The expressions to insert aren't complete, because the first
expression doesn't have an entry 'fullname'. Why? Is it not possible
to start with an 'incomplete' expression? What can I do with big
tables (more columns) and only few entries?
Thanks a lot
Carla
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
