Re: [sqlalchemy] Multiple tables and foreignkey constraints

2014-07-19 Thread Michael Bayer
On Jul 18, 2014, at 6:08 PM, Ken Roberts wrote: > I'm having fun trying to visualize this in my head, but I have 4 tables, 3 > are basic relations, but the 4th table links to table 2. > > Should I take the 4th table and have a relation join with all 3 tables or can > I just relate to table 2

Re: [sqlalchemy] change Oracle sequence on insert

2014-07-19 Thread Michael Bayer
On Jul 19, 2014, at 3:38 AM, Ofir Herzas wrote: > I have a table with the following column: > > id = sa.Column(sa.Integer, sa.Sequence('id_seq'), primary_key=True, > nullable=False) > Usually, I have no problems inserting data, but every time I insert rows with > specific id, it causes proble

[sqlalchemy] change Oracle sequence on insert

2014-07-19 Thread Ofir Herzas
I have a table with the following column: id = sa.Column(sa.Integer, sa.Sequence('id_seq'), primary_key=True, nullable=False) Usually, I have no problems inserting data, but every time I insert rows with specific id, it causes problems with Oracle since the sequence is not modified according