Data Settings: How does csweb handle modified cases on relational SQL table?
Posted: November 4th, 2023, 9:33 am
Using CSWeb's Data Settings, we can configure dictionaries to break out questionnaire data into relational tables. I have a question:
1. I send an entry to my csweb server (using PUT method),
2. then I break out all cases data currently on the server (php bin/console csweb:process-cases),
3. then I modify or delete that previous entry (no. 1) on my laptop, and re-send that entry to my server
4. I repeat step 2
Will there be two same cases (one is the original, the other one is the deleted/modified case), or just one case (a.k.a one table record) on my MySQL relational table? Thanks in advance.
1. I send an entry to my csweb server (using PUT method),
2. then I break out all cases data currently on the server (php bin/console csweb:process-cases),
3. then I modify or delete that previous entry (no. 1) on my laptop, and re-send that entry to my server
4. I repeat step 2
Will there be two same cases (one is the original, the other one is the deleted/modified case), or just one case (a.k.a one table record) on my MySQL relational table? Thanks in advance.