search

stats4sd / aec_portfolio

A proof of concept for the AEC Consortium Project Management / Assessment System
GNU General Public License v3.0
0 stars 0 forks source link

Add Historic Exchange Rate Data #264

Closed dan-tang-ssd closed 7 months ago

dan-tang-ssd commented 7 months ago

This PR is submitted to add historic exchange rate data.

Staging env deployment and live env deployment are done in a manual way.

Therefore, it is not necessary to merge this PR for deployment. (Except that we should add a migration file to add a composite index for base_currency_id, target_currency_id, date in exchage_rates table)

This PR contains below changes:

  1. Add Google Finance csv files
  2. Add a composite index for base_currency_id, target_currency_id, date in exchage_rates table
  3. Add one time command program to import csv files
  4. Add one time command program to generate exchange rates record with same base currency and target currency
dan-tang-ssd commented 7 months ago

Perhaps we keep it unmerged, as you suggest, and close it. But we keep it here for reference - I'm sure having access to all these exchange rate data in a Laravel package will come in useful again! (It'd be nice to extract this and make it a resource for others too at some point).

Yes, I agree. I will close this PR now.