[sqlalchemy] using inheritance with automap_base

[yoch . melka]

Hello,

I use reflection with automap_base to load my database schema.

# my code currently looks
Base = automap_base()
Base.prepare(engine, reflect=True)

And for now, I want to configure the Base to take in account some 
inheritance relationships.

In database, inheritance are modeled by :

-- base table
CREATE TABLE `hardware` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(8) NOT NULL,  -- indicates the type of children used
  PRIMARY KEY (`id`));


-- children tables (use same id of hardware)
CREATE TABLE `hdw_xxx` (
  `id` INT UNSIGNED NOT NULL,
  ...
  PRIMARY KEY (`id`));


CREATE TABLE `hdw_yyy` (
  `id` INT UNSIGNED NOT NULL,
  ...
  PRIMARY KEY (`id`));


There is some proper way to do this ?

Thanks you

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.