859431 - Problem with job that updates personas -> AMO

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Maintenance Scripts, defect, P1)

Description

[Ricardo Fradinho [:rfradinho]]

Attachment: SQL query

Hello,
There is an ETL process that updates addons_mozilla_org.personas.
This was done as part of Bug 555233 and Bug 602034.
Currently the process is broken because the table column licence_id was renamed to licence.
I need a confirmation that that is the only required change on the update process.
I've attached the SQL query used to do the select on Personas DB.

Comment 1

[Christopher Van Wiemeersch [:cvan]]

Took a look, and this should work:

--- before.diff	2013-04-08 12:46:18.000000000 -0700
+++ after.diff	2013-04-08 12:46:24.000000000 -0700
@@ -2,7 +2,7 @@
     id as persona_id,
     movers,
     IF(popularity is null, 0, popularity) as popularity,
-    IF(license='cc', 1035, 1034) AS license_id
+    IF(license='cc', 8, 7) AS license
 FROM personas.personas
 where status = 1
 and name is not null

Comment 2

[Ricardo Fradinho [:rfradinho]]

Closing BUG:
SQL was updated on 2013-04-08 according to the proposed change.