ape icon indicating copy to clipboard operation
ape copied to clipboard

Integrate `Alembic` into `Ape` for the cache system

Open johnson2427 opened this issue 2 years ago • 0 comments

Elevator pitch:

Currently can init and purge a database, but need the ability to migrate the database when the ApeWorX team approves changes to the database structure.

Value:

Allows users to not have to purge and completely rebuild a database. They can migrate, keep all of their data, and continue to add to the sqlite database seamlessly.

Dependencies:

Alembic

Design approach:

Add alembic folder under the src folder, and set up the migration tool like we have in FastAPI applications in the past

Task list:

  • [ ] Add alembic
  • [ ] write out md file for how to use

Estimated completion date: 9/1/22

Design review:

Do not signoff unless:

    1. agreed the tasks and design approach will achieve acceptance, and
    1. the work can be completed by one person within the SLA. Design reviewers should consider simpler approaches to achieve goals.

(Please leave a comment to sign off)

johnson2427 avatar Aug 05 '22 19:08 johnson2427