Any tips of tech theories about schemalchemy?

[wonderbeyond]

I found SchemAlchemy can help me define a single class as an interface of both Schematics and SQLAlchemy. I love its idea and style, but I am not that confident since I don't understand how it works.

Any tips? many thanks!

[lkraider]

Hi!

The main work is done by the orm.synonym machinery exposed by SQLAlchemy:
http://docs.sqlalchemy.org/en/latest/orm/mapped_attributes.html#synonyms

Most of the code deals in creating these synonyms between the Schematics accessors and the SQLAlchemy columns dynamically during class construction:

schemalchemy/schemalchemy.py

Line 74 in d67078f

field_synonym = orm.synonym(column_name, descriptor=field_descriptor)

The Model code mostly involves populating the fields during class construction, both from code and from auto-instantiation coming from SQLAlchemy when loading from DB.

Let me know if you have other questions.