/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 vote165 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote163 views1 answer
Create table if not exist with exceptions
SQL
8 votes171 views2 answers
Alert table name mysql
SQL
1 vote184 views3 answers
Mysql on delete set null
SQL
1 vote191 views1 answer
UseSqlServer no definition
SQL
1 vote166 views1 answer
Oracle list datafiles in tablespace
SQL
1 vote172 views4 answers
Get week day from date in sql
SQL
0 vote175 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote176 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote162 views2 answers
How to update date in oracle
SQL