Setup Test Fixtures

Faculty Pool File

Luke modifying the program to read the file provided by OVPAE

Exclusions File

OVPAE provided us the 2022 exclusions from https://manoa.hawaii.edu/ovpae/tprc/index.php

Lookup info to generate sql statements for APPLICATION_ROLE (id, app_id, person_id, role_id)

• lookup the app ID

  • select app.id, p.id, p.name, p.uhuuid, p.username from application app, application_role ar, person p where year=2022 and ar.person_id=p.id and app.id=ar.application_id and ar.role_id=1 and ar.person_id in (select id from person where uhuuid in (16265999, 21844268, 16347071, 10204287, 15949017, 22868453, 19510181, 10913233, 18038316, 24756754, 26780418, 22966944, 10102983, 26045017, 25914385, 11203953, 10959749, 19610273, 10220346, 26068538, 11192244, 19923440, 15961923, 14805015, 19348088, 25902519, 17292797, 26050939, 22944977, 26044740, 25120870, 17754387, 21713069, 26075449, 16350044, 17584347, 25993640, 10316460, 26528307, 25546027, 24967474, 10685192, 16278281, 25967430, 16900929, 10950033, 25436046, 25505735, 10134813, 16301005, 10216391, 10742145, 16796277, 18094711, 10789903, 17813859, 21303971, 10294907, 25041247, 21490988, 24317983, 19846876, 20998940, 22592863, 22297294, 16413135, 23637250, 22084055, 23824873, 22450815, 26084543, 14781047, 10694430, 19976198, 14586357, 24720147, 10813164, 25390249, 25996271, 13738635, 16927070, 15493244, 25395689, 15390900, 22686966, 15983066, 13630004, 20404886, 25594302, 11381436, 14566768, 13608826, 26413649, 23567560, 11166985, 19921369, 25276080));

• lookup the person ID of the excluded faculty

  • select * from person where uhuuid in (10280383, 10309773, 10921638, 11672286, 13606810, 15157575, 16826216, 19981644, 10276192, 10312350, 13634449, 18118245, 10123815, 10276571, 10283401, 10287818, 10991776, 11632973, 13674088, 16552820, 22568913, 11551654, 10232220, 10274939, 10315443, 10369120, 11705548, 11726295, 13606738, 13760735, 18160371, 11608974, 10118808, 10312605, 10317821, 11207690, 13674869, 16120255, 10154129, 10204287, 10204790, 10251223, 10282637, 11513336, 14959930, 16306161, 17727887, 10273696, 10293440, 11595947, 11674428, 13682069, 16309998, 17754677, 22399988, 24718831, 10315791, 10368190, 10961597, 22868453, 22226377, 17217235, 10722220, 11481416, 13771199, 17777514, 21717328, 10186112, 10239601, 10284004, 10694883, 10724348, 10976955, 11369961, 16818582, 23637250, 10134641, 10303992, 10724992, 10935482, 11729862, 10313065, 10927235, 11729827, 13640273, 13674786, 10182344, 10323945, 14787222, 16787835, 15961923, 16508574, 23803782, 21033334, 21571913, 10283683, 10303865, 10927169, 10983759, 19921369, 20682444, 22448250, 22866378, 23688298, 10281431, 10289390, 10344812, 10999499, 13886844, 14586357, 23146249, 10137119, 10179626, 10286440, 10354236, 21712012, 24860026, 11296570, 10922309, 10275330, 10333257, 10725508, 22944977, 10287623, 20527318, 10118851, 10190591, 13733218, 16005850, 16413135, 17899524, 25129893, 25486819, 11563574, 22245506, 17205930, 24873891);

• lookup the role for excluded faculty (role id=12)

  • select * from role where role='EXCLUDED';

Plan

• refresh dev database with prod data (done)

• load exclusions into the dev database

• application changes in a branch

  • create batch job to run the load

• run code locally from Luke’s machine

  • execute the job

  • run a report of the assignments