Yimaru/Yimaru-BackEnd
production
9cb1c3e32b26510f58e9269d837c4f25e3250b5f
success
Saved working directory and index state On production: local changes 2026-03-04T19:59:00.635Z
HEAD is now at 0bab51a Empty commit to trigger CI/CD - 6
From https://gitea.yaltopia.com/Yimaru/Yimaru-BackEnd * branch production -> FETCH_HEAD
Already on 'production'
Updating 0bab51a..9cb1c3e Fast-forward cmd/main.go | 15 + db/data/001_initial_seed_data.sql | 67 +- db/migrations/000012_profile_completion.up.sql | 11 +- db/migrations/000018_course_intro_video.down.sql | 1 + db/migrations/000018_course_intro_video.up.sql | 1 + .../000019_sub_course_progression.down.sql | 2 + db/migrations/000019_sub_course_progression.up.sql | 41 + .../000020_scheduled_notifications.down.sql | 1 + .../000020_scheduled_notifications.up.sql | 40 + db/migrations/000021_rbac.down.sql | 3 + db/migrations/000021_rbac.up.sql | 37 + db/query/courses.sql | 9 +- db/query/notification.sql | 24 + db/query/rbac.sql | 79 ++ db/query/scheduled_notification.sql | 81 ++ db/query/sub_course_prerequisites.sql | 50 ++ db/query/user.sql | 12 + db/query/user_sub_course_progress.sql | 78 ++ gen/db/courses.sql.go | 57 +- gen/db/models.go | 76 +- gen/db/notification.sql.go | 102 +++ gen/db/rbac.sql.go | 397 ++++++++++ gen/db/scheduled_notification.sql.go | 330 ++++++++ gen/db/sub_course_prerequisites.sql.go | 187 +++++ gen/db/user.sql.go | 35 +- gen/db/user_sub_course_progress.sql.go | 279 +++++++ internal/config/config.go | 10 +- internal/domain/course_management.go | 13 +- internal/domain/notification.go | 12 + internal/domain/progression.go | 84 ++ internal/domain/rbac.go | 63 ++ internal/domain/scheduled_notification.go | 56 ++ internal/domain/team.go | 16 +- internal/domain/user.go | 3 +- internal/ports/course_management.go | 20 + internal/ports/notification.go | 10 + internal/ports/rbac.go | 25 + internal/ports/user.go | 1 + internal/repository/courses.go | 91 ++- internal/repository/notification.go | 55 ++ internal/repository/progression.go | 226 ++++++ internal/repository/rbac.go | 203 +++++ internal/repository/scheduled_notification.go | 202 +++++ internal/repository/user.go | 70 +- internal/services/course_management/courses.go | 6 +- internal/services/course_management/progression.go | 69 ++ internal/services/course_management/service.go | 7 +- internal/services/messenger/email.go | 15 +- internal/services/messenger/sms.go | 2 +- internal/services/notification/service.go | 431 ++++++++++- internal/services/rbac/seeds.go | 439 +++++++++++ internal/services/rbac/service.go | 165 ++++ internal/services/user/direct.go | 10 + internal/services/user/interface.go | 1 + internal/web_server/app.go | 4 + internal/web_server/handlers/course_management.go | 126 ++- internal/web_server/handlers/handlers.go | 4 + .../web_server/handlers/notification_handler.go | 841 ++++++++++++++++++++- .../web_server/handlers/progression_handler.go | 404 ++++++++++ internal/web_server/handlers/rbac_handler.go | 565 ++++++++++++++ internal/web_server/handlers/user.go | 60 ++ internal/web_server/middleware.go | 23 + internal/web_server/routes.go | 372 ++++----- 63 files changed, 6222 insertions(+), 497 deletions(-) create mode 100644 db/migrations/000018_course_intro_video.down.sql create mode 100644 db/migrations/000018_course_intro_video.up.sql create mode 100644 db/migrations/000019_sub_course_progression.down.sql create mode 100644 db/migrations/000019_sub_course_progression.up.sql create mode 100644 db/migrations/000020_scheduled_notifications.down.sql create mode 100644 db/migrations/000020_scheduled_notifications.up.sql create mode 100644 db/migrations/000021_rbac.down.sql create mode 100644 db/migrations/000021_rbac.up.sql create mode 100644 db/query/rbac.sql create mode 100644 db/query/scheduled_notification.sql create mode 100644 db/query/sub_course_prerequisites.sql create mode 100644 db/query/user_sub_course_progress.sql create mode 100644 gen/db/rbac.sql.go create mode 100644 gen/db/scheduled_notification.sql.go create mode 100644 gen/db/sub_course_prerequisites.sql.go create mode 100644 gen/db/user_sub_course_progress.sql.go create mode 100644 internal/domain/progression.go create mode 100644 internal/domain/rbac.go create mode 100644 internal/domain/scheduled_notification.go create mode 100644 internal/ports/rbac.go create mode 100644 internal/repository/progression.go create mode 100644 internal/repository/rbac.go create mode 100644 internal/repository/scheduled_notification.go create mode 100644 internal/services/course_management/progression.go create mode 100644 internal/services/rbac/seeds.go create mode 100644 internal/services/rbac/service.go create mode 100644 internal/web_server/handlers/progression_handler.go create mode 100644 internal/web_server/handlers/rbac_handler.go
From https://gitea.yaltopia.com/Yimaru/Yimaru-BackEnd * branch production -> FETCH_HEAD
time="2026-03-04T19:59:02Z" level=warning msg="/home/yimaru/Yimaru-BackEnd/docker-compose.yml: the attribute `version` is obsolete, it will be ignored, please remove it to avoid potential confusion" Container yimaru-backend-app-1 Stopping Container yimaru-backend-test-1 Stopping Container yimaru-pgadmin Stopping Container yimaru-mongo Stopping Container yimaru-backend-app-1 Stopped Container yimaru-backend-app-1 Removing Container yimaru-backend-app-1 Removed Container yimaru-backend-migrate-1 Stopping Container yimaru-backend-migrate-1 Stopped Container yimaru-backend-migrate-1 Removing Container yimaru-mongo Stopped Container yimaru-mongo Removing Container yimaru-backend-migrate-1 Removed Container yimaru-mongo Removed Container yimaru-pgadmin Stopped Container yimaru-pgadmin Removing Container yimaru-pgadmin Removed Container yimaru-backend-postgres-1 Stopping Container yimaru-backend-postgres-1 Stopped Container yimaru-backend-postgres-1 Removing Container yimaru-backend-postgres-1 Removed Container yimaru-backend-test-1 Stopped Container yimaru-backend-test-1 Removing Container yimaru-backend-test-1 Removed Volume yimaru-backend_mongo_data Removing Network yimaru-backend_app Removing Volume yimaru-backend_postgres_data Removing Volume yimaru-backend_mongo_data Removed Volume yimaru-backend_pgadmin_data Removing Volume yimaru-backend_postgres_data Removed Volume yimaru-backend_pgadmin_data Removed Network yimaru-backend_app Removed
time="2026-03-04T19:59:13Z" level=warning msg="/home/yimaru/Yimaru-BackEnd/docker-compose.yml: the attribute `version` is obsolete, it will be ignored, please remove it to avoid potential confusion" time="2026-03-04T19:59:13Z" level=warning msg="No services to build" Network yimaru-backend_app Creating Network yimaru-backend_app Created Volume yimaru-backend_mongo_data Creating Volume yimaru-backend_mongo_data Created Volume yimaru-backend_postgres_data Creating Volume yimaru-backend_postgres_data Created Container yimaru-mongo Creating Container yimaru-backend-postgres-1 Creating Container yimaru-mongo Created Container yimaru-backend-postgres-1 Created Container yimaru-backend-migrate-1 Creating Container yimaru-backend-migrate-1 Created Container yimaru-mongo Starting Container yimaru-backend-postgres-1 Starting Container yimaru-mongo Started Container yimaru-backend-postgres-1 Started Container yimaru-backend-postgres-1 Waiting Container yimaru-backend-postgres-1 Healthy Container yimaru-backend-migrate-1 Starting Container yimaru-backend-migrate-1 Started
Restoring latest backup...
Restoring from backup/dump_2026-03-04_19_59_02.sql.gz
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
COPY 32
COPY 3
COPY 7
COPY 5
COPY 0
COPY 28
COPY 21
COPY 0
COPY 0
COPY 0
COPY 0
COPY 155
COPY 20
COPY 64
COPY 17
COPY 5
COPY 0
COPY 0
COPY 5
COPY 12
COPY 347
COPY 0
COPY 0
COPY 7
COPY 0
setval
--------
32
(1 row)
setval
--------
3
(1 row)
setval
--------
7
(1 row)
setval
--------
1
(1 row)
setval
--------
22
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
155
(1 row)
setval
--------
65
(1 row)
setval
--------
21
(1 row)
setval
--------
5
(1 row)
setval
--------
4
(1 row)
setval
--------
1
(1 row)
setval
--------
20
(1 row)
setval
--------
1
(1 row)
setval
--------
6
(1 row)
setval
--------
13
(1 row)
setval
--------
5
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
5
(1 row)
setval
--------
17
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
14
(1 row)
ERROR: syntax error at or near "pg_dump"
LINE 1: pg_dump: warning: there are circular foreign-key constraints...
^
ERROR: duplicate key value violates unique constraint "question_sets_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY question_sets, line 1
ERROR: insert or update on table "question_set_items" violates foreign key constraint "question_set_items_set_id_fkey"
DETAIL: Key (set_id)=(2) is not present in table "question_sets".
ERROR: insert or update on table "question_set_personas" violates foreign key constraint "question_set_personas_question_set_id_fkey"
DETAIL: Key (question_set_id)=(2) is not present in table "question_sets".
ERROR: duplicate key value violates unique constraint "roles_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY roles, line 1
Waiting for PostgreSQL to be ready...
/var/run/postgresql:5432 - accepting connections
Seeding db/data/001_initial_seed_data.sql...
CREATE EXTENSION
INSERT 0 0
INSERT 0 0
INSERT 0 0
INSERT 0 20
INSERT 0 0
INSERT 0 20
INSERT 0 0
INSERT 0 24
INSERT 0 0
INSERT 0 16
INSERT 0 3
INSERT 0 7
INSERT 0 17
INSERT 0 5
INSERT 0 3
INSERT 0 0
INSERT 0 4
INSERT 0 5
INSERT 0 0
Seeding db/data/003_fix_autoincrement_desync.sql...
setval
--------
14
(1 row)
setval
--------
20
(1 row)
setval
--------
129
(1 row)
setval
--------
1
(1 row)
setval
--------
4
(1 row)
setval
--------
41
(1 row)
setval
--------
6
(1 row)
setval
--------
1
(1 row)
setval
--------
22
(1 row)
setval
--------
13
(1 row)
setval
--------
6
(1 row)
setval
--------
14
(1 row)
setval
--------
34
(1 row)
setval
--------
10
(1 row)
setval
--------
10
(1 row)
Seeding db/data/004_activity_logs_seed.sql...
INSERT 0 30
Seeding db/data/005_issue_reporting_seed.sql...
INSERT 0 12
Seeding db/data/006_notifications_seed.sql...
INSERT 0 21