originalutkin / sql_generator Goto Github PK

Result models should be tested. This goal could be achieved by creation integration test that will get file with raw sql commands as input and provide SQLAlchemy models that will be stored in db. Acceptance criteria:

• Result schema should be created in the database and no errors will appear during schema initialisation.

• it's possible to insert some data to created tables based on data models and get it from there.

Current template contains pinned imports.
Instead of this, only required packages/classes/dependencies should be imported and all those imports could be done automatically depends on what is required for models

Currently, we're not able to identify type of attribute which is marked as FK. In order to fix it, #17 was opened. However idea with using context doesn't look readable , so it should be adjusted in other way. Now all FK are generated with no data type and result model couldn't be used

Current behaviour is that both things (enums and models) are created in single template. This could be adjusted and enumerations will be created in separate file and be imported during creating models

After models (with all required dependencies) are generated, models for testing could be generated as well.
For the beginning, testing models could be generated based on factory boy framework