diff options
| -rw-r--r-- | python/reto.py | 2 | ||||
| -rw-r--r-- | sql/dawn.sql | 6 |
2 files changed, 4 insertions, 4 deletions
diff --git a/python/reto.py b/python/reto.py index bb3b37df..1fe6d847 100644 --- a/python/reto.py +++ b/python/reto.py @@ -132,7 +132,7 @@ def save_jtd(conn, date, df, fund): ) conn.commit() c.executemany( - "INSERT INTO jtd_risks(date, fund, company_id, name, 1yr_spread, 3yr_spread, 5yr_spread, jtd) " + """INSERT INTO jtd_risks(date, fund, company_id, name, "1yr_spread", "3yr_spread", "5yr_spread", jtd) """ "VALUES (%s, %s, %s, %s, %s, %s, %s, %s)", [(date, fund, *t) for t in df.itertuples(index=False)], ) diff --git a/sql/dawn.sql b/sql/dawn.sql index 7b6df615..3f0f09c9 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4814,9 +4814,9 @@ CREATE TABLE jtd_risks ( company_id int4 NOT NULL, "name" text NOT NULL, jtd float8 NOT NULL, - five_year_spread float8 NOT NULL, - one_year_spread float8 NULL, - three_year_spread float8 NULL, + 5yr_spread float8 NOT NULL, + 1yr_spread float8 NULL, + 3yr_spread float8 NULL, CONSTRAINT jtd_risks_pkey PRIMARY KEY (date, fund, company_id) ); |