trin5tensa / moviedb

A movie lover's notebook.
GNU General Public License v3.0
1 stars 0 forks source link

Open database. #369

Closed trin5tensa closed 2 months ago

trin5tensa commented 2 months ago

Open the database from its default location or, if not present, create a new database at the default location.

Default location

A 'Movies Data' directory will located in the parent directory of the movies project which contains the source files.

Parent directory: Currently "Coding" Project directory: Currently "M2-Movies-2024"

The structure of the data directories will be:

Movies Data dir -schema_version.json -DBv0 dir --movie_database.sqlite3 -DBv1 dir --movie_database.sqlite3

The "Movies Data" directory contains a json file which records the schema version on file as a dictionary entry of

{"version": "1", "path": "/DBv1/movie_database.sqlite3"}

This will be used by a future modification to automatically update the schema.