Re: [sqlalchemy] automap_base with mapped class
Yeah I done it thank u mike -- 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 post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] automap_base with mapped class
On 03/11/2017 01:17 AM, Vijaya Sekar wrote:
from sqlalchemy.ext.automap import automap_base
from sqlalchemy import create_engine, MetaData
lists = ['employees','address']
engine = create_engine("sqlite:///chinook.db")
metadata = MetaData()
metadata.reflect(engine, only=lists)
Base = automap_base(metadata=metadata)
Base.prepare()
User = Base.classes.employees
you can say:
list(Base.classes)[0]
but this is not an ordered dictionary so you can't be assured of what
"0" is.
You have a list of names, why not use those?
User = Base.classes[lists[0]]
In the above How can i achieve mapping the classes without mention the class
explicitly.
i.e User = Base.classes.employees
How can achieve same result by using the lists[0]
--
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 post to this group, send email to sqlalchemy@googlegroups.com
.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
[sqlalchemy] automap_base with mapped class
from sqlalchemy.ext.automap import automap_base
from sqlalchemy import create_engine, MetaData
lists = ['employees','address']
engine = create_engine("sqlite:///chinook.db")
metadata = MetaData()
metadata.reflect(engine, only=lists)
Base = automap_base(metadata=metadata)
Base.prepare()
User = Base.classes.employees
In the above How can i achieve mapping the classes without mention the class
explicitly.
i.e User = Base.classes.employees
How can achieve same result by using the lists[0]
--
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
