/SQL/How to get column name in db from an sqlalchemy attribute model

How to get column name in db from an sqlalchemy attribute model

class User(Base):
    __tablename__ = 'user'
    id = Column('id', String(40), primary_key=True)
    email = Column('email', String(50))
    firstName = Column('first_name', String(25))
    lastName = Column('last_name', String(25))
    addressOne = Column('address_one', String(255))


from sqlalchemy.inspection import inspect
# columns = [column.name for column in inspect(model).c]

# Also if we want to know that User.firstName is first_name then:
columnNameInDb = inspect(User).c.firstName.name
# The following will print: first_name
print(columnNameInDb)

Source: stackoverflow.com

Similar codes

0 vote96 views1 answer
Copy data from one postgres container to another
SQL
14 votes111 views4 answers
Online sql compiler
SQL
12 votes105 views4 answers
How to check mysql version ubuntu
SQL
0 vote49 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote103 views1 answer
Oracle synonym procedure dblink
SQL
24 votes90 views5 answers
Sql reset auto increment
SQL
1 vote94 views3 answers
Rename table snowflake
SQL
0 vote102 views1 answer
Java check if something is in mysql table
SQL
0 vote91 views1 answer
How to check which sp is running in sql server
SQL
1 vote89 views2 answers
Postgresql list columns
SQL