I need schema support and "it works at all" support in MySQL, so I had
to change these things. It was'n't "character_Set_results" it was
"character_set_results". The older MySQL 4? doesn't have this value at
all. Hopefully I will be fully upgraded in a few weeks.

MySQL 4.0.24:

show variables like 'char%';

| character_set  |
| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8
dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian
koi8_ru koi8_ukr latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7
win1250 win1251ukr win1251 |

The "table exists" function sucks. Is raising an error necessarily
catastrophic here?

Index: lib/sqlalchemy/databases/mysql.py
--- lib/sqlalchemy/databases/mysql.py   (revision 2550)
+++ lib/sqlalchemy/databases/mysql.py   (working copy)
@@ -367,7 +367,13 @@
         # i have tried dozens of approaches here with no luck.
statements like
         # DESCRIBE and SHOW CREATE TABLE work better, but they raise
an error when
         # the table does not exist.
-        cursor = connection.execute("show table status like %s",
+        if schema: # dwh MySQL schema hack...
+            default = connection.execute("select
+            connection.execute("USE %s" % schema)
+            cursor = connection.execute("show table status like %s",
+            connection.execute("USE %s" % default)
+        else:
+            cursor = connection.execute("show table status like %s",
         return bool( not not cursor.rowcount )

     def reflecttable(self, connection, table):
@@ -377,7 +383,7 @@
             cs = cs.tostring()
         case_sensitive = int(cs) == 0

-        decode_from = connection.execute("show variables like
+        decode_from = connection.execute("show variables like

         if not case_sensitive:
             table.name = table.name.lower()

You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 

Reply via email to