load CSV data via COPY command

[talerngpong]

Purposed changes:

• use init.sql script during spinning container up via docker compose up -d
• use copy SQL command to load CSV data to declared table. This will serve a use case of Import CSV data with a single command

[talerngpong]

For AMOUNT field, I think we should remove improve it (in upstream CSV) by removing middle commas in order to make it complaint with numeric type.

current: "21,905,000"
complaint version: "21905000"

[vtno]

@talerngpong Thank you for your contribution! This does the same thing as my PR here #19 and it also handled:

For AMOUNT field, I think we should remove improve it (in upstream CSV) by removing middle commas in order to make it complaint with numeric type.

It might be good if you can have a look at that PR and help review it. 😃

[vtno]

I think this solution is cleaner than my script that manually drop existing and create a new DB. It might be good if you can rebase on top of my latest changes and apply this change to it.

[talerngpong]

Rebased.

I am not sure which change I need to apply. Then I comes with questions.

1. From my guess, does it mean that I need to remove your previous solution (like import_data and run_sql shell scripts)?
2. This PR aims improvement of how we insert data to Postgres (by using COPY command). Would it be good whether other thing else could be fulfilled in your PR instead? (by lemme review your PR) :)

[vtno]

I was thinking of just:

Suggested change

	- ./init.sql:/docker-entrypoint-initdb.d/init.sql
	- ./create_report_table.sql:/docker-entrypoint-initdb.d/init.sql

Does this make sense?

[vtno]

I don't think we need this as the thing we import is from here.

[vtno]

@talerngpong Merged! Thanks again for your contribution.

[talerngpong]

@vtno Thank you as well. Other changes you interest depend on your branch csv-to-db after this :).

[vtno]

@talerngpong Feel free to open another PR to master to add new features. 🙏