kobotoolbox / kpi / 23002712955

82%

master: 76%

Build Type

push

github

Committed by web-flow

Commit Message

feat(qual): add verification and source to data views (#6800)

### 📣 Summary
Add 'verification' and 'source' columns for QA questions in data views.


### 📖 Description
For every QA question, add columns indicating whether the response (if
present) is verified or not and whether it was generated manually or
automatically. These columns will appear in exports but not the table
view.


### 💭 Notes
Having the columns show up in exports but not the table is not ideal
behavior, but this way frontend can work off main and we don't have to
combine the frontend and backend changes into one branch or add extra
complexity to gate the feature on the backend, which we don't generally
do. This has been approved by product.


### 👀 Preview steps


1. ℹ️ have an account and a project with an audio question and at least
one submission
2. Add a transcript
3. Add a QA question
4. Add a response (manual) to the question
5. Export data
6. 🟢 [on PR] The export should contain 2 columns after the QA question
column, `<survey_question> - <qa question> - source` and
`<survey_question> - <qa question> - source`. `verified` should be
`False`, `source` should be `manual` for the edited submission.
7. Use AI to generate a new response to the question (you will need to
add `?ff_autoQAEnabled=true` to the url)
8. Export data
9. The `source` column for the edited submission should now say
`generated with AI`. `verified` should still be `False`.
10. Verify the data by PATCHing the `/supplement` endpoint with 
```
{
  "_version": "20250820",
  "{question_xpath}": {
    "automatic_bedrock_qual": {
       "uuid": "{qa question uuid}",
       "verified": true
     }
  }
}
```
11. Export the data
12. 🟢 `verified` should now be True

Run Details

7536 of 11643 branches covered (64.73%)

12 of 18 new or added lines in 4 files covered. (66.67%)

1 existing line in 1 file now uncovered.

28963 of 35306 relevant lines covered (82.03%)

5.81 hits per line