1 files changed, 0 insertions, 15 deletions
diff --git a/python/Dawn/utils.py b/python/Dawn/utils.py
index 37350949..99451080 100644
--- a/python/Dawn/utils.py
+++ b/python/Dawn/utils.py
@@ -1,5 +1,4 @@
 import pandas as pd
-from sqlalchemy.sql import text
 import os
 import re
 from pickle import dumps
@@ -54,20 +53,6 @@ def load_trades(engine):
     blotter.to_sql('bonds', engine, if_exists='append', index=False)
     return blotter
 
-def add_triggers(engine):
-    engine.execute(text("""
-    CREATE OR REPLACE FUNCTION mydealid()
-    RETURNS TRIGGER AS $$
-    BEGIN
-       UPDATE bonds SET dealid = 'SC_' ||upper(left(asset_class::text,3))||id,
-    identifier = COALESCE(identifier, cusip, isin) WHERE bonds.id = NEW.id;
-       RETURN NEW;
-    END;
-    $$ language plpgsql"""))
-    engine.execute(text("""CREATE TRIGGER dealid
-       AFTER INSERT ON bonds
-       FOR EACH ROW
-       EXECUTE PROCEDURE mydealid()"""))
 
 def bump_rev(filename):
     pattern = "([^r]*)(\srev(\d)|).pdf"