[sqlalchemy] Re: sqlite fts3

2009-01-09 Thread sol
: > 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 relevan

[sqlalchemy] Re: filtering a query based on a relation attribute

2009-01-08 Thread sol
; query(Event).filter(Event.message.has(Message.text.match(x)) > > On Jan 7, 2009, at 1:23 PM, sol wrote: > > > > > Using SA 0.5, sqlite, say I have the following : > > > Base = declarative_base() > > > class EventMessage(Base): > >    __tablename__ = 'even

[sqlalchemy] filtering a query based on a relation attribute

2009-01-07 Thread sol
Using SA 0.5, sqlite, say I have the following : Base = declarative_base() class EventMessage(Base): __tablename__ = 'event_message' id=Column(Integer,primary_key=True) sid=Column(Integer,primary_key=True) text=Column(Text) class Event(Base): __tablename_

[sqlalchemy] Re: sqlite fts3

2009-01-07 Thread sol
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

[sqlalchemy] sqlite fts3

2009-01-06 Thread sol
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 n

[sqlalchemy] colon in where clause when selecting mapped objects

2006-12-03 Thread Sol
Hello, for a somewhat more complex query I need to specify the where clause explicitly when selecting objects of a mapped class. Now how would one include constants with a colon in such a query? like: session().query(myclass).select("name = ':foo'") Any ide

[sqlalchemy] SQLError vs. FlushError

2006-11-10 Thread Sol
with the other object not in your session you get a SQLError. If you try to flush with a conflicts due to an unique constraint you alway get a SQLError. Bug or feature? -- Cheers, Sol. --~--~-~--~~~---~--~~ You received this message because you are subscribed to

[sqlalchemy] serializable transactions

2006-10-15 Thread Sol
Hello, how would I use serializable transactions with SA and Postgres? Is there something around that i missed? -- Cheers, Sol. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To po