cool, thanks a lot for the info, I'll check that.
__
Piensa en el medio ambiente - mantenlo en la pantalla. NO lo imprimas si NO es
necesario.
Think green - keep it on the screen. Do NOT print if it is NOT necessary.
Denken Sie an die Umwelt - bewahren Sie es auf dem Bildschirm. Drucken Sie
NICHT, wenn es NICHT notwendig ist.
From: mike...@zzzcomputing.com
Subject: Re: [sqlalchemy] tsvector
Date: Wed, 5 Dec 2012 18:31:37 -0500
To: sqlalchemy@googlegroups.com
sanjay's approach there is hardcoded SQL which isn't necessary with SQLAlchemy
(though always supported as a quick approach to something).
tsvector here as a type can be implemented with UserDefinedType:
http://docs.sqlalchemy.org/en/rel_0_8/core/types.html#sqlalchemy.types.UserDefinedType
and the operators I see at
http://www.postgresql.org/docs/8.3/static/functions-textsearch.html can be
implemented using op():
column.op('@@@')(func.to_tsvector("some value"))
that's a little verbose, so those operations can be implemented as operators
that are part of the tsvector type, using the techniques described at
http://docs.sqlalchemy.org/en/rel_0_8/core/types.html#redefining-and-creating-new-operators
.
All of this can and should be part of SQLAlchemy at some point, with external
types like these we usually rely on volunteers, such as the recent HSTORE
contribution. The HSTORE module here is a great place to see an example of a
richly functional type:
http://hg.sqlalchemy.org/sqlalchemy/file/4abc02fbc36b/lib/sqlalchemy/dialects/postgresql/hstore.py
On Dec 5, 2012, at 5:37 PM, Gery . wrote:I was searching in google about
tsvector (postgresql) implemented in sqlalchemy or geoalchemy but seems to me
that it's not implemented yet. After searching for it in [1], it didn't
matchanything. Sanjay, however, gives a way to do this [2] but seems confusing
to me, is it possible to use this tsvector as simple as someone using types
such as integer, small integer, etc etc? if so, it'd be cool to know how.
Thanks,
[1]
http://docs.sqlalchemy.org/en/rel_0_8/search.html?q=tsvector&check_keywords=yes&area=default
[2] https://groups.google.com/forum/?fromgroups=#!topic/sqlalchemy/Dns28KksD-4
__
Piensa en el medio ambiente - mantenlo en la pantalla. NO lo imprimas si NO es
necesario.
Think green - keep it on the screen. Do NOT print if it is NOT necessary.
Denken Sie an die Umwelt - bewahren Sie es auf dem Bildschirm. Drucken Sie
NICHT, wenn es NICHT notwendig ist.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@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.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@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.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@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.