Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Automating question creation in Metabase [DMP 2024] #762

Closed
Tracked by #1369
ombhardwajj opened this issue Jul 20, 2024 · 0 comments
Closed
Tracked by #1369

Automating question creation in Metabase [DMP 2024] #762

ombhardwajj opened this issue Jul 20, 2024 · 0 comments

Comments

@ombhardwajj
Copy link
Contributor

ombhardwajj commented Jul 20, 2024 •
edited
Loading

What

Avni ETL creates an "Address" table and also creates tables for each and every subject type and encounters.
We will be automating, the creation of questions and saving them to the collection in Metabase.

Acceptance Criteria:

For tables listed below, the questions should be automatically created and saved to the collection:

  • subject types + "Address"
  • Encounter + subject type name + location
  • Program encounter - subject type name and id
    (maybe a few more to be added)

Related Issue : avniproject/avni-product#1562
@github-project-automation github-project-automation bot moved this to New Issues in Avni Product Jul 20, 2024
@ombhardwajj ombhardwajj mentioned this issue Jul 23, 2024
Open
7 tasks
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Jul 24, 2024
@ombhardwajj
avniproject#762 | A working API has been successfully built to automa…
25dbade 
…te the creation of questions for the tables subject types and Address
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Jul 27, 2024
@ombhardwajj
avniproject#762 | Metabase package created , API to get status of DB …
55393b5 
…sync created and waitforsync eliminated
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 5, 2024
@ombhardwajj
avniproject#762|Question creation for Programs and Encounters with Ad…
fdd1085 
…dress table automated
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 5, 2024
@ombhardwajj
avniproject#762|Question creation for Programs and Encounters with Ad…
1817387 
…dress table automated
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 6, 2024
@ombhardwajj
avniproject#762 | Some Refactoring changes in order to follow good co…
e8ec0c5 
…ding practises
@vinayvenu vinayvenu moved this from New Issues to Code Review Ready in Avni Product Aug 7, 2024
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 11, 2024
@ombhardwajj
avniproject#762 | Automated questions for Address,Media,Sync Telemetry
77bee27
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 11, 2024
@ombhardwajj
avniproject#762 | Automated questions for Address,Media,Sync Telemetry
b5bc0c6
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 21, 2024
@ombhardwajj
avniproject#762 | Reverted the changes made to application.properties
d67f40f
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 21, 2024
@ombhardwajj
avniproject#762 | Table Metadata is now used for finding the tables.M…
bd2ba34 
…ore modifications will be done during the day
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 22, 2024
@ombhardwajj
avniproject#762 | Minor fix when checking for tables
5014d5c
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 22, 2024
@ombhardwajj
avniproject#762 | Minor fix when checking for tables
bb9a681
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 22, 2024
@ombhardwajj
avniproject#762 | Enums added
b9dc476
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 24, 2024
@ombhardwajj
avniproject#762 | MetabaseJoin And MetabaseQuery created
6df633a
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 25, 2024
@ombhardwajj
avniproject#762 | MetabaseRequestBody added
812b4bd
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 25, 2024
@ombhardwajj
avniproject#762 | Shiftedcondition node to MetabaseJoin
a780ef6
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 25, 2024
@ombhardwajj
avniproject#762 | Shifted condition node to MetabaseJoin
3f8968c
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 28, 2024
@ombhardwajj
avniproject#762 | Enums Added
94650c8
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 28, 2024
@ombhardwajj
avniproject#762 | Enums Added
08f3705
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 28, 2024
@ombhardwajj
avniproject#762 | StringUtils shifted to S.java
7dba7f8
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 30, 2024
@ombhardwajj
avniproject#762 | Created a proper object for getDatabaseDetails
6b4edfb
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 31, 2024
@ombhardwajj
avniproject#762 | Proper object for field details created
b456232
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 31, 2024
@ombhardwajj
avniproject#762 | DatasetResponse added
935706b
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Aug 31, 2024
@ombhardwajj
avniproject#762 | Added AddressQuestionCreationService and QuestionCr…
5f58deb 
…eationService
ombhardwajj pushed a commit to ombhardwajj/avni-server that referenced this issue Sep 5, 2024
@nthapa000
avniproject#762 | MCI and MQB added and others modified
b2604a0
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 5, 2024
@ombhardwajj @nthapa000
avniproject#762 | MCI and MQB added and others modified
688f0a7
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 5, 2024
@ombhardwajj
avniproject#762 | MCI and MQB added and others modified
910ffb5
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 7, 2024
@ombhardwajj
avniproject#762 | Working code with MetabaseQueryBuilder and Question…
8ab39d2 
…CreationService
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 7, 2024
@ombhardwajj
avniproject#762 | Working code with MetabaseQueryBuilder and Question…
d6dbf4a 
…CreationService
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 7, 2024
@ombhardwajj
avniproject#762 | Working code with MetabaseQueryBuilder and Question…
e9ff297 
…CreationService
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 7, 2024
@ombhardwajj
avniproject#762 | Working code with MetabaseQueryBuilder and Question…
de870a1 
…CreationService
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 7, 2024
@ombhardwajj
avniproject#762 | renamed getTableDetailsByName to findTableDetailsBy…
74ec09d 
…Name and removed Primitive obsession
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | Dataset Request Body Created
19b66fd
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | Corrected the QuestionCreation RequestBody
05cf2ed
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | Removed primitive obsession from getDatabaseByName
9a185c4
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | Removed primitive obsession from getCollectionByName
4f382cc
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | DB and Collection are now fetched from DB if they a…
87849b0 
…rent cached
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | DB id and collection id are now fetched from Datbas…
33aa261 
…e incase they arent present in cache
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | DB and Collection are now fetched from DB if they a…
87c122f 
…rent cached
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 8, 2024
@ombhardwajj
avniproject#762 | Fixed question creation implementation for individu…
09b9cb4 
…al tables : Its now using AddressQuestionCreationService
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 9, 2024
@ombhardwajj
avniproject#762 | Fixed question creation implementation for individu…
dbef075 
…al tables : Its now using AddressQuestionCreationService
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 10, 2024
@ombhardwajj
avniproject#762 | Added FieldAttributes Enum , used it in MQB , Renam…
381d921 
…ed createQuestionForIndividualTable method , Deleted MetabaseJoin
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 11, 2024
@ombhardwajj
avniproject#762 | Encounter added , DatasetColumn added to get rid of…
d63b147 
… int literals
ombhardwajj added a commit to ombhardwajj/avni-server that referenced this issue Sep 11, 2024
@ombhardwajj
avniproject#762 | 1) Moved AddressQuestionCreationService logic to Da…
f621d61 
…tabaseService 2) Replaced getSubjectTypeNames usage of int literals with constants depictiing columnsNames 3)Created common method called by createQuestionsForSubjectTypes() and createQuestionsForPrograms(), createQuestionsForProgramsEncounters() and createQuestionsForEncounters() with List entityNames 4)Added CollectionItem , Now before creating questions, the existing ones are filtered out
himeshr added a commit that referenced this issue Sep 12, 2024
@himeshr
#762 | Remove unused schema param in createQuestionForTable() and rem…
f26b6fc 
…ove unused DatabaseService from MetabaseService
@himeshr himeshr moved this from Code Review Ready to QA Ready in Avni Product Sep 12, 2024
@github-project-automation github-project-automation bot moved this from QA Ready to Done in Avni Product Sep 13, 2024
@mahalakshme mahalakshme mentioned this issue Nov 4, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
Avni Product
Archived in project
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ombhardwajj