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 create virtual table statements on the DB. I can then use the match() filter and it seems fine. It would be great to have a way to do this without having to manually mod the db. BTW, I was also trying to see if I could add a custom SchemaItem object as the first object in the Table constructor after the metadata field; thinking it could generate the USING FTS3 part. I'm I right that this is the wrong way to think about SchemaItem's, I could not get anywhere with the idea. Thanks again, loving sqlalchemy! On Jan 6, 3:58 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > 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 > > uses fts3, assuming the underlying pysqlite implementation supports > > it? > > > I see the Table class has a 'prefixes' param that could be used to > > specify the VIRTUAL keyword, but 'using FTS3' would need to also be > > added after the table name as well. > > > Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
