1498441 - move "os_names" table to Django

Status: RESOLVED FIXED

(Socorro :: Database, task, P2)

Description

[Will Kahn-Greene [:willkg] ET needinfo? me]

There's an OsName model with a os_names table defined in the sqlalchemy models. This holds platform information that's predominantly static.

This bug covers moving that table over to Django.

Comment 1

[Will Kahn-Greene [:willkg] ET needinfo? me]

Step 1:

1. Create Django model, migration, and Django admin view
2. Create a data migration script to copy data from old table to new table

Step 2:

1. Rewrite /api/Platforms/ to use new table
2. Rewrite all the views that use that

Step 3:

1. Delete old table


One thing is that we add items to this table in socorro/external/postgresql/staticdata.py as part of bootstrapping the local dev environment. We're going to want to set up something similar for Django-managed data. Probably a fixture.

Comment 2

[Will Kahn-Greene [:willkg] ET needinfo? me]

Attachment: pr 4646: bug 1498441: create Platform Django model and migration script

Comment 3

[[github robot]]

Commits pushed to master at https://github.com/mozilla-services/socorro

https://github.com/mozilla-services/socorro/commit/6bc50c7c660ee0a8b0bad2340c2b5673c551f879
bug 1498441: create Platform Django model and migration script

https://github.com/mozilla-services/socorro/commit/ef3fdfcfe003c027ab5516c2dfc09e3eb854a572
Merge pull request #4646 from willkg/1498441-os-names

bug 1498441: create Platform Django model and migration script

Comment 4

[Will Kahn-Greene [:willkg] ET needinfo? me]

Attachment: pr 4647: bug 1498441: rewrite everything to use new Platform model

Comment 5

[[github robot]]

Commits pushed to master at https://github.com/mozilla-services/socorro

https://github.com/mozilla-services/socorro/commit/f47d25d8445727fa6a63c85b22ff2e1dfe299496
bug 1498441: rewrite everything to use new Platform model

This rewrites everything to use the new Platform Django model.

This also removes the /api/Platforms/ endpoint. I checked the dashboards
and it's not being used. It returned a static result, so anyone can just
hardcode that.

This removes the staticdata for the OsName model. In its place, it adds
a Django fixture and adds a line to the setup script to load that.

This also adds a schema migration to fix the crashstats_platform table
so that "name" is unique.

https://github.com/mozilla-services/socorro/commit/eb491e6f187ddc58f0c145254fc2de0edd6f2213
Merge pull request #4647 from willkg/1498441-platform-step-2

bug 1498441: rewrite everything to use new Platform model

Comment 6

[Will Kahn-Greene [:willkg] ET needinfo? me]

Last thing to do here is delete the "os_names" and "os_name_matche" tables.

Comment 7

[Will Kahn-Greene [:willkg] ET needinfo? me]

I created a new bug to delete tables. Marking this one as FIXED.