From 85ebe01349e0b4314d9e25cacc6701d6fed7b87e Mon Sep 17 00:00:00 2001 From: jakeogh Date: Sat, 27 Jun 2015 18:48:46 +0000 Subject: add NO MINVALUE and NO MAXVALUE support to Sequence() --- lib/sqlalchemy/sql/compiler.py | 4 ++++ lib/sqlalchemy/sql/schema.py | 4 ++-- 2 files changed, 6 insertions(+), 2 deletions(-) (limited to 'lib/sqlalchemy/sql') diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index b3fee60ec..f7aa02105 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -2303,6 +2303,10 @@ class DDLCompiler(Compiled): text += " MINVALUE %d" % create.element.minvalue if create.element.maxvalue is not None: text += " MAXVALUE %d" % create.element.maxvalue + if create.element.nominvalue is not None: + text += " NO MINVALUE" % create.element.nominvalue + if create.element.nomaxvalue is not None: + text += " NO MAXVALUE" % create.element.nomaxvalue return text def visit_drop_sequence(self, drop): diff --git a/lib/sqlalchemy/sql/schema.py b/lib/sqlalchemy/sql/schema.py index ef84d2680..ccec74a35 100644 --- a/lib/sqlalchemy/sql/schema.py +++ b/lib/sqlalchemy/sql/schema.py @@ -2041,8 +2041,8 @@ class Sequence(DefaultGenerator): is_sequence = True def __init__(self, name, start=None, increment=None, minvalue=None, - maxvalue=None, schema=None, optional=False, quote=None, - metadata=None, quote_schema=None, + maxvalue=None, nominvalue=None, nomaxvalue=None, schema=None, + optional=False, quote=None, metadata=None, quote_schema=None, for_update=False): """Construct a :class:`.Sequence` object. -- cgit v1.2.1