Create a dict of column: sql datatypes from a SQLAlchemy Model?

Question

Say I create a model using SQLAlchemy.

class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String)
    fullname = Column(String)
    password = Column(String)

How do i create a dict of column:sql datatypes?

For example:

_dict = {
    'id': Integer,
    'name': String,
    'fullname': String,
    'password': String
}

Ultimitely, I would like to pass this dict to pandas to_sql function.

Ilja Everilä · Accepted Answer · 2017-06-21 09:02:28Z

4

You could just build your dictionary from the columns of the table underlying your mapped class:

_dict = {c.name: c.type for c in User.__table__.c}

answered Jun 21, 2017 at 9:02

Ilja Everilä

53.4k9 gold badges138 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create a dict of column: sql datatypes from a SQLAlchemy Model?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related