diff options
Diffstat (limited to 'lib/sqlalchemy/ansisql.py')
| -rw-r--r-- | lib/sqlalchemy/ansisql.py | 19 |
1 files changed, 17 insertions, 2 deletions
diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py index 53c6db6c4..f77e855e4 100644 --- a/lib/sqlalchemy/ansisql.py +++ b/lib/sqlalchemy/ansisql.py @@ -774,7 +774,15 @@ class ANSIIdentifierPreparer(schema.SchemaVisitor): self.__strings[column] = self._quote_identifier(column.name) else: self.__strings[column] = column.name - + + def visit_sequence(self, sequence): + if sequence in self.__visited: + return + if sequence.quote or self._requires_quotes(sequence.name, sequence.natural_case): + self.__strings[sequence] = self._quote_identifier(sequence.name) + else: + self.__strings[sequence] = sequence.name + def __analyze_identifiers(self, obj): """insure that each object we encounter is analyzed only once for its lifetime.""" if obj in self.__visited: @@ -782,7 +790,11 @@ class ANSIIdentifierPreparer(schema.SchemaVisitor): if isinstance(obj, schema.SchemaItem): obj.accept_schema_visitor(self) self.__visited[obj] = True - + + def __prepare_sequence(self, sequence): + self.__analyze_identifiers(sequence) + return self.__strings.get(sequence, sequence.name) + def __prepare_table(self, table, use_schema=False): self.__analyze_identifiers(table) tablename = self.__strings.get(table, (table.name, None))[0] @@ -798,6 +810,9 @@ class ANSIIdentifierPreparer(schema.SchemaVisitor): else: return self.__strings.get(column, column.name) + def format_sequence(self, sequence): + return self.__prepare_sequence(sequence) + def format_table(self, table, use_schema=True): """Prepare a quoted table and schema name""" return self.__prepare_table(table, use_schema=use_schema) |