I tested my hypothesis, and inactivated the trigger on the Project
table, then added a Sequence('project_id_seq') to the project_id
column in the project table definition, and the updates work like a
charm.
So, is it not permissible to have triggers set on tables if one is
using SQLAlchemy? This could be problematic if other applications are
inserting records into the db and counting on triggers to increment
primary keys, for instance.
Anyone else run into this issue?
On Oct 9, 1:15 pm, jepr <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have begun using SQLAlchemy in earnest for a database project I've
> begun, and I am running into some roadblocks with inserts of very
> simple objects.
>
> I have generated a very simple class to represent an entity called a
> Project:
>
> class Project(object):
> def __init__(self, project):
> self.project = project
>
> def __repr__(self):
> return "<Project('%s')>" % (self.project)
>
> I have created a project table defined as follows:
>
> projectTbl = Table('project', meta,
> Column('project_id', Integer,
> PassiveDefault(''),
> primary_key=True),
> Column('project', String(100), unique=True,
> nullable=False),
> Column('crt_date', DateTime,
> nullable=False)
> )
>
> I created a mapping for the table which looks like this:
>
> projectMap = mapper(Project, projectTbl, properties={
> 'compounds':relation(Compound, secondary=cpdProjAssoc,
> backref='projects')
> })
>
> I have created a method to save projects which takes a Project object
> as an argument:
>
> def addProject(project):
> sess = Session()
> try:
> sess.save_or_update(project)
> except Exception:
> sess.rollback()
> print 'Error encountered trying to insert project ' +
> project.project
> else:
> sess.commit()
>
> I next create a list of projects, iterate over them, attempting to
> save them:
>
> projects = []
> projects.append(Project('None'))
> projects.append(Project('Proj1'))
> projects.append(Project('Proj2'))
> projects.append(Project('Proj3'))
>
> for p in projects:
> addProject(p)
>
> Unfortunately, when I iterate over the list and attempt to save each
> project, I get the following error message:
>
> FlushError: New instance [EMAIL PROTECTED] with identity key (<class
> 'Project'>, (None,), None) conflicts with persistent instance
> [EMAIL PROTECTED]
>
> Is part of my problem the fact that I have a trigger defined in the
> database to increment the primary key of the project table? Any idea
> what could be at issue here?
>
> Joann
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
