[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

[sqlalchemy] many to many extra fields and association object

2009-01-06 Thread drakkan
Hi all, I'm new to sqlalchemy, I'm using 0.5rc4 and I want to map a many to many relation with extra fields on the association table using declarative way, I read http://www.sqlalchemy.org/docs/05/mappers.html#association-object but there there is the non declarative way, here is what I have

[sqlalchemy] Re: many to many extra fields and association object

2009-01-06 Thread az
it does not know. for SA these are just 1:m and n:1, and there's no more semantics linking them. it's up to you, via assoc.proxy or else. dbcook.sf.net does support such semantics (explicit assoc) but it may have more initial overhead (and definitely less docs) - it depends how big your model

[sqlalchemy] Declarative and relation to self

2009-01-06 Thread Gennady Kovalev
Hi! I try to clean up my code, and read in google group about possibility create relation to self when class is not defined yet. I write example, but got an error (see below). My code is: cut engine = create_engine('sqlite:///:memory:', echo=True) Base =

[sqlalchemy] Re: Declarative and relation to self

2009-01-06 Thread Gennady Kovalev
On 6 янв, 23:05, Michael Bayer zzz...@gmail.com wrote: this was a bug in 0.5.0rc4 and is fixed in 0.5.0. On Jan 6, 2:49 pm, Gennady Kovalev gennady.kova...@gmail.com wrote: Hi! I try to clean up my code, and read in google group about possibility create relation to self when class is

[sqlalchemy] Re: Declarative and relation to self

2009-01-06 Thread Gennady Kovalev
On 6 янв, 23:05, Michael Bayer zzz...@gmail.com wrote: this was a bug in 0.5.0rc4 and is fixed in 0.5.0. Ohh, thank you. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group,

[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 uses

[sqlalchemy] Re: SQLAlchemy 0.5 Released

2009-01-06 Thread David Gardner
This is awesome, today I was setting up a server to go in production for next week. Michael Bayer wrote: Hello list - I am pleased to announce the release of SQLAlchemy 0.5.0, the first official release in the 0.5 series. This series has been in the making since the Pycon 2008

[sqlalchemy] Re: SQLAlchemy 0.5 Released

2009-01-06 Thread Doug Farrell
Michael, Congratulations on the release! I look forward to giving it a spin! Doug --~--~-~--~~~---~--~~ 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

[sqlalchemy] Need help with UnmappedColumnError

2009-01-06 Thread Svenn Helge Grindhaug
Hi, I have 2 mappers: mapper(Assembly, tables['assembly'], properties=dict( clusters=relation(classes['cluster'], cascade='all,delete,delete', passive_deletes=True,

[sqlalchemy] Re: Need help with UnmappedColumnError

2009-01-06 Thread Michael Bayer
need a full test case. i dont see any mention of cluster's definition or project below. On Jan 6, 2009, at 5:56 PM, Svenn Helge Grindhaug wrote: Hi, I have 2 mappers: mapper(Assembly, tables['assembly'], properties=dict(

[sqlalchemy] new warning with 0.5.0

2009-01-06 Thread David Gardner
I got a new warning with 0.5.0 that I didn't receive with 0.5rc4 /users/dgardner/dev/lib/python2.5/site-packages/SQLAlchemy-0.5.0-py2.5.egg/sqlalchemy/engine/base.py:1265: SAWarning: Skipped unsupported reflection of expression-based index not_done_idx self.dialect.reflecttable(conn, table,

[sqlalchemy] mssql subselects (SA .03) - conflicting alias names?

2009-01-06 Thread statemachine
(I'm sure this problem has been addresses, but I can't find anything specific on it through normal support resources.) First, we're running an older version out of necessity: 0.3.11 (we haven't had the time to upgrade our core libraries to use newer versions yet). I'm hoping that someone has

[sqlalchemy] Re: mssql subselects (SA .03) - conflicting alias names?

2009-01-06 Thread Michael Bayer
how does the query come out on SQLite ? the MSSQL dialect does some more manipulation on selectables particularly when there is limit, which is probably broken for that query in 0.3 (the SQL is definitely incorrect as contacts_3457 is not stated correctly). The level of nesting and