generate sql seeder

psql -U username -d databse_name -f .\Wg-backend-api\Migrationswg-init-db-seeder.sql

Example:

psql -U postgres -d wg -f .\Wg-backend-api\Migrations\wg-init-db-seeder.sql

game-schema-init.sql file, is for creating the schema of game_1, without global schema, or any data.

Reseting db with .bat file

./reset-db.bat

before push changes

Format main project

./format.bat

Create sql backup

Seeder

& 'C:\Program Files\PostgreSQL\17\bin\pg_dump.exe' --no-comments --no-owner --no-privileges -U postgres -d wg -f '.\Wg-backend-api\Migrations\wg-init-db-seeder.sql'

Game schema

& 'C:\Program Files\PostgreSQL\17\bin\pg_dump.exe' --no-comments --no-owner --no-privileges --schema=game_1 --schema-only -U postgres -d wg -f '.\Wg-backend-api\Migrations\game-schema-init.sql'