From 4b6e1a40e5008b369c8da558e51cd8be07cf2c26 Mon Sep 17 00:00:00 2001 From: Lele Gaifax Date: Mon, 12 May 2008 15:33:55 +0000 Subject: [PATCH] Check for the presence of the Firebird generator, when creating/dropping a sequence --- lib/sqlalchemy/databases/firebird.py | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/lib/sqlalchemy/databases/firebird.py b/lib/sqlalchemy/databases/firebird.py index 3377a60048..948e001d53 100644 --- a/lib/sqlalchemy/databases/firebird.py +++ b/lib/sqlalchemy/databases/firebird.py @@ -649,8 +649,9 @@ class FBSchemaGenerator(sql.compiler.SchemaGenerator): def visit_sequence(self, sequence): """Generate a ``CREATE GENERATOR`` statement for the sequence.""" - self.append("CREATE GENERATOR %s" % self.preparer.format_sequence(sequence)) - self.execute() + if not self.checkfirst or not self.dialect.has_sequence(self.connection, sequence.name): + self.append("CREATE GENERATOR %s" % self.preparer.format_sequence(sequence)) + self.execute() class FBSchemaDropper(sql.compiler.SchemaDropper): @@ -659,8 +660,9 @@ class FBSchemaDropper(sql.compiler.SchemaDropper): def visit_sequence(self, sequence): """Generate a ``DROP GENERATOR`` statement for the sequence.""" - self.append("DROP GENERATOR %s" % self.preparer.format_sequence(sequence)) - self.execute() + if not self.checkfirst or self.dialect.has_sequence(self.connection, sequence.name): + self.append("DROP GENERATOR %s" % self.preparer.format_sequence(sequence)) + self.execute() class FBDefaultRunner(base.DefaultRunner): -- 2.47.3