Thread: [SQLObject] Set BLOBCol "size"
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Sam W. <leg...@gm...> - 2005-11-11 19:13:25
|
Is it possible to define what size (i.e. MEDIUMBLOB) SQLObject creates for = a BLOBCol (specifically for MySQL)? example (from TurboGears): class Book(SQLObject): isbn =3D StringCol(length=3D13, alternateID=3DTrue) title =3D StringCol(length=3D100) description =3D StringCol() authors =3D RelatedJoin('Author') binvar =3D BLOBCol() Will create a TINYBLOB column in the actual database, but I need a MEDIUMBLOB. If I can't specify the size directly with SQLObject, is there any problem with just modifying it with MySQL? Regards, Sam |
From: Oleg B. <ph...@ma...> - 2005-11-11 19:24:16
|
On Fri, Nov 11, 2005 at 01:13:15PM -0600, Sam Williams wrote: > Is it possible to define what size (i.e. MEDIUMBLOB) SQLObject creates for a > BLOBCol (specifically for MySQL)? It is. class Book(SQLObject): isbn = StringCol(length=13, alternateID=True) binvar = BLOBCol(length=2**16, varchar=False) Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Sam W. <leg...@gm...> - 2005-11-11 19:29:45
|
Oleg, Thanks for the extremely quick reply! I missed the varchar=3DFalse option. (I tried the length=3D2**16, but got a= text field). This worked. Regards, Sam On 11/11/05, Oleg Broytmann <ph...@ma...> wrote: > > On Fri, Nov 11, 2005 at 01:13:15PM -0600, Sam Williams wrote: > > Is it possible to define what size (i.e. MEDIUMBLOB) SQLObject creates > for a > > BLOBCol (specifically for MySQL)? > > It is. > > class Book(SQLObject): > isbn =3D StringCol(length=3D13, alternateID=3DTrue) > binvar =3D BLOBCol(length=3D2**16, varchar=3DFalse) > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > |