Add Languages and school classes lookups

Brian Lewis reporter

This is controlled in Pineapples.Data, DSLookups

DSLookups maintains a dictionary of lookup names and the SQL Statements that retrieve them. These SQL statements are designed to return the lookup code as C, the lookup description ( or name) as N.

Add two new entries to this array, called languages and schoolClasses

Construct the sql for each to read from the views TRLanguage and TRSchoolClass (The data is in the tables lkpLanguage and lkpSchoolClass, the corresponding TRx views just choose the description from up to 3 languages - codeDescription codeDescriptionL1 codeDescriptionL2 - on the table. )

Add the new entries 'languages' and 'schoolClasses' to the array in the method core(). This defines all the lookup tables fetched on application startup.

Build the project, and the Pineapples project!

To test if it has worked, you can use fiddler composer to GET api/lookups/collection/core:

2016-05-17T21:23:01+00:00

Brian Lewis reporter

I think this can go into issue83 branch with the final tidy-ups of school editing.

2016-05-17T21:23:53+00:00

Brian Lewis reporter

Note on the screen image above: the lookups method do not require authorization (they care called before signin) so you don't need a bearer Token authorization header to test this call.