Closed Bug 957329 Opened 12 years ago Closed 9 years ago

[tracker] Update stored procedures to use build_type and update_channel instead of: release_channel, build_channel, old build_type or release_type

Categories

(Socorro :: Backend, task)

task
Not set
normal

Tracking

(Not tracked)

RESOLVED WONTFIX

People

(Reporter: selenamarie, Unassigned)

References

Details

Update the relevant stored procedures. May include: build_type: socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql socorro/external/postgresql/raw_sql/procs/add_new_release.sql socorro/external/postgresql/raw_sql/procs/edit_product_info.sql socorro/external/postgresql/raw_sql/procs/sunset_date.sql socorro/external/postgresql/raw_sql/procs/update_adu.sql socorro/external/postgresql/raw_sql/procs/update_build_adu.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_product_versions.sql socorro/external/postgresql/raw_sql/procs/update_signatures.sql socorro/external/postgresql/raw_sql/procs/update_tcbs.sql release_channel: socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql socorro/external/postgresql/raw_sql/procs/add_new_product.sql socorro/external/postgresql/raw_sql/procs/add_new_release.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_product_versions.sql socorro/external/postgresql/raw_sql/procs/update_tcbs.sql socorro/external/postgresql/raw_sql/procs/update_tcbs_build.sql build_channel: socorro/external/postgresql/raw_sql/procs/update_adu.sql socorro/external/postgresql/raw_sql/procs/update_build_adu.sql release_type only exists in a stored proc, rather than any tables.
Summary: Update stored procedures to use build_type and update_channel instead of: release_channel, build_channel, old build_type or release_type → [tracker] Update stored procedures to use build_type and update_channel instead of: release_channel, build_channel, old build_type or release_type
Depends on: 958558
Depends on: 958570
Depends on: 958640
Depends on: 958722
Commit pushed to master at https://github.com/mozilla/socorro https://github.com/mozilla/socorro/commit/ed3afe2d75bbb3e35c1c46688e9a5ebe5d47b941 Merge pull request #1780 from selenamarie/bug957329-proc-update-for-buildtype-updatechannel bug 958558 - add_new_releases.sql changes
Depends on: 959348
Depends on: 959354
Target Milestone: --- → 72
Target Milestone: 72 → ---
Assignee: sdeckelmann → nobody
this is close, but we are very unlikely to make further investments in reports or reports_clean, which are required for closing this out.
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.