Hi!
I'm making some test using SQLObject with MySQL and I found that BLOBCol
is using a TEXT column. When I take a look to the code (col.py) I see:
class SOBLOBCol(SOStringCol):
def createValidators(self):
return [BinaryValidator(name=self.name)] + \
super(SOBLOBCol, self).createValidators()
def _mysqlType(self):
length = self.length
varchar = self.varchar
if length >= 2**24:
return varchar and "LONGTEXT" or "LONGBLOB"
if length >= 2**16:
return varchar and "MEDIUMTEXT" or "MEDIUMBLOB"
if length >= 2**8:
return varchar and "TEXT" or "BLOB"
return varchar and "TINYTEXT" or "TINYBLOB"
Since varchar is set to "auto"[1] by default, SQLObject is using TEXT as
a BLOBCol. Beside the "auto" thing which look like a bug (is it?), why it
is even the posibility to use a TEXT-like column with a BLOBCol in MySQL?
Is this a bug too?
For now, I'm using: blob = BLOBCol(length=2**24, varchar=False), but it
doesn't look natural at all.
[1] col.py again:
class SOStringLikeCol(SOCol):
"""A common ancestor for SOStringCol and SOUnicodeCol"""
def __init__(self, **kw):
self.length = popKey(kw, 'length')
self.varchar = popKey(kw, 'varchar', 'auto')
--
Leandro Lucarella (luca) | Blog colectivo: http://www.mazziblog.com.ar/blog/
.------------------------------------------------------------------------,
\ GPG: 5F5A8D05 // F8CD F9A7 BF00 5431 4145 104C 949E BFB6 5F5A 8D05 /
'--------------------------------------------------------------------'
MP: Qué tengo? B: 2 dedos de frente.
MP: No, en mi mano, Bellini. B: Un acoplado!
MP: No, escuche bien, eh... B: El pelo largo, Mario...
Se usa en la espalda.
MP: No! Es para cargar. B: Un hermano menor.
MP: No, Bellini! Se llena con B: Un chancho, Mario...
cualquier cosa.
MP: No, Bellini, no y no!
-- El Gran Bellini (Mario Podestá con una mochila)
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
