def getDaboFieldType(self, backendFieldType):
import MySQLdb.constants.FIELD_TYPE as ftypes
typeMapping = {}
for i in dir(ftypes):
if i[0] != "_":
v = getattr(ftypes, i)
typeMapping[v] = i
print backendFieldType, typeMapping
16 {0: 'DECIMAL', 1: 'TINY', 2: 'SHORT', 3: 'LONG', 4: 'FLOAT', 5: 'DOUBLE', 6:
'NULL', 7: 'TIMESTAMP', 8: 'LONGLONG', 9: 'INT24', 10: 'DATE', 11: 'TIME', 12:
'DATETIME', 13: 'YEAR', 14: 'NEWDATE', 246: 'NEWDECIMAL', 247: 'INTERVAL', 248:
'SET', 249: 'TINY_BLOB', 250: 'MEDIUM_BLOB', 251: 'LONG_BLOB', 252: 'BLOB',
253:
'VAR_STRING', 254: 'STRING', 255: 'GEOMETRY'}
import MySQLdb.constants.FIELD_TYPE as ftypes
dir(ftypes)
['BLOB', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'DOUBLE', 'ENUM', 'FLOAT',
'GEOMETRY', 'INT24', 'INTERVAL', 'LONG', 'LONGLONG', 'LONG_BLOB',
'MEDIUM_BLOB',
'NEWDATE', 'NEWDECIMAL', 'NULL', 'SET', 'SHORT', 'STRING', 'TIME', 'TIMESTAMP',
'TINY', 'TINY_BLOB', 'VAR_STRING', 'YEAR', '__builtins__', '__doc__',
'__file__', '__name__']
added this, now I can add data: typeMapping[16]='BIT'
I am sure there is a better way, but here you go:
[EMAIL PROTECTED]:~/dabo/dabo/dabo/db$ svn diff dbMySQL.py
Index: dbMySQL.py
===================================================================
--- dbMySQL.py (revision 2547)
+++ dbMySQL.py (working copy)
@@ -160,6 +160,9 @@
if i[0] != "_":
v = getattr(ftypes, i)
typeMapping[v] = i
+ typeMapping[16]='BIT'
+
+ print backendFieldType, typeMapping
daboMapping = {"BIT": "I",
"BLOB": "M",
[EMAIL PROTECTED]:~/dabo/dabo/dabo/db$
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
