/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

5 votes95 views1 answer
Sql select ciunt
SQL
-1 vote107 views2 answers
Mysql get day of week
SQL
0 vote97 views3 answers
Average salary in sql
SQL
-1 vote58 views2 answers
Sql query examples
SQL
1 vote101 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote95 views1 answer
Sql common columns
SQL
0 vote121 views1 answer
How to retrive the today date sql
SQL
2 votes118 views1 answer
Capitalize 1st letter in sql server
SQL
3 votes112 views2 answers
Postgres alter table owner
SQL
0 vote112 views1 answer
Shell script to log mysql cpu usage
SQL