[Sqlalchemy-users] oracle vs SQLite/MySQL primary key usage

2006-06-16 Thread Valentin Kuznetsov
Hi, I'm trying to port my apps to use ORACLE. So, I have a table, e.g. t_primary_dataset which defined as: t_primary_dataset = Table('t_primary_dataset', engine, Column('id', Integer, nullable = False, primary_key = True), Column('name', String(100), nullable = False) ) I defined class (in ca

Re: [Sqlalchemy-users] oracle vs SQLite/MySQL primary key usage

2006-06-16 Thread Valentin Kuznetsov
Hi, sorry for a little smap, but I found solution in API section. I just modified my Table declaration to use sequence as: seq_primary_dataset = Sequence(name='seq_primary_dataset',start=1,increment=True) t_primary_dataset = Table('t_primary_dataset', DBS_DB, Column('id', Integer, Sequence('seq_p