[sqlalchemy] Re: Firebird - column types

2007-10-12 Thread Roger Demetrescu
Werner, On 10/4/07, Werner F. Bruhin [EMAIL PROTECTED] wrote: Scanning firebird.py I noticed that: FBText returns BLOB SUB_TYPE 2 Shouldn't that be BLOB SUB_TYPE 1 or BLOB SUB_TYPE TEXT and FBBinary returns BLOB SUB_TYPE 1 Shouldn't that be BLOB SUB_TYPE 0 See Helen's FB Book on

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Christophe de VIENNE
2007/10/12, John M Camara [EMAIL PROTECTED]: I performed a release under LGPL. Hope that this is ok and fits into the sqlalchemy environment. Why not just release it under MIT like SQLAlchemy? The project will likely receive wider use under MIT rather than LGPL. +1 on the MIT licence

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Gaetan de Menten
I couldn't agree more. I mean: shouldn't the autoload part be integrated into SQLAlchemy reflection capability if it can do more than SQLAlchemy 0.4 currently support (or simply removed if it doesn't do more)? And I fact, I think the formatting part could also be integrated into SQLALchemy

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Paul Johnston
Hi, I don't say that everything should be integrated, just the reflection part (if at all useful in SA0.4) and the repr methods of the corresponding objects (*_repr in formatter.py) which should IMHO replace the current repr methods. That sounds good. One consideration is that autocode repr

[sqlalchemy] Many-to-many back to single table

2007-10-12 Thread Sean Davis
I have two tables: create table a ( id serial primary key, name varchar(255) unique ); create table b ( id serial primary key, subject int references a(id), object int references b(id), otherinfo varchar(255) ); I have been trying to pull ideas together from the self-referential portion of the

[sqlalchemy] Re: Many-to-many back to single table

2007-10-12 Thread Michael Bayer
On Oct 12, 2007, at 2:21 PM, Sean Davis wrote: I have two tables: create table a ( id serial primary key, name varchar(255) unique ); create table b ( id serial primary key, subject int references a(id), object int references b(id), otherinfo varchar(255) ); I have been trying to

[sqlalchemy] Re: Basic Level 1 sqlalchemist

2007-10-12 Thread Michael Bayer
you might want to look into Elixir since its the current version of ActiveMapper, and is much better documented. http://elixir.ematia.de/ trac/wiki On Oct 10, 2007, at 2:24 PM, Wes Duff wrote: Hello gentelmen and ladies, I am very new to sqlalchemy and put in a position where I had to

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Simon Pamies
On Oct 11, 11:10 am, Werner F. Bruhin [EMAIL PROTECTED] wrote: I had changed one of the other versions to handle Firebird and got it to work for my purposes, but did some hacks which were not for public consumption. If you or someone else can help me working the hacks out then maybe

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Simon Pamies
On Oct 12, 10:09 am, Gaetan de Menten [EMAIL PROTECTED] wrote: I couldn't agree more. I mean: shouldn't the autoload part be integrated into SQLAlchemy reflection capability if it can do more than SQLAlchemy 0.4 currently support (or simply removed if it doesn't do more)? As i mentioned in

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Christophe de VIENNE
2007/10/12, Simon Pamies [EMAIL PROTECTED]: On Oct 12, 2:48 am, John M Camara [EMAIL PROTECTED] wrote: I performed a release under LGPL. Hope that this is ok and fits into the sqlalchemy environment. Why not just release it under MIT like SQLAlchemy? The project will likely receive

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Simon Pamies
On Oct 11, 2:21 pm, Paul Johnston [EMAIL PROTECTED] wrote: BTW, with SA 0.4, this script should be able to work with no database-specific hacks at all. If you're interesting in implementing this, I can explain more. Would be nice to hear more details about this. Currently I'm stuck to

[sqlalchemy] bad query generated

2007-10-12 Thread Julien
Hello, I have a problem with one of my queries and SQLAlchemy 0.3.10. I try to translate http://rafb.net/p/hJik4V26.html in SQLAlchemy. The result is http://rafb.net/p/IieKUW41.html which is almost OK, except that the final FROM clauses isn't at the good place, SQLAlchemy outputs this :

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Paul Johnston
Hi, BTW, with SA 0.4, this script should be able to work with no database-specific hacks at all. If you're interesting in implementing this, I can explain more. Would be nice to hear more details about this. With 0.4, dialects have a table_names() method that will do the job of

[sqlalchemy] Re: one-to-one/many-to-one

2007-10-12 Thread Michael Bayer
On Oct 12, 2007, at 2:46 PM, jon wrote: Hi, I have the following set up in a Pylons application: project_table = Table(PROJECT, metadata, autoload=True, autoload_with=config['pylons.g'].sa_engine) studio_table = Table(STUDIO, metadata, autoload=True,

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-12 Thread Simon Pamies
On Oct 12, 2:48 am, John M Camara [EMAIL PROTECTED] wrote: I performed a release under LGPL. Hope that this is ok and fits into the sqlalchemy environment. Why not just release it under MIT like SQLAlchemy? The project will likely receive wider use under MIT rather than LGPL. Can you

[sqlalchemy] Profiling code to understand memory utilisation

2007-10-12 Thread Arun Kumar PG
I want profile my code to understand the amount of memory SA ORM uses during a handling a request. Does SA exposes some logging mechanism which can dump the usage like echo on engine ? -- Cheers, - A --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Re: one-to-one/many-to-one

2007-10-12 Thread jon
Changing the Relation declaration to 'project_studio' fixed this. Thanks for the advice. On Oct 12, 11:58 am, Michael Bayer [EMAIL PROTECTED] wrote: On Oct 12, 2007, at 2:46 PM, jon wrote: Hi, I have the following set up in a Pylons application: project_table = Table(PROJECT,

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-12 Thread Paul Johnston
Hi, I am very sorry for asking this question, but I was wondering if anyone could give me a short step by step process as to how to access a Microsoft Access Database using SQLAlchemy. Access support is experimental. Use the lastest 0.4 trunk, as I've committed a few fixes just now.

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-12 Thread Eddie
Just giving a little more information on what I can't figure out... All I'd like to know is the few lines of code to open and connect to an existing .mdb file. So far, I have registered the mdb file as a DNS and named it VCPDB. Three lines of my code look like: metadata = MetaData() engine =