[SQL-CVS] r2016 - in SQLObject/trunk/sqlobject: firebird maxdb mssql mysql sybase tests

[<sub...@co...>]

Author: phd
Date: 2006-10-12 07:47:59 -0600 (Thu, 12 Oct 2006)
New Revision: 2016

Modified:
   SQLObject/trunk/sqlobject/firebird/firebirdconnection.py
   SQLObject/trunk/sqlobject/maxdb/maxdbconnection.py
   SQLObject/trunk/sqlobject/mssql/mssqlconnection.py
   SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
   SQLObject/trunk/sqlobject/sybase/sybaseconnection.py
   SQLObject/trunk/sqlobject/tests/dbtest.py
   SQLObject/trunk/sqlobject/tests/test_auto.py
Log:
Get column's dbName from the DB.


Modified: SQLObject/trunk/sqlobject/firebird/firebirdconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/firebird/firebirdconnection.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/firebird/firebirdconnection.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -196,6 +196,7 @@
                 continue
             colClass, kw = self.guessClass(t, flength, fscale)
             kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
+            kw['dbName'] = field
             kw['notNone'] = not nullAllowed
             kw['default'] = thedefault
             results.append(colClass(**kw))

Modified: SQLObject/trunk/sqlobject/maxdb/maxdbconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/maxdb/maxdbconnection.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/maxdb/maxdbconnection.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -261,6 +261,7 @@
 
             colClass, kw = self.guessClass(data_type,data_len,data_scale)
             kw['name'] = field_name
+            kw['dbName'] = field
 
             if nullAllowed == 'Y' :
                 nullAllowed=False

Modified: SQLObject/trunk/sqlobject/mssql/mssqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mssql/mssqlconnection.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/mssql/mssqlconnection.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -218,6 +218,7 @@
             # precision is needed for decimal columns
             colClass, kw = self.guessClass(t, size, precision, scale)
             kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
+            kw['dbName'] = field
             kw['notNone'] = not nullAllowed
             if (defaultText):
                 # Strip ( and )

Modified: SQLObject/trunk/sqlobject/mysql/mysqlconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/mysql/mysqlconnection.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/mysql/mysqlconnection.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -194,6 +194,7 @@
                 colClass = col.UnicodeCol
                 if self.dbEncoding: kw['dbEncoding'] = self.dbEncoding
             kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
+            kw['dbName'] = field
             kw['notNone'] = not nullAllowed
             if default and t.startswith('int'):
                 kw['default'] = int(default)

Modified: SQLObject/trunk/sqlobject/sybase/sybaseconnection.py
===================================================================
--- SQLObject/trunk/sqlobject/sybase/sybaseconnection.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/sybase/sybaseconnection.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -144,6 +144,7 @@
                 continue
             colClass, kw = self.guessClass(t)
             kw['name'] = soClass.sqlmeta.style.dbColumnToPythonAttr(field)
+            kw['dbName'] = field
             kw['notNone'] = not nullAllowed
             kw['default'] = default
             # @@ skip key...

Modified: SQLObject/trunk/sqlobject/tests/dbtest.py
===================================================================
--- SQLObject/trunk/sqlobject/tests/dbtest.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/tests/dbtest.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -36,7 +36,7 @@
     '+exceptions': 'mysql sqlite',
     '-transactions': 'mysql',
     '-dropTableCascade': 'sybase mssql',
-    '-fromDatabase': 'sqlite sybase firebird',
+    '-fromDatabase': 'sqlite',
     '-expressionIndex': 'mysql sqlite firebird mssql',
     '-blobData': 'mssql',
     '-decimalColumn': 'mssql',

Modified: SQLObject/trunk/sqlobject/tests/test_auto.py
===================================================================
--- SQLObject/trunk/sqlobject/tests/test_auto.py	2006-10-11 20:42:16 UTC (rev 2015)
+++ SQLObject/trunk/sqlobject/tests/test_auto.py	2006-10-12 13:47:59 UTC (rev 2016)
@@ -174,3 +174,7 @@
         assert jane.longField == 'x'*1000
         del classregistry.registry(
             AutoTest.sqlmeta.registry).classes['AutoTest']
+
+        columns = AutoTest.sqlmeta.columns
+        assert columns["lastName"].dbName == "last_name"
+        assert columns["wannahavefun"].dbName == "wannahavefun"