Ejegg has uploaded a new change for review.
https://gerrit.wikimedia.org/r/289262
Change subject: INSERT IGNORE into donatewiki_unique
......................................................................
INSERT IGNORE into donatewiki_unique
Dang, have we been rolling back and retrying one by one every time
a donor clicks on an email for the second time?
Change-Id: Iee831eaeed30e8e95da241f00abb7f961647e11e
---
M fundraiser/analytics/management/commands/LoadLPImpressions.py
1 file changed, 1 insertion(+), 1 deletion(-)
git pull
ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools/DjangoBannerStats
refs/changes/62/289262/1
diff --git a/fundraiser/analytics/management/commands/LoadLPImpressions.py
b/fundraiser/analytics/management/commands/LoadLPImpressions.py
index 4b4ef11..15f22c0 100644
--- a/fundraiser/analytics/management/commands/LoadLPImpressions.py
+++ b/fundraiser/analytics/management/commands/LoadLPImpressions.py
@@ -54,7 +54,7 @@
help = 'Parses the specified squid log file and stores the impression in
the database.'
impression_sql = "INSERT INTO `landingpageimpression_raw%s` (timestamp,
squid_id, squid_sequence, utm_source, utm_campaign, utm_key, utm_medium,
landingpage, project_id, language_id, country_id) VALUES %s"
- unique_sql = "INSERT INTO `donatewiki_unique` (timestamp, utm_source,
utm_campaign, contact_id, link_id) VALUES %s"
+ unique_sql = "INSERT IGNORE INTO `donatewiki_unique` (timestamp,
utm_source, utm_campaign, contact_id, link_id) VALUES %s"
pending_impressions = []
pending_uniques = []
--
To view, visit https://gerrit.wikimedia.org/r/289262
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iee831eaeed30e8e95da241f00abb7f961647e11e
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools/DjangoBannerStats
Gerrit-Branch: master
Gerrit-Owner: Ejegg <eeggles...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
