Skip to content

Latest commit

 

History

History
38 lines (31 loc) · 1.67 KB

README.md

File metadata and controls

38 lines (31 loc) · 1.67 KB

Creating and filling a Postgres DB with Docker Compose

This project create tables and fill the tables in a Postgres data base. The tables and data that create are in sql/ folder

Read the explanation here Creating and filling a Postgres DB with Docker compose

ER Diagram

The ER Diagram of DB is this:

ER_Diagram

DB Variables

Set the variables in sql/fill_tables.sql

Parameter Description
number_of_sales Number of rows to create in the table sale
number_of_users Number of rows to create in the table users
number_of_products Number of rows to create in the table product
number_of_stores Number of rows to create in the table store
number_of_coutries Number of rows to create in the table country
number_of_cities Number of rows to create in the table city
number_of_status_names Number of rows to create in the table status_name
start_date Date of the first sale
end_date Date of the last sale

Params

If want change this params in docker-compose.yaml

Parameter Description
POSTGRES_USER The Postgres user to connect postgres
POSTGRES_PASSWORD The Postgres password to connect postgres
POSTGRES_DB The Postgres database name to connect postgres
port The port mapped by Postgres is 5432 in your container. In this example, use the port 5438 on the host machine

Run

$ docker-compose up