[sqlalchemy] Re: question on use of postgres:tsvector - robert rottermann - com.googlegroups.sqlalchemy

3 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: question on use of p...

From	Sent On	Attachments
robert rottermann	26 May 2008 23:04
Sanjay	27 May 2008 01:16
robert rottermann	27 May 2008 01:43

Subject:	[sqlalchemy] Re: question on use of postgres:tsvector
From:	robert rottermann (rob...@redcor.ch)
Date:	05/27/2008 01:43:51 AM
List:	com.googlegroups.sqlalchemy

thanks Sanjay robert

Sanjay schrieb:

We have not defined the search tables in SQLAlchemy, and use metadata.engine.text to issue query. Something like this:

topic_id_rows = metadata.engine.text(""" SELECT distinct forum_topic.topic_id FROM forum_topic JOIN forum_post ON forum_topic.topic_id = forum_post.topic_id WHERE forum_topic.forum_id = """ + str(forum.forum_id) + " AND (idxfti @@ to_tsquery('simple', '" + search_query + "'" + "));" ).execute().fetchall()