jack-zheng
5/14/2018 - 4:29 PM

python, sqlalchemy

python, sqlalchemy

Conversion

Using row.__table__columns

In [28]: cs = obj.__table__.columns

In [29]: for column in cs:
    ...:     print(column.name)
    ...:     
id
file_name
author
create_date
last_update_by
last_update_time
file_path

Using obj.dict

In [30]: obj.__dict__
Out[30]: 
{'_sa_instance_state': <sqlalchemy.orm.state.InstanceState at 0x7f63ed87eeb8>,
 'author': 'I077806',
 'create_date': datetime.datetime(2017, 11, 24, 17, 7, 17),
 'file_name': 'PLT123472379BlukImportUserCustomerfieldTableLastModifyDateShouldBeUpdate.java',
 'file_path': 'PLT-User/src/com/successfactors/test/qray/cases/plt/usermanagement/bulkimport/PLT123472379BlukImportUserCustomerfieldTableLastModifyDateShouldBeUpdate.java',
 'id': 1,
 'last_update_by': 'I331048',
 'last_update_time': datetime.datetime(2018, 2, 22, 14, 34, 7)}