DDS Management System

Setup Instructions

Run the following command to migrate the database schemas to postgres and set up.

make migrate

Run the following command to enter the postgres in the terminal.

psql -h localhost -p 5432 -U postgres -d postgres

Now, run the following commands to setup your database with synthetic data.

\i backend/scripts/seed_mandals.sql

\i backend/scripts/seed_villages.sql

\i backend/scripts/seed_members.sql

\i backend/scripts/seed_account_types.sql

\i backend/scripts/seed_accounts.sql

\i backend/scripts/seed_transaction_types.sql

\i backend/scripts/seed_roles.sql

\i backend/scripts/seed_endpointaccess.sql

\i backend/scripts/seed_user_roles_mapping.sql

To exit the postgres terminal, run this:

\q