Re: [sqlalchemy] clone Table objects

2010-01-06 Thread Michael Bayer
mg wrote: > The problem we are running up against is coming about because we are > trying to upgrade from 0.5.0 to 0.5.7. Everything has been working > fine until the upgrade. On certain tables that have sequences we are > getting, (ProgrammingError) can't adapt, on insert. can you try r6616 of ht

Re: [sqlalchemy] clone Table objects

2010-01-06 Thread Michael Bayer
mg wrote: > I have a legacy database that I am working with where there are > multiple tables that have the same structure. Because of the shear > number of tables and the fact that new tables are created daily, it's > not possible to have definitions for each table. So we came up with a > system w

[sqlalchemy] clone Table objects

2010-01-06 Thread mg
I have a legacy database that I am working with where there are multiple tables that have the same structure. Because of the shear number of tables and the fact that new tables are created daily, it's not possible to have definitions for each table. So we came up with a system where we have one par

Re: [sqlalchemy] Oracle, ownership and unrecognized type warnings

2010-01-06 Thread Michael Bayer
crary_web wrote: > For production I will need to connect as user "webserv" who has no > ownership at all only select grants, and will only have access to > views. Currently, with what I have deciphered for myself, I can't do > this. I cannot reflect a view at all, it complains about primary keys

[sqlalchemy] Oracle, ownership and unrecognized type warnings

2010-01-06 Thread crary_web
New to this group so, first, Hello to all. I have been trying to work SQLAlchemy into Grok via megrok.rdb, I was able to do it immediately for postgres without issue, and now have been at it for a bit with Oracle and I have some questions/issues. First, some background: python 2.5.4 grok 1.0 SQL

Re: [sqlalchemy] sqlalchemy 0.6 and mock strategy produces different SQL for postgres

2010-01-06 Thread Michael Bayer
Diez B. Roggisch wrote: > On Tuesday 05 January 2010 19:26:56 Michael Bayer wrote: >> On Jan 5, 2010, at 11:35 AM, Diez B. Roggisch wrote: >> > Hi, >> > >> > we have a utility-script "schemautil" that allows us to re-create our >> DB >> > based on the metadata of SA, or simply dump the generated SQ

Re: [sqlalchemy] sqlalchemy 0.6 and mock strategy produces different SQL for postgres

2010-01-06 Thread Michael Bayer
Diez B. Roggisch wrote: > On Tuesday 05 January 2010 19:26:56 Michael Bayer wrote: >> On Jan 5, 2010, at 11:35 AM, Diez B. Roggisch wrote: >> > Hi, >> > >> > we have a utility-script "schemautil" that allows us to re-create our >> DB >> > based on the metadata of SA, or simply dump the generated SQ

[sqlalchemy] Re: new sqlalchemy user having problems to insert...

2010-01-06 Thread seth
Yesterday I managed to get working all my 1 to 1 inserts. I was only missing the following properties on the child and parent classes: parent = Parent() child = Child() parent.child=child child.parent=parent -- You received this message because you are subscribed to the Google Groups "sqlalc

Re: [sqlalchemy] sqlalchemy 0.6 and mock strategy produces different SQL for postgres

2010-01-06 Thread Diez B. Roggisch
On Tuesday 05 January 2010 19:26:56 Michael Bayer wrote: > On Jan 5, 2010, at 11:35 AM, Diez B. Roggisch wrote: > > Hi, > > > > we have a utility-script "schemautil" that allows us to re-create our DB > > based on the metadata of SA, or simply dump the generated SQL for manual > > inspection - the