inseefr/public-enemy-back-office

Back-office services for Public-Enemy

public-enemy-back-office's Issues

add unit tests

Reset state data for a survey unit

When listing survey units, a user can reset state data for a specific unit

add queen as orchestrator

Uses queen and stromae as orchestrators in Public Enemy (at this time, only stromae is used)

When context is household and mode is ( CATI or CAPI), orchestrator will be queen
When context is household and mode is CAWI, orchestrator will be stromae

Questionnaire update in Stromae backoffice

When updating questionnaire, handle synchronisation if modes are updated

Expose questionnaire url for a surveyUnit

Add an endpoint to get the url of a questionnaire for a surveyUnit.

input

• questionnaireId* : string
• modeName* : (CAWI, ...)
• surveyUnitId* : string

output : calculated url

considering stromaeUrl/queenUrl as env variable for both front apps, and questApiUrl as env variable for questionnaire api :

if modeName = CAWI
=> ${stromaeUrl}/questionnaire/${questionnaireId}/unite-enquetee/${surveyUnitId}

else :
questionnaireUrl = ${questApiUrl}/questionnaire/${questionnaireId}
dataUrl = ${questApiUrl}/survey-unit/${surveyUnitId}
nomenclature = check how to do 😄

=> ${queenUrl}/queen/visualize?questionnaire=${questionnaireUrl}&data={dataUrl}$nomenclature=${nomenclature}

Retrieve DDI from Pogues

🇬🇧 Retrieve questionnaire DDI with Pogues id

• get the JSON from Pogues
• transform it to DDI with Pogues

🇫🇷 Récupérer le DDI d'un questionnaire à partir de son ID Pogues

• Récupérer le questionnaire au format JSON depuis Pogues
• Le transformer en DDI avec Pogues

Retrieve the questionnaire in JSON Lunatic format

🇬🇧 Retrieve the questionnaire in JSON Lunatic format from ENO. We need to provide mode, context and DDI to get the JSON

🇫🇷 Récupérer le questionnaire au format Lunatic JSON. Nous devons fournir le mode, contexte et DDI pour récupérer le JSON

Run: log by default to stdout

For kube world, we have to write log in stdout, actually app log into a file /opt/pe/LOG_PATH_IS_UNDEFINED/tmp/spring.log file.

Do not allow multiple questionnaire creation for a same questionnaire pogues id

Initialize new api version

🇬🇧 Initialize new version of the backoffice version

• technical environment
• exception handling
• liquibase
• logs
• database access
• DB CRUD questionnaire
• Get questionnaire details from pogues (including json lunatic)

🇫🇷 Initialiser la nouvelle version du backoffice

• mise en place de l'environnement technique
• gestion des exceptions
• mise en place de liquibase
• logs
• Accès bases de données
• CRUD questionnaire
• Get questionnaire details from pogues (including json lunatic)

Handle CSV verification with pogues external variables

CI Integration

Detect when modes from public enemy DB and pogues are different

When retrieving a questionnaire, the api should detect if the modes from pogues questionnaire are different from modes in public enemy db.

Handle synchronisation between DB and orchestrators on errors

When errors are throwed (API calls, DB), how to handle sync ?

Limit units in csv to 10

Limit to 10 the number of survey units in the csv uploaded by user

Expose csv content from existing questionnaire

questionnaire creation/deletion in queen backoffice

Create/delete questionnaire from queen backoffice.

Generate CSV schema example for survey units

Generate and expose CSV schema from a specific questionnaire. This schema contains external variables used for customizing survey units data.

Support composed questionnaire

Currently, Public Enemy doesn't support questionnaires containing reference to other questionnaires:

• when loading the data file, variables belonging to a referenced questionnaire are unknown
• when visualising, only the host questionnaire is visible.

Handle more granular exceptions

🇬🇧 Handle more granular exceptions, with json responses
🇫🇷 Gestion plus fine des exceptions, avec des réponses au format json

Get questionnaire details from pogues

Retrieve and expose questionnaire details from pogues with pogues identifier

Create survey units from csv file

CRUD questionnaire

🇬🇧 Handle Questionnaire Creation/Read/Update/Delete in Public Enemy DB
🇫🇷 Gestion de la création/lecture/modification/suppression dans la base de données Public Enemy

Dependency Dashboard

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Rate-Limited

These updates are currently rate-limited. Click on a checkbox below to force their creation now.

• chore(deps): update dependency org.jacoco:jacoco-maven-plugin to v0.8.12
• fix(deps): update dependency org.springframework.boot:spring-boot-starter-parent to v3.3.1
• chore(deps): update actions/checkout action to v4
• chore(deps): update actions/setup-java action to v4
• chore(deps): update github artifact actions to v4 (major) (actions/download-artifact, actions/upload-artifact)
• chore(deps): update softprops/action-gh-release action to v2
• 🔐 Create all rate-limited PRs at once 🔐

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• chore(deps): update eclipse-temurin docker tag to v21.0.3_9-jre
• chore(deps): update dependency maven to v3.9.8
• chore(deps): update dependency maven-wrapper to v3.3.2
• chore(deps): update dependency org.postgresql:postgresql to v42.7.3
• chore(deps): update mukunku/tag-exists-action action to v1.6.0
• chore(deps): update okhttp monorepo to v4.12.0 (com.squareup.okhttp3:mockwebserver, com.squareup.okhttp3:okhttp)
• fix(deps): update dependency com.opencsv:opencsv to v5.9
• fix(deps): update dependency org.modelmapper:modelmapper to v3.2.0
• fix(deps): update dependency org.springdoc:springdoc-openapi-starter-webmvc-ui to v2.5.0
• chore(deps): update actions/cache action to v4
• Click on this checkbox to rebase all open PRs at once

Detected dependencies

dockerfile

Dockerfile

• eclipse-temurin 21-jre

github-actions

.github/workflows/build-pr.yml

• actions/checkout v3
• actions/setup-java v3

.github/workflows/release-develop.yml

• actions/checkout v3
• mukunku/tag-exists-action v1.2.0
• actions/checkout v3
• requarks/changelog-action v1
• softprops/action-gh-release v1
• actions/checkout v3
• actions/setup-java v3
• actions/upload-artifact v3
• actions/checkout v3
• actions/download-artifact v3
• elgohr/Publish-Docker-Github-Action v5

.github/workflows/release-main.yml

• actions/checkout v3
• mukunku/tag-exists-action v1.2.0
• actions/checkout v3
• requarks/changelog-action v1
• softprops/action-gh-release v1
• actions/checkout v3
• actions/setup-java v3
• actions/upload-artifact v3
• actions/checkout v3
• actions/download-artifact v3
• elgohr/Publish-Docker-Github-Action v5

.github/workflows/sonar.yml

• actions/checkout v3
• actions/setup-java v3
• actions/cache v3
• actions/cache v3

maven

pom.xml

• org.springframework.boot:spring-boot-starter-parent 3.3.0
• com.squareup.okhttp3:okhttp 4.10.0
• com.squareup.okhttp3:mockwebserver 4.10.0
• org.modelmapper:modelmapper 3.1.1
• com.opencsv:opencsv 5.7.1
• org.springdoc:springdoc-openapi-starter-webmvc-ui 2.0.4
• org.jacoco:jacoco-maven-plugin 0.8.11
• org.postgresql:postgresql 42.6.2

maven-wrapper

.mvn/wrapper/maven-wrapper.properties

• maven 3.8.6
• maven-wrapper 3.1.0

---

• Check this box to trigger a request for Renovate to run again on this repository