Commit Graph

16 Commits (main)

Author SHA1 Message Date
Will King 1782372a45 Fixed the restore script.
Got it runnign currently
1 year ago
Will King fc478517ac Backing up current dataset 1 year ago
Will King eca4795d2f Began redoing lost formularies work
I lost some work on USP formularies and those are crucial for my analysis.
So, I began reworking them. In the process, I:

- Created a new formularies schema and added a table and some views
  - new file:   Scripts/ConfiguringFormularies.sql
- exported the schema
  - new file:   Scripts/export_tables.sh
  - new file:   export/export_data_postgres_materialized_views.sql
  - new file:   export/export_data_postgres_tables.sql
  - new file:   export/export_data_postgres_views.sql
  - new file:   export/output_2025-01-06_export_data_postgres_materialized_views.sql
  - new file:   export/output_2025-01-06_export_data_postgres_tables.sql
  - new file:   export/output_2025-01-06_export_data_postgres_views.sql
  - new file:   Scripts/Extracting Tables Views and MatViews.sql
- created a new checkpoint/backup of my work
  - modified:   .gitattributes
  - new file:   containers/AACT_Reloader/backup/aact_db_backup_20250106_184236.sql.gz
  - new file:   Scripts/Backup_AACT_work.sh
1 year ago
Will King 87074aa42b Worked on error preventing restore
Turns out that the code for checking if the database was up was wrong. I think I fixed it but am not sure.
1 year ago
Will King d90539a679 updated data-restoration script. Currently working 2 years ago
Will King 142670d08a added some data that had been left untracked 2 years ago
will king 256177e569 Updated to what I am using so far 3 years ago
will king c5f3bfcdec Merging work from other computer into home.
Merge branch 'main' of ssh://gitea.kgjk.icu:3022/Research/ClinicalTrialsDataProcessing
3 years ago
will king 12c3c69304 added Glbal burden fo disease data 3 years ago
youainti 123fe3b5e4 Merge completed: Merged working versions from home and office PCs 3 years ago
youainti bbdd7552a8 adding various changed for which I don't remember the details. I'm adding it to avoid loosing it. 3 years ago
will king ef7ed7001b added info for setting up the db from DrugCentral.org 3 years ago
youainti 39397cc224 reorganized python scripts into package, added requisit sql, and added shell scripts to notify me when the systems are up again. 3 years ago
youainti 804a90c247 lots of updates while integrating rxnav and aact into one dockerfile 3 years ago
youainti 8dbf4e8c2e removed unused files, began adjusting docker-composes so that they will work together. 3 years ago
youainti 1a106a553e moved containers to single location, ignored raw data 3 years ago