Re: [Sqlalchemy-users] session trouble

2006-09-19 Thread William K. Volkman
Hello, On Mon, 2006-09-18 at 23:14, Jose Galvez wrote: snip uin = dbsession.query(model.Wsi).get_by(uin=image) if uin: xml = uin.xml else: uin=model.Wsi() uin.uin=image xml =

Re: [Sqlalchemy-users] logging user creation in separate table

2006-09-03 Thread William K. Volkman
in the process of defining the architecture for an audit process of a financial application so your question permitted an elucidation of a portion of the problem space) Cheers, William. William K. Volkman wrote: A follow on question I have is if the relationship is specified this way can you prevent

Re: [Sqlalchemy-users] logging user creation in separate table

2006-09-02 Thread William K. Volkman
A follow on question I have is if the relationship is specified this way can you prevent the deletion of the activity records when the account record is deleted? On Sat, 2006-09-02 at 11:25 -0400, Michael Bayer wrote: since your AccountActivity does have an actual relationship to the Account

Re: [Sqlalchemy-users] Problems with connection

2006-07-30 Thread William K. Volkman
On Sun, 2006-07-30 at 17:28 +0300, Joona Kulmala wrote: I'm having some problems with ActiveMapper and MySQL connection. I'm using SQLAlchemy on top of Twisted webserver. Everything works wmoothly when the site is used, but if the connection is unused for some time, the whole webserver

Re: [Sqlalchemy-users] How to find out which object causes an exception

2006-07-18 Thread William K. Volkman
On Tue, 2006-07-18 at 09:32, Michael Bayer wrote: On Jul 18, 2006, at 9:52 AM, Charles Duffy wrote: Anyhow, as I was saying, it looks like it should be possible to attach the object to the exception in Mapper.save_obj() so you can find out which object the issue is related to. The

Re: [Sqlalchemy-users] How to relate to a table having composite primary key

2006-07-14 Thread William K. Volkman
On Fri, 2006-07-14 at 10:46, Jonathan Ellis wrote: On 7/14/06, Jonathan LaCour [EMAIL PROTECTED] wrote: Really, when you think about it, defining the schema in the code is more adherent to DRY than autoloading, since instead of having 1 DDL script for

Re: [Sqlalchemy-users] UNIQUE constraint vs. UNIQUE index

2006-07-13 Thread William K. Volkman
Hi Michael, On Thu, 2006-07-13 at 14:54, Michael Bayer wrote: hey list - im working on explicit CONSTRAINT objects, primarily a FOREIGN KEY constraint which cleanly allows composite foreign keys that work in a CREATE statement. but while im adding ForeignKeyConstraint, im also adding

Re: [Sqlalchemy-users] trouble creating a new sqlite database

2006-07-01 Thread William K. Volkman
Hi Mike, On Sat, 2006-07-01 at 00:01 -0400, Michael Bayer wrote: i am mostly in favor of whatever rfc1738 says. though its not clear what path is. does foo/bar mean /foo/bar on disk ? or wherever you are/foo/bar ? its not so clear. intuition would say the former. however on pretty

Re: [Sqlalchemy-users] trouble creating a new sqlite database

2006-06-30 Thread William K. Volkman
On Thu, 2006-06-29 at 21:05, Daniel Miller wrote: Michael Bayer wrote: well, the url is broken out like this: dbtype:// / database Why is the third slash necessary if its not part of the path? I think the conventional way is to parse paths like this: Please refer to

Re: [Sqlalchemy-users] compatible with Python v2.2.1 and MySQLdb 0.9.2 ???

2006-06-28 Thread William K. Volkman
Hello, On Wed, 2006-06-28 at 12:40, Jens Diemer wrote: Jens Diemer schrieb: Is SQLAlchemy is compatible with Python v2.2.1 and MySQLdb 0.9.2 ??? I have patched the source and insert from __future__ import generators, so yield is available. I take sets.py from Python 2.4 But i have at

Re: [Sqlalchemy-users] how to retrieve comment?

2006-06-21 Thread William K. Volkman
On Wed, 2006-06-21 at 07:43, Sandro Dentella wrote: Is there an easy way, independant from the backend to retrieve the comments on fields of tables, if present? No way that I know that is independent of the backend. IIRC it is stored in the system tables and I don't recall seeing an

Re: [Sqlalchemy-users] querying for tables in a db

2006-06-06 Thread William K. Volkman
Hello Sandro, On Tue, 2006-06-06 at 01:25, Sandro Dentella wrote: Is there a way in sqlalchemy to query for a list of tables in a db that is portable among the different backends? I don't thhink so and one may argue is not something that should be provided by SA, but would be very

Re: [Sqlalchemy-users] Bug: Primary key constraint not correctly reflected from Postgres 7.3 databases

2006-06-06 Thread William K. Volkman
On Tue, 2006-06-06 at 10:43, Michael Bayer wrote: On Jun 5, 2006, at 11:50 PM, William K. Volkman wrote: Users of the tables, particularly web applications, are only granted the minimum SQL privileges necessary for their tasks. The capability to execute DDL operations would

Re: [Sqlalchemy-users] decimal type support in sqlalchemy

2006-06-05 Thread William K. Volkman
Hello, On Mon, 2006-06-05 at 14:39 -0400, Michael Bayer wrote: so. does that just mean instead of sending a dictionary to Dialect/create_engine(), we send a TypePolicy object ? This seems like a lot of overhead for very little gain as well as not solving the problem. In theory the DBAPI

[Sqlalchemy-users] Postgres URI syntax obtuse?

2006-04-16 Thread William K. Volkman
Hello, I just getting started evaluating SQL Alchemy. Not recalling the documentation very clearly I wrote the DB URL as I expected it to work: engine = create_engine('postgres://scott:[EMAIL PROTECTED]:5049/test') although I got an engine object, trying e.get_default_schema_name() gives me:

Re: [Sqlalchemy-users] Postgres URI syntax obtuse?

2006-04-16 Thread William K. Volkman
On Mon, 2006-04-17 at 01:23 -0400, Michael Bayer wrote: On Apr 17, 2006, at 12:42 AM, William K. Volkman wrote: Hello, I just getting started evaluating SQL Alchemy. Not recalling the documentation very clearly I wrote the DB URL as I expected it to work: engine = create_engine