[sqlalchemy] Re: sqlite fts3

2009-01-09 Thread Michael Bayer
yeah we'd go the easy route and all that is just inside the string, i.e. sqlite_using='fts3(content)'. On Jan 9, 2009, at 7:13 AM, sol wrote: > > Found a usage example for the sqlite ftp3, it is seems like the > specification can be a little more complicated then just the USING > FTS. Here ar

[sqlalchemy] Re: sqlite fts3

2009-01-09 Thread sol
Found a usage example for the sqlite ftp3, it is seems like the specification can be a little more complicated then just the USING FTS. Here are examples from the webpage: CREATE VIRTUAL TABLE t USING fts3; CREATE VIRTUAL TABLE t USING fts3(); CREATE VIRTUAL TABLE t USING fts3(content); C

[sqlalchemy] Re: sqlite fts3

2009-01-07 Thread Michael Bayer
for now I'd support this as Table(, sqlite_using='fts3'). On Jan 7, 2009, at 1:05 PM, Michael Trier wrote: > Hi, > > On Wed, Jan 7, 2009 at 6:11 AM, sol wrote: > > I'm not an sqlite guru, so I can only point to relevant doc's: > > http://www.sqlite.org/lang_createvtab.html > > The format af

[sqlalchemy] Re: sqlite fts3

2009-01-07 Thread Michael Trier
Hi, On Wed, Jan 7, 2009 at 6:11 AM, sol wrote: > > I'm not an sqlite guru, so I can only point to relevant doc's: > > http://www.sqlite.org/lang_createvtab.html > > The format after USING is > > module-name (module-arg-list) > > where the (module-arg-list) is optional. > > I got fts3 working b

[sqlalchemy] Re: sqlite fts3

2009-01-07 Thread sol
I'm not an sqlite guru, so I can only point to relevant doc's: http://www.sqlite.org/lang_createvtab.html The format after USING is module-name (module-arg-list) where the (module-arg-list) is optional. I got fts3 working by letting sqlalchemy do its thing and then issue explicit drop and

[sqlalchemy] Re: sqlite fts3

2009-01-06 Thread Michael Bayer
we might go with a sqlite-specific keyword such as sqlite_using here. Im not familiar with fts3, what are the full range of options for "CREATE VIRTUAL TABLE USING" in sqlite ? On Jan 6, 2009, at 7:59 AM, sol wrote: > > Is it possible to create a virtual sqlite table in sqlalchemy that >