[sqlalchemy] Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread jdu
Hi all, Since 0.3.9, i have this error: ArgumentError: Error determining primary and/or secondary join for relationship 'Referer.subject (Subject)'. If the underlying error cannot be corrected, you should specify the 'primaryjoin' (and 'secondaryjoin', if there is an association table present)

[sqlalchemy] Re: Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread Michael Bayer
try specifying your foreign key as ForeignKey(jdu.subject.id) as a workaround for now. On Jul 18, 2007, at 3:14 AM, jdu wrote: Hi all, Since 0.3.9, i have this error: ArgumentError: Error determining primary and/or secondary join for relationship 'Referer.subject (Subject)'. If the

[sqlalchemy] Re: Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread Michael Bayer
err, also, I cant reproduce your issue - using an alternate schema on this end, your program completes fine and its able to reflect the foreign keys correctly. Run your failing test case using echo='debug' and send the full output over. On Jul 18, 2007, at 3:14 AM, jdu wrote: Hi all,

[sqlalchemy] Updating mappers after append_column

2007-07-18 Thread Bertrand Croq
Hi, Is it possible to reinitialize some mappers once a column has been added to a mapped table using the_table.append_column() ? Thanks. -- Bertrand Croq, Ingénieur Développement ___ Net-ng Tel : +33

[sqlalchemy] SAContext 0.3.2 and future plans

2007-07-18 Thread Mike Orr
SAContext 0.3.2 has been released. http://sluggo.scrapping.cc/python/sacontext/ Changes: * .add_engine and .add_engine_from_config now return the (engine, metadata) pair created, in addition to registering them internally. Requested by Andrey Petrov. * New strategy ExilirStrategy contribued

[sqlalchemy] Re: looking to make

2007-07-18 Thread Michael Bayer
i dont know whats up with google groups today, i replied to this earlier...these changes are fine with me. On Jul 18, 12:57 am, Mike Bernson [EMAIL PROTECTED] wrote: I started looking to what is happen to get table information from mysql. I found that the following is issued for every table

[sqlalchemy] Re: looking to make

2007-07-18 Thread Michael Bayer
these optimizations are all fine with me, Jason Kirtland has been handling the overhaul of MySQL reflection so maybe stop by on IRC to compare notes. On Jul 18, 12:57 am, Mike Bernson [EMAIL PROTECTED] wrote: I started looking to what is happen to get table information from mysql. I found

[sqlalchemy] dbcook 0.1

2007-07-18 Thread sdobrev
g'day. This is dbcook, a framework to cook databases from recipes, written as python declarations. Eventually the result may be edible (;-) (previous pre-names: sawrap, o2rm... it's about 10 months old now) If u're interested, have a look, dbcook/usage/example1.py might be a start. The

[sqlalchemy] Re: Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread jdu
I have the same error with your hint ForeignKey(jdu.subject.id). Here' the logs: 2007-07-18 20:18:42,466 INFO sqlalchemy.engine.base.Engine.0x..ec select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=%(schema)s and lower(relname)=% (name)s 2007-07-18

[sqlalchemy] Re: looking to make

2007-07-18 Thread jason kirtland
Mike wrote: I started looking to what is happen to get table information from mysql. I found that the following is issued for every table that is reflected: 2007-07-18 00:29:08,158 INFO sqlalchemy.engine.base.Engine.0x..cc show variables like 'character_set%%' 2007-07-18 00:29:08,158

[sqlalchemy] ATTN: Google Groups Screwing Up Today

2007-07-18 Thread Michael Bayer
Google is apparently not delivering or displaying messages consistently today. If your post isnt coming through, try using trac tickets for issues right now: http://www.sqlalchemy.org/trac/ --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: TEST POST

2007-07-18 Thread Mike Orr
On 7/18/07, Michael Bayer [EMAIL PROTECTED] wrote: this is a test. Success. -- Mike Orr [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: looking to make

2007-07-18 Thread jason kirtland
[this one seems to have been lost in googlegroups too, resending...] Mike wrote: I started looking to what is happen to get table information from mysql. I found that the following is issued for every table that is reflected: 2007-07-18 00:29:08,158 INFO

[sqlalchemy] Re: looking to make

2007-07-18 Thread Mike Bernson
can it also be added to 3.9 ? jason kirtland wrote: [this one seems to have been lost in googlegroups too, resending...] Mike wrote: I started looking to what is happen to get table information from mysql. I found that the following is issued for every table that is reflected:

[sqlalchemy] dbcook 0.1

2007-07-18 Thread sdobrev
g'day. This is dbcook, a framework to cook databases from recipes, written as python declarations. Eventually the result may be edible (;-) (previous pre-names: sawrap, o2rm... it's about 10 months old now) If u're interested, have a look, dbcook/usage/example1.py might be a start. The

[sqlalchemy] Re: looking to make

2007-07-18 Thread jason kirtland
Mike wrote: can it also be added to 3.9 ? Sure, if there's another release in the 0.3 line the case-check cache can go in. But the only use SHOW CREATE change will be likely be a 0.4-only thing. -j --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread jdu
After changing something, it's working for me too now. The request used for postgresql autoload is: SELECT conname, pg_catalog.pg_get_constraintdef(oid, true) as condef FROM pg_catalog.pg_constraint r WHERE r.conrelid = 30554 AND r.contype = 'f' ORDER BY 1 ... and the result depends on the

[sqlalchemy] Re: looking to make

2007-07-18 Thread Mike Bernson
sounds good. Looking forward to see it in 3.10dev jason kirtland wrote: Mike wrote: can it also be added to 3.9 ? Sure, if there's another release in the 0.3 line the case-check cache can go in. But the only use SHOW CREATE change will be likely be a 0.4-only thing. -j

[sqlalchemy] Re: Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread jdu
I have the same error with your advice (ForeignKey(jdu.subject.id)). The output has been uploaded as the file log.txt (copy/paste seems not working). Hope it helps you. jp --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: Error with autoload=True and ForeignKey for postgresql

2007-07-18 Thread Michael Bayer
On Jul 18, 2007, at 5:58 PM, jdu wrote: After changing something, it's working for me too now. The request used for postgresql autoload is: SELECT conname, pg_catalog.pg_get_constraintdef(oid, true) as condef FROM pg_catalog.pg_constraint r WHERE r.conrelid = 30554 AND r.contype = 'f'

[sqlalchemy] Re: dbcook 0.1

2007-07-18 Thread Michael Bayer
congrats on getting this released ! --~--~-~--~~~---~--~~ 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 unsubscribe from this group, send email to