[PR #20] [MERGED] Feat/restore backups #141

New issue

Closed

opened 2026-02-26 21:34:38 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 21:34:38 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/eduardolat/pgbackweb/pull/20
Author: @eduardolat
Created: 8/5/2024
Status: ✅ Merged
Merged: 8/5/2024
Merged by: @eduardolat

Base: main ← Head: feat/restore-backups

📝 Commits (10+)

6497f4f Add RestoreZip method to Client in postgres.go
8d94285 Merge branch 'main' into feat/restore-backups
3d30729 Update Dockerfile dependencies to specific versions and add unzip dependency
ba8286e Refactor RestoreZip function to support both local and remote ZIP files
065889f Add restorations table to the database migrations
03e267d Add database_pg_version to get_execution and paginate_executions SQL queries
3f27116 Update GetExecution function signature and SQL query
a4c04c6 Add backup_is_local column to GetExecution SQL query
50050cc Remove backup_is_local column from GetExecution SQL query
86a3d70 Add restorations service and related functions

📊 Changes

29 files changed (+1045 additions, -9 deletions)

View changed files

📝 docker/Dockerfile (+3 -1)
📝 docker/Dockerfile.cicd (+3 -1)
📝 docker/Dockerfile.dev (+3 -1)
➕ internal/database/migrations/20240805000451_add_restorations_table.sql (+28 -0)
📝 internal/integration/postgres/postgres.go (+64 -0)
📝 internal/service/executions/get_execution.go (+1 -1)
📝 internal/service/executions/get_execution.sql (+8 -2)
📝 internal/service/executions/paginate_executions.sql (+1 -0)
➕ internal/service/restorations/create_restoration.go (+13 -0)
➕ internal/service/restorations/create_restoration.sql (+4 -0)
➕ internal/service/restorations/get_restorations_qty.go (+7 -0)
➕ internal/service/restorations/get_restorations_qty.sql (+2 -0)
➕ internal/service/restorations/paginate_restorations.go (+54 -0)
➕ internal/service/restorations/paginate_restorations.sql (+42 -0)
➕ internal/service/restorations/restorations.go (+31 -0)
➕ internal/service/restorations/run_restoration.go (+155 -0)
➕ internal/service/restorations/update_restoration.go (+13 -0)
➕ internal/service/restorations/update_restoration.sql (+8 -0)
📝 internal/service/service.go (+6 -0)
📝 internal/view/web/dashboard/executions/list_executions.go (+1 -0)

...and 9 more files

📄 Description

Fix #8

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/eduardolat/pgbackweb/pull/20 **Author:** [@eduardolat](https://github.com/eduardolat) **Created:** 8/5/2024 **Status:** ✅ Merged **Merged:** 8/5/2024 **Merged by:** [@eduardolat](https://github.com/eduardolat) **Base:** `main` ← **Head:** `feat/restore-backups` --- ### 📝 Commits (10+) - [`6497f4f`](https://github.com/eduardolat/pgbackweb/commit/6497f4fa3e8c0c5e1da0fc879925fb540f725e41) Add RestoreZip method to Client in postgres.go - [`8d94285`](https://github.com/eduardolat/pgbackweb/commit/8d94285710e12cf27846508a4f93f009dcdb38d3) Merge branch 'main' into feat/restore-backups - [`3d30729`](https://github.com/eduardolat/pgbackweb/commit/3d30729c5c5d8f177e6ab61cf6a4d2ac30819194) Update Dockerfile dependencies to specific versions and add unzip dependency - [`ba8286e`](https://github.com/eduardolat/pgbackweb/commit/ba8286e788ad2afe0d5cae605ac637f1def48147) Refactor RestoreZip function to support both local and remote ZIP files - [`065889f`](https://github.com/eduardolat/pgbackweb/commit/065889fd566f7df6c1d6f70041f045b8bef71239) Add restorations table to the database migrations - [`03e267d`](https://github.com/eduardolat/pgbackweb/commit/03e267ddddc9f8a815d0013afac3f26447d6ba4a) Add database_pg_version to get_execution and paginate_executions SQL queries - [`3f27116`](https://github.com/eduardolat/pgbackweb/commit/3f2711685aaeea107bd4f0e037110ddb480aada9) Update GetExecution function signature and SQL query - [`a4c04c6`](https://github.com/eduardolat/pgbackweb/commit/a4c04c626329acdc3c9147ef06b6cb4b642467e1) Add backup_is_local column to GetExecution SQL query - [`50050cc`](https://github.com/eduardolat/pgbackweb/commit/50050cc895559e650e4035c5d8c1355decd70529) Remove backup_is_local column from GetExecution SQL query - [`86a3d70`](https://github.com/eduardolat/pgbackweb/commit/86a3d70455e78b3bdf9c61cfa14a441e6266b763) Add restorations service and related functions ### 📊 Changes **29 files changed** (+1045 additions, -9 deletions) <details> <summary>View changed files</summary> 📝 `docker/Dockerfile` (+3 -1) 📝 `docker/Dockerfile.cicd` (+3 -1) 📝 `docker/Dockerfile.dev` (+3 -1) ➕ `internal/database/migrations/20240805000451_add_restorations_table.sql` (+28 -0) 📝 `internal/integration/postgres/postgres.go` (+64 -0) 📝 `internal/service/executions/get_execution.go` (+1 -1) 📝 `internal/service/executions/get_execution.sql` (+8 -2) 📝 `internal/service/executions/paginate_executions.sql` (+1 -0) ➕ `internal/service/restorations/create_restoration.go` (+13 -0) ➕ `internal/service/restorations/create_restoration.sql` (+4 -0) ➕ `internal/service/restorations/get_restorations_qty.go` (+7 -0) ➕ `internal/service/restorations/get_restorations_qty.sql` (+2 -0) ➕ `internal/service/restorations/paginate_restorations.go` (+54 -0) ➕ `internal/service/restorations/paginate_restorations.sql` (+42 -0) ➕ `internal/service/restorations/restorations.go` (+31 -0) ➕ `internal/service/restorations/run_restoration.go` (+155 -0) ➕ `internal/service/restorations/update_restoration.go` (+13 -0) ➕ `internal/service/restorations/update_restoration.sql` (+8 -0) 📝 `internal/service/service.go` (+6 -0) 📝 `internal/view/web/dashboard/executions/list_executions.go` (+1 -0) _...and 9 more files_ </details> ### 📄 Description Fix #8 --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>