[gnue] r7789 - in trunk/gnue-common/src/datasources/drivers/sql: interbase maxdb mysql oracle postgresql sqlite2

[reinhard]

Author: reinhard
Date: 2005-08-05 14:40:56 -0500 (Fri, 05 Aug 2005)
New Revision: 7789

Modified:
   trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py
   trunk/gnue-common/src/datasources/drivers/sql/maxdb/Behavior.py
   trunk/gnue-common/src/datasources/drivers/sql/mysql/Behavior.py
   trunk/gnue-common/src/datasources/drivers/sql/oracle/Behavior.py
   trunk/gnue-common/src/datasources/drivers/sql/postgresql/Behavior.py
   trunk/gnue-common/src/datasources/drivers/sql/sqlite2/Behavior.py
Log:
Committed what I forgot before.


Modified: trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py 
2005-08-05 19:04:01 UTC (rev 7788)
+++ trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py 
2005-08-05 19:40:56 UTC (rev 7789)
@@ -60,11 +60,11 @@
     self._GENFIELD = re.compile ('^.*NEW\.(\w+)\s*=\s*GEN_ID\s*\(.*\)',
         re.IGNORECASE)
 
-    self._maxIdLength_  = 31
-    self._alterMultiple_= False
-    self._maxVarchar    = 10921
-    self._numbers_      = [[(4, 'SMALLINT'), (9, 'INTEGER')], "NUMERIC(%s)",
-                           "NUMERIC (%(length)s,%(scale)s)"]
+    self._maxIdLength_   = 31
+    self._alterMultiple_ = False
+    self._maxVarchar     = 10921
+    self._numbers_       = [[(4, 'SMALLINT'), (9, 'INTEGER')], "NUMERIC(%s)",
+                            "NUMERIC (%(length)s,%(scale)s)"]
 
     self._type2native_ ['datetime'] = 'timestamp'
     self._type2native_ ['boolean']  = 'boolean'

Modified: trunk/gnue-common/src/datasources/drivers/sql/maxdb/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/maxdb/Behavior.py     
2005-08-05 19:04:01 UTC (rev 7788)
+++ trunk/gnue-common/src/datasources/drivers/sql/maxdb/Behavior.py     
2005-08-05 19:40:56 UTC (rev 7789)
@@ -55,12 +55,12 @@
                      # 'SYNONYM': {'type': 'synonym', 'name': _('Synonyms')},
                      # 'RESULT' : {'type': 'result' , 'name': _('Result 
Table')}
                      }
+    self._maxVarchar  = 3999
 
     self._maxIdLength_ = 32
-    self._maxVarchar  = 3999
-    self._numbers_ = [[(5, 'SMALLINT'), (10, 'INTEGER')],
-                     "FIXED (%s)",
-                     "FIXED (%(length)s,%(scale)s)"]
+    self._numbers_     = [[(5, 'SMALLINT'), (10, 'INTEGER')],
+                          "FIXED (%s)",
+                          "FIXED (%(length)s,%(scale)s)"]
 
     self._type2native_.update ({'boolean' : 'BOOLEAN',
                                 'datetime': 'TIMESTAMP'})

Modified: trunk/gnue-common/src/datasources/drivers/sql/mysql/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/mysql/Behavior.py     
2005-08-05 19:04:01 UTC (rev 7788)
+++ trunk/gnue-common/src/datasources/drivers/sql/mysql/Behavior.py     
2005-08-05 19:40:56 UTC (rev 7789)
@@ -69,8 +69,8 @@
       self._TYPEMAP [t] = ('number', 'number')
 
     self._maxIdLength_ = 64
-    self._numbers_      = [[(4, 'smallint'), (9, 'int'), (18, 'bigint')],
-                         "decimal (%s,0)", "decimal (%(length)s,%(scale)s)"]
+    self._numbers_     = [[(4, 'smallint'), (9, 'int'), (18, 'bigint')],
+                          "decimal (%s,0)", "decimal (%(length)s,%(scale)s)"]
 
     self._type2native_ ['boolean'] = "tinyint (1) unsigned"
 

Modified: trunk/gnue-common/src/datasources/drivers/sql/oracle/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/oracle/Behavior.py    
2005-08-05 19:04:01 UTC (rev 7788)
+++ trunk/gnue-common/src/datasources/drivers/sql/oracle/Behavior.py    
2005-08-05 19:40:56 UTC (rev 7789)
@@ -57,10 +57,10 @@
      'all_view'    : {'type': 'allview',     'name': _('System Views')},
      'all_synonym' : {'type': 'allsynonym',  'name': _('System Synonyms')}}
 
-    self._pkPrecision   = 10
-    self._maxIdLength_  = 31
-    self._alterMultiple_= False
-    self._numbers_      = [[], "number (%s)", "number (%(length)s,%(scale)s)"]
+    self._pkPrecision    = 10
+    self._maxIdLength_   = 31
+    self._alterMultiple_ = False
+    self._numbers_       = [[], "number (%s)", "number (%(length)s,%(scale)s)"]
 
     self._type2native_.update ({'datetime': 'date', 'time': 'date'})
 

Modified: trunk/gnue-common/src/datasources/drivers/sql/postgresql/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/postgresql/Behavior.py        
2005-08-05 19:04:01 UTC (rev 7788)
+++ trunk/gnue-common/src/datasources/drivers/sql/postgresql/Behavior.py        
2005-08-05 19:40:56 UTC (rev 7789)
@@ -52,10 +52,10 @@
     self._RELKIND = {'v': {'type': 'view',  'name': _("Views")},
                      'r': {'type': 'table', 'name': _("Tables")}}
 
-    self._maxIdLength_  = 31
-    self._alterMultiple_= False
-    self._numbers_      = [[(4, 'smallint'), (9, 'integer'), (18, 'bigint')],
-                           "numeric (%s,0)", "numeric (%(length)s,%(scale)s)"]
+    self._maxIdLength_   = 31
+    self._alterMultiple_ = False
+    self._numbers_       = [[(4, 'smallint'), (9, 'integer'), (18, 'bigint')],
+                            "numeric (%s,0)", "numeric (%(length)s,%(scale)s)"]
 
     # Build  typemap: {nativetype: (group, fieldtype)}
     self._TYPEMAP = {'date'  : ('date', 'date'),

Modified: trunk/gnue-common/src/datasources/drivers/sql/sqlite2/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/sqlite2/Behavior.py   
2005-08-05 19:04:01 UTC (rev 7788)
+++ trunk/gnue-common/src/datasources/drivers/sql/sqlite2/Behavior.py   
2005-08-05 19:40:56 UTC (rev 7789)
@@ -93,15 +93,17 @@
 
     DBSIG2.Behavior.__init__ (self, connection)
 
-    self._maxIdLength_ = 31
-    self._alterMutliple = False
-    self._numbers_ = [[(None, 'integer')], "", "numeric 
(%(length)s,%(scale)s)"]
+    self._maxIdLength_   = 31
+    self._alterMultiple_ = False
+    self._numbers_       = [[(None, 'integer')],
+                            "",
+                            "numeric (%(length)s,%(scale)s)"]
 
+    self._type2native_.update ({'boolean' : 'integer',
+                                'datetime': 'timestamp'})
+
     self._RELTYPE = {'table': {'type': 'table', 'name': _("Tables")},
                      'view' : {'type': 'view',  'name': _("Views")}}
-
-    self._type2native_.update ({'boolean' : 'integer',
-                                'datetime': 'timestamp'})
     self._passThroughTypes = ['date', 'datetime', 'time']