Re: [Modeling-users] MySQL TEXT

[Sebastien B. <sbi...@us...>]

> Yannick Gingras <yan...@sa...> wrote:
> > the user guide section 2.2.4 talk about CHAR and VARCHAR external t=
ype
> > support but there is no mention about the support for TEXT.  I have
> > really strange errors when using TEXT.
> >=20
> >   File "<stdin>", line 92, in insertElement
> >   File "/usr/lib/python2.2/site-packages/Modeling/EditingContext.py=
", line=20
> > 678, in saveChanges
> >     self.parentObjectStore().saveChangesInEditingContext(self)
> >   File "/usr/lib/python2.2/site-packages/Modeling/ObjectStoreCoordi=
nator.py",=20
> > line 559, in saveChangesInEditingContext
> >     raise RuntimeError, _error
> > RuntimeError: performChanges() failed on=20
> > <Modeling.DatabaseContext.DatabaseContext instance at 0x88dd2ec>:=20
> > exceptions.ValueError:Unknown value type: None for externalType: te=
xt=20
> > (attribute: JOBI18N.description)
> > [...]
>=20
> Yes, this is because TEXT is an unknown sql type for the MySQLAdaptor.
> Didn't the validation of the model indicate it ?-)
>=20
> (I agree the message is not very informative, I added bug #699046)

  =3D> fixed in CVS repository, SQLExpression v1.14

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/modeling/ProjectModeling=
/Modeling/SQLExpression.py?rev=3D1.14&only_with_tag=3DHEAD&content-type=
=3Dtext/vnd.viewcvs-markup

  The message is now clear enough I think:
InvalidSQLTypeError: SQL type: TEXT (attribute: JOBI18N.description) is=
 invalid for the current adaptor (valueTypeForExternalType returned: No=
ne)


-- S=E9bastien.