[sqlalchemy] Saving all transactions against a database (logging queries?)

2007-01-04 Thread Brian Jarrett
Hello all, I've been using SA to convert data from a csv or another database into a new database (either empty or already being used). I do all my work on copies of the original data and then when I've confirmed that data is being moved accurately, I have to come up with a way to get the data i

[sqlalchemy] Re: Foreign key not updated

2007-01-04 Thread Michael Bayer
Arnar Birgisson wrote: Now, what I really wanted to do is to write a method on my class that takes care of changing it's primary key (or part of it, at least) and cascade the change down to the children of that entity. Would that be possible while keeping the process transparent to the caller,

[sqlalchemy] Re: Foreign key not updated

2007-01-04 Thread Arnar Birgisson
On 1/4/07, Michael Bayer <[EMAIL PROTECTED]> wrote: Arnar Birgisson wrote: > On 1/3/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > yeah that would be why. SA's ORM has no ability to update primary key > > columns from their original valueyoull have to update it yourself, > > or copy the

[sqlalchemy] Re: Foreign key not updated

2007-01-04 Thread Michael Bayer
Arnar Birgisson wrote: On 1/3/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > yeah that would be why. SA's ORM has no ability to update primary key > columns from their original valueyoull have to update it yourself, > or copy the object instance to a new one, etc. (or not make that col a

[sqlalchemy] Re: Postgresql arrays

2007-01-04 Thread Michael Bayer
its not, unless someone wants to implement a PGArrayType for this purpose. --~--~-~--~~~---~--~~ 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 uns

[sqlalchemy] Re: Foreign key not updated

2007-01-04 Thread Arnar Birgisson
On 1/3/07, Michael Bayer <[EMAIL PROTECTED]> wrote: yeah that would be why. SA's ORM has no ability to update primary key columns from their original valueyoull have to update it yourself, or copy the object instance to a new one, etc. (or not make that col a primary key) Ok thanks. Is

[sqlalchemy] Re: left join help

2007-01-04 Thread Jose Soares
Hello Michael, the query is perfect, with every JOIN and LEFT JOIN, thank you very much. jo Michael Bayer ha scritto: hey jose - was waiting to see if anyone jumped on this for you. alas, no responses. making some assumptions about your Table objects, your query above would look something l

[sqlalchemy] Postgresql arrays

2007-01-04 Thread Enrico Morelli
Dear all, sqlalchemy is able to manage the postgres arrays? I have a table name tarray like: refcode char(5) wokdays int[] When I try to use it from SA I have the following error: tarray=Table('tarray', metadata, autoload=True) KeyError: 'integer[]' -- -