Implement Integration of Flask Application with HarvestDB Update Feature

[Jin-Sun-tts]

User Story

integrate the Flask application with HarvestDB's update functionality so that database changes can be easily managed and applied within the Flask environment.

Links:

• Related work done on Flask / DB integration: Create Harvest DB and Table Structure #4612 (comment)
• Deprecated repo : Datagov Harvest Orchestrator repo: https://github.com/GSA/datagov-harvest-orchestrator
• Planning documentation:
  https://docs.google.com/document/d/1XzfTrPxu-asJ_55GoeZ2UOJsie9CuCegStS28BAL_40/

Acceptance Criteria

[ACs should be clearly demoable/verifiable whenever possible. Try specifying them using BDD.]

• GIVEN the code resides in the orchestrator repository
  AND the objective is to consolidate it into the harvesting-logic repository
  THEN deploy and test the app on cloud.gov and

• GIVEN the team has settled on the Table structure
  AND it has been defined in an SQLAlchemy file
  THEN it should be able to be created programmatically in a Docker container by running a DB initialization script.

• GIVEN that the DB has been initialized
  WHEN alterations are made to database tables,
  THEN execute the database update function to apply updates.

Background

Continuing the work in #4612, implement database table structure update functions within the application logic.

Sketch

• research and test Flask-SQLAlchemy versus SQLAlchemy
• test database table changes with flask commands

[Jin-Sun-tts]

Changed to Flask-Alchemy and organized the app directory to accommodate Flask-related files.
Also configured Flask-Migrate for handling database upgrades

[rshewitt]

quick article on some things to consider when indexing. this was more for my curiosity but liked how concise it was so i'm sharing.