Details
-
Type: Task
-
Status: Closed
-
Priority: Critical
-
Resolution: Fixed
-
Affects Version/s: Fuji
-
Fix Version/s: Rushmore
-
Component/s: Database/Schema
-
Labels:None
-
Sprint:Sprint 2, Sprint 3
Description
Fuji created 2 new columns in the admaxSearchEngineAccountActualDailyBudgets table: actualSEBudget and budgetStatus. For platforms with existing entries in this table, we need to populate these columns with the proper values based on distribution and currency.
Here is a first crack at it:
--These changes need to be currency-specific too
--update `st-tracker`.admaxSearchEngineAccountActualDailyBudgets aseaadb join tsacommon.searchEngineAccounts sea on sea.ID = aseaadb.searchEngineAccountID set actualSEBudget = budget, budgetStatus = 'Active' where sea.distributionID = 3 and budget >= 0.01;
--update `st-tracker`.admaxSearchEngineAccountActualDailyBudgets aseaadb join tsacommon.searchEngineAccounts sea on sea.ID = aseaadb.searchEngineAccountID set actualSEBudget = 0.01, budgetStatus = 'Paused' where sea.distributionID = 3 and budget < 0.01;
--update `st-tracker`.admaxSearchEngineAccountActualDailyBudgets aseaadb join tsacommon.searchEngineAccounts sea on sea.ID = aseaadb.searchEngineAccountID set actualSEBudget = budget, budgetStatus = 'Active' where sea.distributionID = 178 and budget >= 100.0;
--update `st-tracker`.admaxSearchEngineAccountActualDailyBudgets aseaadb join tsacommon.searchEngineAccounts sea on sea.ID = aseaadb.searchEngineAccountID set actualSEBudget = 100.0, budgetStatus = 'Paused' where sea.distributionID = 178 and budget < 100.0;