Cdentinger has submitted this change and it was merged. 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(-) Approvals: Cdentinger: Verified; Looks good to me, approved 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: merged Gerrit-Change-Id: Iee831eaeed30e8e95da241f00abb7f961647e11e Gerrit-PatchSet: 1 Gerrit-Project: wikimedia/fundraising/tools/DjangoBannerStats Gerrit-Branch: master Gerrit-Owner: Ejegg <eeggles...@wikimedia.org> Gerrit-Reviewer: Awight <awi...@wikimedia.org> Gerrit-Reviewer: Cdentinger <cdentin...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits