Hi All, I'm trying to put together an Association Object mapping within a pylons app, but am getting the following error:
OperationalError: (OperationalError) (1364, "Field 'user_id' doesn't have a default value") 'INSERT INTO contact_duedate_user_association (contact_id, modded) VALUES (%s, %s)' (209L, datetime.date(2012, 7, 18)) As far as I can tell I've followed the recomendations in the association object help and am somehwta stumped as to what is causing the error. The classes are non-declarative, and are as follows (and if the formatting holds up the relevant bits should be in bold). Any help enormously appreciated. contacts_table = sa.Table('contacts', meta.metadata, sa.Column('id', sa.types.Integer, primary_key=True), sa.Column('project_id', sa.types.Integer, sa.ForeignKey('projects.id')), sa.Column('client_id', sa.types.Integer, sa.ForeignKey('clients.id')), sa.Column('firstname',sa.types.String(length=255)), sa.Column('lastname', sa.types.String(length=255)), sa.Column('email1', sa.types.String(length=255)), sa.Column('email2', sa.types.String(length=255)), sa.Column('workphone', sa.types.String(length=255)), sa.Column('mobile', sa.types.String(length=255)), sa.Column('company', sa.types.String(length=255)), sa.Column('category', sa.types.String(length=255)), sa.Column('job_role', sa.types.String(length=255)), sa.Column('mailer', sa.types.Boolean), sa.Column('type', sa.types.Integer), # 0: contact, 1: press sa.Column('modified', sa.types.DateTime), ) class ArkContact(object): def __init__(self): self.category = 0 self.type = 0 self.modified = datetime.datetime.now() *#due_contact_association contact_due_contact = sa.Table('contact_duedate_user_association', meta.metadata, sa.Column('contact_id', sa.types.Integer, sa.ForeignKey('contacts.id'), primary_key = True), sa.Column('user_id', sa.types.Integer, sa.ForeignKey('users.id'), primary_key = True), sa.Column('modded', sa.types.Date) ) class ArkContactDueDate(object): def __init__(self): pass* *# ArkContactDueDate orm.mapper(ArkContactDueDate, contact_due_contact, properties={ 'contact': orm.relation(ArkContact, backref = 'due_dates') })* # ArkUser - users module orm.mapper(ArkUser, users_table, properties={ 'notes': orm.relation(ArkNote, secondary=user_notes_table, single_parent=True, backref='user', order_by=notes_table.c.date, cascade="all, delete, delete-orphan"), 'software': orm.relation(ArkSoftware, secondary=user_software_table, backref='users'), 'ratings': orm.relation(ArkUserSoftwareRating, cascade="all, delete", backref='user'), 'job': orm.relation(ArkJob, backref='user'), * 'due_contacts': orm.relation(ArkContactDueDate, backref = 'due_user', single_parent=True)* }) -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.