diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-29 18:01:45 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-29 18:01:45 +0000 |
| commit | 2dff6b382c5659a350a636a755e52452c195c7dd (patch) | |
| tree | 0f7329797bafe55719d319051c76378a12040a7b /lib/sqlalchemy/ansisql.py | |
| parent | 6fb04d6828bf99aaf8a7ef7ce94ae13bc800ac16 (diff) | |
| download | sqlalchemy-2dff6b382c5659a350a636a755e52452c195c7dd.tar.gz | |
Diffstat (limited to 'lib/sqlalchemy/ansisql.py')
| -rw-r--r-- | lib/sqlalchemy/ansisql.py | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py index 22ea7e61d..a55197540 100644 --- a/lib/sqlalchemy/ansisql.py +++ b/lib/sqlalchemy/ansisql.py @@ -201,9 +201,8 @@ class ANSICompiler(sql.Compiled): self.froms[select] = "(" + text + ")" - def visit_table(self, table): - self.froms[table] = table.name + self.froms[table] = table.fullname self.strings[table] = "" def visit_join(self, join): @@ -226,7 +225,7 @@ class ANSICompiler(sql.Compiled): self.binds[b.key] = b self.binds[b.shortname] = b - text = ("INSERT INTO " + insert_stmt.table.name + " (" + string.join([c[0].name for c in colparams], ', ') + ")" + + text = ("INSERT INTO " + insert_stmt.table.fullname + " (" + string.join([c[0].name for c in colparams], ', ') + ")" + " VALUES (" + string.join([self.bindparam_string(c[1].key) for c in colparams], ', ') + ")") self.strings[insert_stmt] = text @@ -245,7 +244,7 @@ class ANSICompiler(sql.Compiled): else: return self.get_str(p) - text = "UPDATE " + update_stmt.table.name + " SET " + string.join(["%s=%s" % (c[0].name, create_param(c[1])) for c in colparams], ', ') + text = "UPDATE " + update_stmt.table.fullname + " SET " + string.join(["%s=%s" % (c[0].name, create_param(c[1])) for c in colparams], ', ') if update_stmt.whereclause: text += " WHERE " + self.get_str(update_stmt.whereclause) @@ -253,7 +252,7 @@ class ANSICompiler(sql.Compiled): self.strings[update_stmt] = text def visit_delete(self, delete_stmt): - text = "DELETE FROM " + delete_stmt.table.name + text = "DELETE FROM " + delete_stmt.table.fullname if delete_stmt.whereclause: text += " WHERE " + self.get_str(delete_stmt.whereclause) @@ -270,7 +269,7 @@ class ANSISchemaGenerator(sqlalchemy.engine.SchemaIterator): raise NotImplementedError() def visit_table(self, table): - self.append("\nCREATE TABLE " + table.name + "(") + self.append("\nCREATE TABLE " + table.fullname + "(") separator = "\n" @@ -287,7 +286,7 @@ class ANSISchemaGenerator(sqlalchemy.engine.SchemaIterator): class ANSISchemaDropper(sqlalchemy.engine.SchemaIterator): def visit_table(self, table): - self.append("\nDROP TABLE " + table.name) + self.append("\nDROP TABLE " + table.fullname) self.execute() |