search

ZDenizYStenhaug / swe573-Project

Project repository for SWE573 - Software Development Practice
0 stars 0 forks source link

Postgres database setup #13

Closed ZDenizYStenhaug closed 2 years ago

ZDenizYStenhaug commented 2 years ago

Set up the postgres database. (a docker image can be used to run postgres, and pgadmin to manage it)

The tables specified in the database diagram should be created automatically when the database is initiated.

ZDenizYStenhaug commented 2 years ago

The postgres container is functional and accessible through pgadmin. A docker-compose file is being used.

ZDenizYStenhaug commented 2 years ago

Added an init.sql file to create the schema and the tables as the container is starting.

ZDenizYStenhaug commented 2 years ago

Since the spring backend is using JPA and hibernate to map classes aytomatically onto tables, there's no longer need for the init.sql file. the docker compose file is updated and can be found in the project's root folder on the "backend-main" branch. The container can be started using the docker-compose up -dcommand.