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.

Reply via email to