Add checklists to ETL

[vinayvenu]

The following items have not yet been moved to ETL, and should be

• checklists

Solution

Assuming there is one form associated with checklist_item_detail which is the case for now.

In ETL we need to create only two tables which covers checklist and checklist item both. The table for checklist with only have the common fields and foreign key fields, with checklist_detail.name becoming the table name. In future if we have multiple checklist support then we will have one table for each checklist detail.

One table for checklist item and observations like we have for the forms. The checklist item detail name goes as a column.

[ashusvnath]

Will pair with someone today to setup a checklist on a form and look at the data produced

[ashusvnath]

Barebones Query :

SELECT cid.id, cpt.name, completion_date, cid.organisation_id, cid.form_id, cid.dependent_on
FROM
    checklist_item ci JOIN checklist_item_detail cid on ci.checklist_item_detail_id = cid.id
                      JOIN checklist_detail cd on cd.id = cid.checklist_detail_id
                      JOIN checklist cl ON cl.id = ci.checklist_id
                      JOIN concept cpt ON cid.concept_id = cpt.id

[ashusvnath]

Expected table structure for an ETL table with observations

Table - Columns (SubjectTypeName)
-------
first_name, last_name, registratin_date, Form Element 1 - Concept Name, Form Element 2 - Concept Name,, Form Element 3 - Concept Name,, Form Element 4 - Concept Name, Form Element 5 - Concept Name

suggested by @petmongrels

[ashusvnath]

Paired with @petmongrels .
A blank table 'vaccinations_' is created on ETL run (method call is commented out)