We add two new optional kwargs to the generic interface:
join_type: The type of join to use for joining the model to pardat (e.g. inner or left, defaults to left).
additional_pardat_filter: A SQL string representing additional conditions to use when selecting records from pardat to join to the model (e.g. class != 'EX' and class != 'RR'). cur = 'Y' and deactivat IS NULL are already set, hence "additional" pardat filter.
The combination of these two new kwargs will allow us to filter a test for only those rows whose corresponding pardat class is "EX". This is demonstrated in a dweldat test that can be generalized to addn, asmt_all, oby, and land in order to complete https://github.com/ccao-data/data-architecture/issues/328.
This PR makes a small modification to the
res_class_matches_pardatgeneric test in order to support the test spec in https://github.com/ccao-data/data-architecture/issues/328.We add two new optional kwargs to the generic interface:
join_type: The type of join to use for joining the model to pardat (e.g.innerorleft, defaults toleft).additional_pardat_filter: A SQL string representing additional conditions to use when selecting records from pardat to join to the model (e.g.class != 'EX' and class != 'RR').cur = 'Y'anddeactivat IS NULLare already set, hence "additional" pardat filter.The combination of these two new kwargs will allow us to filter a test for only those rows whose corresponding pardat class is
"EX". This is demonstrated in a dweldat test that can be generalized toaddn,asmt_all,oby, andlandin order to complete https://github.com/ccao-data/data-architecture/issues/328.