-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Michael Bayer ha scritto: > [...] > In SQL (tested with PostgreSQL and SQLite, at least) I can do: > INSERT INTO test (text) values(to_tsvector('some text')); > > That is, it is possible to specify a scalar select statement for each > value. > > > Is this possible to do with SQLAlchemy? > > [...] >> OK you mean SQL expression during compilation. This is ticket #1534 >> which is not yet implemented.
After some tests I got something that works http://paste.pocoo.org/show/173099/ The documentation seems to confirm this: http://www.sqlalchemy.org/docs/reference/sqlalchemy/expressions.html#sqlalchemy.sql.expression.insert SQLAlchemy still continues to surprise me! I need to download the documentation in PDF format, and take some time study it. I don't know if an example of this feature is available in the tutorial; if not, it should be added. >Right now you'd have to set attributes to >> the to_tsvector() expression directly, note that the ORM and such accept >> SQL expressions as values. Which means if you're dealing just with ORM, >> you can use a @validates or similar (and maybe a comparator too) that >> wraps incoming values into to_tsvector(). It is 4 years that I don't touch the ORM ;-). The example in >> examples/postgis/postgis.py illustrates these techniques. > Thanks Manlio -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktogfkACgkQscQJ24LbaUSjwgCfevuSHb0YjMGNMFXhm+imJHqY YSsAn1wypa/GG86TfGHMIGbFvf9lctVN =eqiB -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.