Sorry! Nevermind, your link answers that question.
Thanks. On Mar 26, 4:23 pm, Kent Bower <k...@retailarchitects.com> wrote: > Thanks for the info. > > Since it is NOCYCLE in oracle and NO CYCLE in postgres, I would check > the engine.dialect.name in the compile, method correct? > > if eng.dialect.name == 'oracle': > sql += " NOCYCLE" > elif eng.dialect.name == 'postgres': > sql += " NO CYCLE" > else: > raise Exception("RSequence is only implemented > for Oracle and PostgreSQL!") > > How do I get a hold of the engine from within a Sequence object? > > On 3/26/2010 2:26 PM, Michael Bayer wrote: > > > Kent wrote: > > >> Any plans to support MINVALUE, MAXVALUE, CYCLE, NOCYCLE for sequences > >> (for both postgres and oracle)? > > >> I've implemented a subclass of Sequence myself, but it isn't very > >> elegant, because I'm not familiar enough with the code to know which > >> methods to override for create() output. > > > correction: redefine the compilation for CreateSequence: > > > from sqlalchemy import * > > from sqlalchemy import schema > > from sqlalchemy.ext.compiler import compiles > > > class MySeq(Sequence): > > def __init__(self, *args, **kw): > > self.cycle = kw.pop('cycle', False) > > super(MySeq, self).__init__(*args, **kw) > > > @compiles(schema.CreateSequence) > > def compile(element, compiler, **kw): > > if isinstance(element.element, MySeq): > > return "CREATE SEQUENCE %s %s" % (element.element.name, > > element.element.cycle and "CYCLE" or "") > > else: > > return compiler.visit_create_sequence(element) > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "sqlalchemy" group. > >> To post to this group, send email to sqlalch...@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. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.