Commits

Andrew Martinez committed c11bba3

Optional sequence definition the cache table. Oracle doesn't support auto
incrementing ids. For other databases the definition sequence option is ignored.

Comments (0)

Files changed (1)

beaker/ext/database.py

             meta = DatabaseNamespaceManager.metadatas.get(meta_key, make_meta)
             # Create the table object and cache it now
             cache = sa.Table(table_name, meta,
-                             sa.Column('id', types.Integer, primary_key=True),
+                             sa.Column('id', types.Integer, sa.Sequence('%s_seq' % table_name, optional=True),primary_key=True),
                              sa.Column('namespace', types.String(255), nullable=False),
                              sa.Column('accessed', types.DateTime, nullable=False),
                              sa.Column('created', types.DateTime, nullable=False),