diff options
Diffstat (limited to 'python/mark_backtest_backfill.py')
| -rw-r--r-- | python/mark_backtest_backfill.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/mark_backtest_backfill.py b/python/mark_backtest_backfill.py index 95b7fb9c..fb0394a8 100644 --- a/python/mark_backtest_backfill.py +++ b/python/mark_backtest_backfill.py @@ -37,7 +37,7 @@ def runSingleFill(f): df['source'] = df['source'].str.upper() conn = dbconn('dawndb') - sql_str = "INSERT INTO external_marks VALUES(%(identifier)s, %(date)s, %(mark)s, %(source)s)" + sql_str = "INSERT INTO external_marks VALUES(%(identifier)s, %(date)s, %(mark)s, %(source)s) ON CONFLICT DO NOTHING" with conn.cursor() as c: for r in df.to_dict(orient='record'): try: @@ -73,7 +73,7 @@ def get_BVAL(): def pop_BVAL_to_database(df): conn = dbconn('dawndb') - sql_str = "INSERT INTO external_marks VALUES(%(identifier)s, %(date)s, %(mark)s, %(source)s)" + sql_str = "INSERT INTO external_marks VALUES(%(identifier)s, %(date)s, %(mark)s, %(source)s) ON CONFLICT DO NOTHING" with conn.cursor() as c: for r in df.to_dict(orient='record'): try: |