867606 - Create data dictionary that maps data transforms for our crash json data

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Selena Deckelmann :selenamarie :selena]

Attachment: Data dictionary CSV

Attaching the current state of our crash json transforms. Put this into a table in Postgres.

Comment 1

[[github robot]]

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

https://github.com/mozilla/socorro/commit/e997b9c172df4afec0d9476ddd8352702c4c9cc5
bug 867606 add data dictionary

This adds a data dictionary that describes breakpad data and the transforms
applied by things like the Processor in Socorro.

Also cleaning up some stray sqlalchemy files no longer needed.

https://github.com/mozilla/socorro/commit/bc4a191e330d9bf7096ca7fde82376cf8060247a
Merge pull request #1216 from selenamarie/bug867606-data-dictionary

Bug867606 data dictionary

Comment 2

[Lonnen :lonnen]

This will go out with 45.

Comment 3

[Selena Deckelmann :selenamarie :selena]

Deployed on stage!

[[e-mail]1 application]$ PYTHONPATH=. python /usr/bin/alembic -c /data/socorro/application/config/alembic.ini upgrade head
INFO  [alembic.migration] Context impl PostgresqlImpl.
INFO  [alembic.migration] Will assume transactional DDL.
INFO  [alembic.migration] Running upgrade None -> 5e14d46c725, bug 855423 change RAISE EXCEPTION to RAISE NOTICE
INFO  [alembic.migration] Running upgrade 5e14d46c725 -> 37004fc6e41e, bug 867606 add data dictionary
[[e-mail]1 application]$