Set up Dockerfile to create PostgreSQL database and table

[ChrisRichardMiles]

Description: As part of the backend setup for our General Ledger system, we need to configure our Dockerfile to include a PostgreSQL database and initialize it with a table that matches the schema required for our ledger entries. Additionally, we want to prepopulate the table with three initial entries to facilitate testing and development.

To do:

• [x] Create a script or SQL file to initialize the database with the necessary schema, table structure, and prepopulated entries.
• [x] Test the Dockerfile to ensure that PostgreSQL is installed, the database is initialized correctly, and the prepopulated entries are present.
• [x] Running bash run.sh creates two containers, with one running the frontend app and the other running the postgresql database.

Acceptance criteria:

• [x] The table should have fields for ID, Date, Account Name, Debit, Credit, Entry Type, Amount, and Description, with the correct data types and constraints.
• [x] The prepopulated entries should include three sample ledger entries explicitly listed in the issue description.

Prepopulated entries:

1. Entry ID: 1, Date: 2024-05-10, Account Name: Sales, Entry Type: Debit, Amount: 5000.00 USD, Description: Sale of product A
2. Entry ID: 2, Date: 2024-05-12, Account Name: Expenses, Entry Type: Credit, Amount: 1500.00 USD, Description: Office supplies purchase
3. Entry ID: 3, Date: 2024-05-15, Account Name: Accounts Receivable, Entry Type: Debit, Amount: 3000.00 USD, Description: Invoice payment received

[ChrisRichardMiles]

I couldn't do it with a dockerfile, but i solved it with a run.sh file in the database directory. Running bash run.sh from the root will now create 2 containers, one running the frontend app and one running the database. It will also print and show that the database was created.

[ChrisRichardMiles]

close