small tweaks

matsonj · May 21, 2024 · 18e666b · 18e666b
1 parent 50f616a
commit 18e666b
Show file tree

Hide file tree

Showing 3 changed files with 3 additions and 3 deletions.
diff --git a/Makefile b/Makefile
@@ -40,7 +40,7 @@ docker-run-evidence:
 		--env ENVIRONMENT=docker \
 		mdsbox make run serve
 
-DATES = $(shell python -c 'from datetime import datetime, timedelta; start_date = datetime(2023, 10, 24); end_date = datetime(2024, 4, 12); date_list = [start_date + timedelta(days=x) for x in range((end_date - start_date).days + 1)]; print(" ".join(date.strftime("%Y-%m-%d") for date in date_list))')
+DATES = $(shell python -c 'from datetime import datetime, timedelta; start_date = datetime(2023, 10, 24); end_date = datetime(2024, 4, 14); date_list = [start_date + timedelta(days=x) for x in range((end_date - start_date).days + 1)]; print(" ".join(date.strftime("%Y-%m-%d") for date in date_list))')
 
 dbt-run-backfill:
 	@for date in $(DATES); do \

diff --git a/docs/manifest.json b/docs/manifest.json
diff --git a/utils/load_season_summary.py b/utils/load_season_summary.py
@@ -6,6 +6,6 @@
 
 con.sql("CREATE TABLE IF NOT EXISTS nba_history_v2.main.season_summary ( elo_rating VARCHAR(15), team VARCHAR(3), conf VARCHAR(4), record VARCHAR(10), avg_wins REAL, vegas_wins REAL, elo_vs_vegas REAL, win_range VARCHAR(15), seed_range VARCHAR(15), made_postseason INT, made_play_in INT, nba_sim_start_date DATETIME, made_playoffs INT, made_conf_semis INT, made_conf_finals INT, made_finals INT, won_finals INT, PRIMARY KEY (team,nba_sim_start_date))")
 
-con.sql("INSERT INTO nba_history_v2.main.season_summary (SELECT * FROM 'data/data_catalog/season_summar*.parquet')")
+con.sql("INSERT OR IGNORE INTO nba_history_v2.main.season_summary (SELECT * FROM 'data/data_catalog/season_summar*.parquet')")
 
 print("Data Loaded to Motherduck!")