~jfb-tempo-consulting/unifield-wm/sync-env-ud

« back to all changes in this revision

Viewing changes to data/generate_rate.py

  • Committer: jf
  • Date: 2019-08-02 13:25:39 UTC
  • Revision ID: jfb@tempo-consulting.fr-20190802132539-gmskn6d02lro3pek
New FX rates

Show diffs side-by-side

added added

removed removed

Lines of Context:
5
5
    date_from = DateTime.strptime('2016-01-01', '%Y-%m-%d')
6
6
    f = open('%s.txt'%base, 'w')
7
7
 
8
 
    while date_from <= date_now:
9
 
        r = requests.get('http://api.fixer.io/latest?date=%s&base=%s'%(date_from.strftime('%Y-%m-%d'), base))
 
8
    #r = requests.get('https://api.exchangeratesapi.io/history?start_at=%s&base=%s'%(date_from.strftime('%Y-%m-%d'), base.upper()))
 
9
    while date_from < date_now:
 
10
        r = requests.get('https://api.exchangeratesapi.io/%s?base=%s' % (date_from.strftime('%Y-%m-%d'), base.upper()))
10
11
        d = r.json()
11
 
        f.write("%s\n" % (date_from.strftime('%Y-%m-%d'), ))
 
12
        f.write("%s\n" % (date_from.strftime('%Y-%m-01'), ))
12
13
        for r in d['rates']:
13
 
            f.write(" %s:%s\n" % (r, d['rates'][r]))
 
14
            if r != base.upper():
 
15
                f.write(" %s:%s\n" % (r, d['rates'][r]))
14
16
        date_from += DateTime.RelativeDateTime(months=1)
15
17
    f.close()