The test project which shows how to use wsql [1] and wsql-sdk [2] to build complicated system by using mysql or mariadb with unit-tests and without any kind of ORM.
- src/schema - contains the database schema (SQL code of stored procedures and table declarations)
- bim/models - the auto generated API to work with stored procedures
- bim/tests - the unit-tests for models.
Deploy schema
wsql-trans src/scheme/bank.sql -d DEBUG:<debug> | mysql -u <username>
Generate Models
wsql-trans src/scheme/bank.sql | wsql-codegen -l python3_aio -o bim/models --sep '::'
[1] | https://github.com/websql/wsql |
[2] | https://github.com/WebSQL/sdk |