Closed Bug 959354 Opened 10 years ago Closed 10 years ago

Update remaining build_type and release_channel references in stored procs

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

References

Details

(Whiteboard: [DB Changes][qa-]) 

Likely affects: 

socorro/external/postgresql/raw_sql/procs/edit_product_info.sql
socorro/external/postgresql/raw_sql/procs/update_crash_adu_by_build_signature.sql
socorro/external/postgresql/raw_sql/procs/update_home_page_graph.sql
socorro/external/postgresql/raw_sql/procs/update_home_page_graph_build.sql
socorro/external/postgresql/raw_sql/procs/update_signatures.sql
socorro/external/postgresql/raw_sql/procs/update_tcbs.sql
socorro/external/postgresql/raw_sql/procs/add_new_product.sql
socorro/external/postgresql/raw_sql/procs/backfill_one_day.sql
socorro/external/postgresql/raw_sql/procs/edit_product_info.sql
socorro/external/postgresql/raw_sql/procs/reports_clean_weekly_partition.sql
socorro/external/postgresql/raw_sql/procs/update_crashes_by_user_build.sql
socorro/external/postgresql/raw_sql/procs/update_home_page_graph.sql
socorro/external/postgresql/raw_sql/procs/update_home_page_graph_build.sql
socorro/external/postgresql/raw_sql/procs/update_nightly_builds.sql
socorro/external/postgresql/raw_sql/procs/update_tcbs.sql
socorro/external/postgresql/raw_sql/procs/update_tcbs_build.sql
Need to populate ProductBuildType in this commit.
also need to backfill the last 24 hrs of reports_clean
Assignee: nobody → sdeckelmann
Target Milestone: --- → 72
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/6d95dab22cd8eeab129d0fcb83cb3947254f254b
Fixes bug 959354 - updates remaining stored procs for build_type/update_channel

https://github.com/mozilla/socorro/commit/a3b4a190d2acd9fb236ab87ef502637ceeb23e25
Migration for bug 959354

https://github.com/mozilla/socorro/commit/5ae82b63ccd8218addf58efb5486d36473e669e6
Merge pull request #1789 from selenamarie/bug959354-remaining-matview-build_type-and-release_channel-fixes

Bug959354 remaining matview build type and release channel fixes
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.