Hi Friends, I am new to SQLAlchemy and trying to do with the inheriting property ( from using postgresql_inherits ). Code for creating a table and insert table is showing below,
*models.py* > Parent_Table = sqlalchemy.Table( > "Parent_Table", > metadata, > sqlalchemy.Column("Name", sqlalchemy.String), > sqlalchemy.Column("Description", sqlalchemy.String), > ) > > Child_Table = sqlalchemy.Table( > "Child_Table", > metadata, > sqlalchemy.Column("Extra_col", sqlalchemy.String), > postgresql_inherits=('Parent_Table') > ) > * views.py* > > async def createPolicy(request): > query = models.Blueprint.insert().values( > Name = "Bk", > Description = "testing SQLA", > Extra_col = "this for write something" > ) > await models.database.execute(query) > > This will show an error sqlalchemy.exc.CompileError: Unconsumed column names: Name, Description checked in many sites including SQLA documentation but didn't get a way to do this. Please help. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/bb50a5e8-0199-406d-b2e3-97f1ce2c111b%40googlegroups.com.