abnDK / personal-budget-2

For completing personal budget 2 project in Codecademy back engineer career path
0 stars 0 forks source link

make reset db (for test) helper #12

Closed abnDK closed 1 year ago

abnDK commented 1 year ago

As a tester, i want to reset the database -II- i would like to specify wether or not to populate with testdata -II- i would like to specify which version to migrate the db to (latest version as default)

3 (creating/dropping tables) has to be done first.

Function will make us of "insert_test_data.sh", that runs after tables has been created. The function will look for current_version, and only insert test data for this version

examples:

reset db tables and migrate to newest version ./reset_database.sh

reset db tables, migrate to newest version and insert test data according to newest version ./reset_database.sh data

reset db tables, migrate to version 1-2 and insert test data according to version 1-2 ./reset_database.sh 1-2 data

abnDK commented 1 year ago

check hvis $1 = "data", så køres ./up til newest version, og data insertes. check hvis $1 kan splittes med '-' og være 2 tal. Upmigrate til versionen. -- hvis $2 = 'data', kør insert data.

abnDK commented 1 year ago

For at kunne specificere hvilken version, der upmigrates til skal up.sh (og down.sh) omskrives til at stoppe ved et bestemt versionsnummer. Dette skubbes til evt. fremtidig udvikling.

abnDK commented 1 year ago

"./reset_tables.sh data" will now reset tables, migrate to newest version and insert test data according to version number. (if no "test_data_x-x.sql" file exist with x-x equal to , no data will be written)