How to get column types of an existing, named table from SQLAlchemy

Question

How can I represent this query in SQLAlchemy?

SELECT COLUMN_NAME, DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'foo'

Why you need that with SQLAlchemy ? Did you lost the model ? — polku
– polku, Commented Jul 25, 2016 at 13:24
I want to be able to read the datatypes for columns in a table foo. — Dr. John A Zoidberg
– Dr. John A Zoidberg, Commented Jul 25, 2016 at 13:25

polku · Accepted Answer · 2016-07-25 14:15:02Z

4

Mb, I didn't understood you meant the database types. If it's a mapped table you can iterate columns like this:

for c in foo.__table__.columns:
    print(c.type)

answered Jul 25, 2016 at 14:15

polku

1,6002 gold badges15 silver badges15 bronze badges

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

2 Comments

Dr. John A Zoidberg Over a year ago

Just a table on sql server 2008. I just want a function that returns the column names and types.

polku Over a year ago

Then I go back to my first question, you don't really need SQLAlchemy, just open a connection and execute your query (3 lines in Python). You can use SQLA automap, but that's really seems overkill.

Blue Moon · Accepted Answer · 2019-07-15 14:38:00Z

0

def get_data_types(model):
'''return dictionary with column name as key and data type as value'''
    d = {}
    for c in model.__table__.columns:
        d[str(c.name)] = str(c.type)

    return d

where model is the sqlalchemy orm table.

answered Jul 15, 2019 at 14:38

Blue Moon

4,79121 gold badges60 silver badges97 bronze badges

Collectives™ on Stack Overflow

How to get column types of an existing, named table from SQLAlchemy

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related