Re: [sqlalchemy] Concrete table inheritance without a master table

2010-04-16 Thread WDyk
Here's the issue, boiled down to one file. On import, the last statement fails, mapping the Connections object. I just need to map two relations on an association object (Connections) to a polymorphic union (NetworkNode). Is there a way to do this? sqlalchemy.exc.ArgumentError: Column

Re: [sqlalchemy] Concrete table inheritance without a master table

2010-04-16 Thread WDyk
-sqlalch...@googlegroups.com wrote: - To: sqlalchemy@googlegroups.com From: Michael Bayer mike...@zzzcomputing.com Sent by: sqlalchemy@googlegroups.com Date: 04/16/2010 02:57PM Subject: Re: [sqlalchemy] Concrete table inheritance without a master table w...@nobleenergyinc.com wrote:

Re: [sqlalchemy] Concrete table inheritance without a master table

2010-04-15 Thread WDyk
Each of the four tables for the networknode subclasses have hundreds of columns, but each has an mid column and a typename column. Here's the definition of connecttb, thanks to sqlautocode: connecttb = Table('connecttb', metadata, Column(u'deleteflag', Numeric(precision=10, scale=2,

[sqlalchemy] Concrete table inheritance without a master table

2010-04-14 Thread WDyk
I've got a legacy database that I need to work through the following scenario with. There are four types of objects, completions, meters, tanks and equipment. Each has its own table. There is no master table representing all the entities. There is a connection table that describes the