Familiarize with SQLAlchemy

dieterich-lab / scimodom

GNU Affero General Public License v3.0

0 stars 0 forks source link

Familiarize with SQLAlchemy #27

Closed eboileau closed 10 months ago

eboileau commented 1 year ago

Aims/objectives.

If this works, then we can start re-writing the server code.

A clear and concise description of todo items.

[x] Go through important parts of SQLAlchemy Unified Tutorial
[x] Create a test environment, create a small DB according to #21, perform selected queries and "validate" the data model
[x] Check how to integrate Alembic

eboileau commented 1 year ago

Using SQLAlchemy is feasible, I started experimenting with the ORM (with an in-memory SQLite DB and a model based on #21). I can construct some simple and more complex queries, based on standard SQL queries, but the problem is still related to #20, see also #13.

So I think the next step is to set-up a toy app following the same model, with a MySQL DB, API, and one single View, starting with a simple component (e.g. Dropdown), and expriment with the data communication/wrangling.