From 7ff10255bc5e98f651dd4602c0c393b5cda50ca8 Mon Sep 17 00:00:00 2001 From: test Date: Tue, 1 Dec 2015 17:25:48 +0300 Subject: add compatible MS SQL Server 2012 sequences --- lib/sqlalchemy/dialects/mssql/base.py | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'lib/sqlalchemy/dialects/mssql/base.py') diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 1ee328e83..01229e637 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -1049,6 +1049,12 @@ class MSSQLCompiler(compiler.SQLCompiler): return compiler.SQLCompiler.get_select_precolumns( self, select, **kw) + def visit_sequence(self, sequence): + if self.dialect.server_version_info >= MS_2012_VERSION: + return "NEXT VALUE FOR {0}".format(self.dialect.identifier_preparer.format_sequence(sequence)) + else: + return super(MSSQLCompiler, self).visit_sequence(sequence) + def get_from_hint_text(self, table, text): return text -- cgit v1.2.1