Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-3205

Update db script to populate actualSEBudget and budgetStatus columns for all distributions

    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;

        Attachments

          Activity

            People

            • Assignee:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
              Reporter:
              rgardner Ross Gardner
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: