You could specify that fullname is null (None) for the columns that
don't have a full name value.
On Mon, Apr 7, 2008 at 8:04 AM, Carla <[EMAIL PROTECTED]> wrote:
>
> 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 [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
-~----------~----~----~----~------~----~------~--~---
