基于 OAuth 2.0 对于多网站用户账户统合功能，以及跨端服务集群的分析和研究

cd apps/api && go run check-dup-email

go run migrate

cd apps/api && go run migrate

go run ./cmd/migrate-users \
--kungal-dsn="host=127.0.0.1 port=5432 user=postgres password=kunloveren dbname=kungalgame" \
--moyu-dsn="host=127.0.0.1 port=5432 user=postgres password=renlovekun dbname=kungalgame_patch"

psql -h localhost -U postgres -d kungalgame_patch -f prisma/migrations/20260409_oauth_integration/migration.sql

pnpm prisma:push

⚠️  There might be data loss when applying the changes:

  • The `alias` column on the `galgame_engine` table would be dropped and recreated. This will lead to data loss.

  • The `galgame_type` column on the `galgame_rating` table would be dropped and recreated. This will lead to data loss.

  • The `homepage` column on the `galgame_toolset` table would be dropped and recreated. This will lead to data loss.

  • The `domain` column on the `galgame_website` table would be dropped and recreated. This will lead to data loss.

cd apps/api && go run migrate

cd kun-oauth-admin
go run ./cmd/migrate-galgame
go run ./cmd/migrate-galgame-data --kungal-dsn="host=localhost port=5432 user=postgres password=kunloveren dbname=kungalgame"

# drop or recreate dbs
cd kun-oauth-admin
./scripts/reset_all.sh
# clear redis kv
redis-cli FLUSHALL

cd kun-galgame-nuxt4
cd apps/api && go run ./cmd/check-dup-email/main.go
# run 001-004 + 008-009 (008 is kungal-local, no deps)
go run ./cmd/migrate/main.go


cd kun-galgame-patch-next
# if db version mismatch, firstly replace it
psql -U postgres
\c kungalgame_patch;
REINDEX DATABASE kungalgame_patch;
ALTER DATABASE kungalgame_patch REFRESH COLLATION VERSION;
\q
# OAuth Integration + Schema Alignment
cd apps/api
go run ./cmd/migrate-oauth-prep -yes


cd kun-oauth-admin
cd apps/api && go run ./cmd/migrate/main.go
go run ./cmd/migrate-users --kungal-dsn="host=127.0.0.1 port=5432 user=postgres password=kunloveren dbname=kungalgame" --moyu-dsn="host=127.0.0.1 port=5432 user=postgres password=renlovekun dbname=kungalgame_patch"
go run ./cmd/migrate-galgame
go run ./cmd/migrate-galgame-data --kungal-dsn="host=localhost port=5432 user=postgres password=kunloveren dbname=kungalgame"
go run ./cmd/migrate-moyu-galgame --moyu-dsn="host=localhost port=5432 user=postgres password=renlovekun dbname=kungalgame_patch"
go run ./cmd/dedup-galgame-alias/


# drop kungalgame redundancy tables and fields
cd kun-galgame-nuxt4
cd apps/api
go run cmd/migrate/main.go --only=005
# apply new galgame resource provider scan mechanisms
go run ./cmd/migrate --only=006
# migeate provider histories
go run ./cmd/backfill-provider-names
go run ./cmd/migrate --only=007

# drop kungalgame_patch redundancy tables and fields
cd kun-galgame-patch-next
cd apps/api
go run ./cmd/migrate -dir=up -only=001
go run ./cmd/migrate -dir=up
# remap patch id to galgame id
# get orphan patches: go run ./cmd/remap-patch-ids -dry-run -orphans-out=orphans.txt
go run ./cmd/remap-patch-ids


# optional sync vndb data
cd kun-oauth-admin
cd apps/api
# firstly sync full vndb data
go run ./cmd/sync-vndb/ --full
# delete invalid vndb id
go run ./cmd/cleanup-bogus-vndb-id
go run ./cmd/cleanup-bogus-vndb-id --delete
# sync tags, officials, etc.
go run ./cmd/sync-vndb-relations
# daliy cron job, incremental reincarnation
go run ./cmd/sync-vndb/


# image service
cd kun-oauth-admin
cd apps/api
# setup image service
go run ./cmd/image-setup --seed-test-client
# start image service
go run ./cmd/image
# galgame banner migrations
go run ./cmd/migrate-galgame-banners-to-image-service --client-id=kungal-test --client-secret=test-secret-dev --batch=100 --rps=20 

❯ psql -U postgres
psql (18.3)
Type "help" for help.
postgres=# \c kungalgame_patch;
WARNING:  database "kungalgame_patch" has a collation version mismatch
DETAIL:  The database was created using collation version 2.42, but the operating system provides version 2.43.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE kungalgame_patch REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
You are now connected to database "kungalgame_patch" as user "postgres".

postgres=# \c kungalgame_patch;
WARNING:  database "kungalgame_patch" has a collation version mismatch
DETAIL:  The database was created using collation version 2.42, but the operating system provides version 2.43.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE kungalgame_patch REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
You are now connected to database "kungalgame_patch" as user "postgres".
kungalgame_patch=# REINDEX DATABASE kungalgame_patch;
WARNING:  database "kungalgame_patch" has a collation version mismatch
DETAIL:  The database was created using collation version 2.42, but the operating system provides version 2.43.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE kungalgame_patch REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
REINDEX
kungalgame_patch=# ALTER DATABASE kungalgame_patch REFRESH COLLATION VERSION;
NOTICE:  changing version from 2.42 to 2.43
ALTER DATABASE

sudo systemctl stop meilisearch

sudo rm -rf /var/lib/meilisearch/data.ms

sudo systemctl start meilisearch
sudo systemctl status meilisearch

cd kun-oauth-admin
cd apps/api
go run ./cmd/reindex-search

pnpm add -wD vue-tsc eslint-plugin-vuejs-accessibility