the TsVector type looks perfect! if you were to package that up for inclusion, it would likely subclass TypeEngine and you’d implement PGTypeCompiler.visit_TSVECTOR. we appear to have a little bit of “tsvector” code already (we implement the “match” operator as "%s @@ to_tsquery(%s)” ) but not the full type.
On Dec 2, 2013, at 7:31 AM, Noufal Ibrahim <[email protected]> wrote:
> Hello everyone,
>
> I've been trying to get the postgreSQL tsvector type work with SQLAlchemy
> without dropping into raw SQL. I was mostly interested in queries and the DDL
> to create the initial table.
>
> Through some trial and error, I have a setup working which I've detailed
> here
> http://nibrahim.net.in/2013/11/29/sqlalchemy_and_full_text_searching_in_postg
> resql.html
>
> My experience with SQLAlchemy is limited so if someone here has some
> feedback, I can polish this out and hopefully contribute it back to the
> postgresql dialect module.
>
> Thanks!
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
signature.asc
Description: Message signed with OpenPGP using GPGMail
