glamod/glamod-ingest

Update marine scripts to generate SQL and load PSVs

Closed this issue · 3 comments

The old code was here:

  1. Create SQL files to load DB:

https://github.com/glamod/glamod-ingest/blob/master/src/populate/create-sqls-marine.sh

...which called...

https://github.com/glamod/glamod-ingest/blob/master/src/populate/create-sql-marine-year.sh

  1. Actually run the SQL files that were created:

https://github.com/glamod/glamod-ingest/blob/master/src/populate/load-marine-sql.sh

The new code should live in:

https://github.com/glamod/glamod-ingest/tree/master/scripts/marine

Important factors for refactoring:

I have completed the alterations in my own fork so will submit a merge request so we can discuss and review. Ag - I think you mentioned you needed to do some updates before testing the actual psql input into a db?

Fixed in Pull Request. Review before closing.

Working.