Create middleware service for data_dictionary table

RESOLVED FIXED in 50

Status

P1
normal
RESOLVED FIXED
5 years ago
2 years ago

People

(Reporter: selenamarie, Assigned: adrian)

Tracking

unspecified

Details

(Whiteboard: [qa-])

Attachments

(1 attachment)

I'd like a middleware service that provides JSON to the front end, based on the data in the table data_dictionary, whose columns are: 

* raw_field: the breakpad variable in meta_data (HBase)
* product: currently NULL, but important and interesting for differentiating between things like Fennec and B2G
* transforms: a JSON blob that has keys and sometimes values that explain how a raw_field is transformed and also where it is transformed
(Assignee)

Comment 1

5 years ago
Selena, do you want me to work on that?
OS: Linux → All
Hardware: x86_64 → All
(In reply to Adrian Gaudebert [:adrian] from comment #1)
> Selena, do you want me to work on that?

That would be awesome! :)
Assignee: nobody → adrian
(Assignee)

Updated

5 years ago
Priority: -- → P1
(Assignee)

Comment 3

5 years ago
Hey Selena, can you provide a short example of what the data looks like? Do you want the service to return exactly what the database has or should it perform some kind of transformation?
Flags: needinfo?(sdeckelmann)
Created attachment 752790 [details]
Screenshot of existing data dictionary in a spreadsheet

Here's a screenshot of the existing spreadsheet that holds this data. 

I think just passing the whole JSON to the front-end is sufficient for now. As you can see from the spreadsheet, many columns have no information in them and it isn't easy to predict which columns will or won't be populated. 

Perhaps the best thing for the middleware to do is provide only those keys which have a value specified to the requestor.
Flags: needinfo?(sdeckelmann)
Target Milestone: --- → 51
(Assignee)

Comment 5

5 years ago
Pull request: https://github.com/mozilla/socorro/pull/1284
Whiteboard: [qa-]

Comment 6

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

https://github.com/mozilla/socorro/commit/603cbbb497f26f853f70bab560cc41f8dd0f1375
Fixes bug 872223 - Added a field service to return data_dictionary information. r=peterbe

https://github.com/mozilla/socorro/commit/840dad1bb3e335e2fadc263597ee9f22f38b20a9
Merge pull request #1284 from AdrianGaudebert/872223-fields-service

Fixes bug 872223 - Added a field service to return data_dictionary infor...

Updated

5 years ago
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
(Assignee)

Updated

5 years ago
Target Milestone: 51 → 50
Product: Socorro → Socorro Graveyard
You need to log in before you can comment on or make changes to this bug.