diff options
| -rw-r--r-- | python/parse_emails.py | 1 | ||||
| -rw-r--r-- | sql/serenitasdb.sql | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/python/parse_emails.py b/python/parse_emails.py index 9f5ec47e..c1fde68e 100644 --- a/python/parse_emails.py +++ b/python/parse_emails.py @@ -67,6 +67,7 @@ def parse_quotedate(fh, date_received): else: if quotedate.year == 1900: # p='%m/%d %H:%M:%S' quotedate = quotedate.replace(year=date_received.year) + quotedate = quotedate.tz_localize("America/New_York") break else: raise RuntimeError("can't parse date from {line}") diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 358acf85..7afa1e54 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -658,7 +658,7 @@ JOIN tranche_quotes ON tranche_id=tranche_quotes.id; CREATE TABLE tranche_risk(
id serial PRIMARY KEY,
- tranche_id integer REFERENCES tranche_quotes(id),
+ tranche_id integer UNIQUE REFERENCES tranche_quotes(id) ON DELETE CASCADE,
index_price float,
index_basis float,
index_expected_loss float,
|