Modify `db_fields` hash in translation.rb config

aaronskiba commented 1 month ago

Fixes #553

Changes proposed in this PR:

This commit modifies how the templates-related tables ('templates', 'phases', 'sections', 'questions', 'annotations', and 'question_options') are queried within our customisation of the translation gem. All of those related tables are removed from config.db_fields. However, the tables (along with their previously specified columns) are now all included in the newly added Template ActiveRecord query (line 24). Rather than returning all of the db entries, this query only returns those that relate to the app's default_org.
'CallableQueries' => [templates_data_for_default_org_proc] has been added to config.db_fields.def templates_data_for_default_org_proc returns a proc. This proc will be called within the translation gem, where it will execute the aforementioned Template ActiveRecord query. Finally, the returned entries will be uploaded to translation.io.

aaronskiba commented 1 month ago

The code to handle @db_fields['CallableQueries'] is currently within the following open PR: https://github.com/ualbertalib/translation_io_rails/pull/5. This PR will remain a Draft until the other is merged.

aaronskiba commented 1 month ago

Some manual testing of this PR is documented in issue https://github.com/portagenetwork/roadmap/issues/553.

portagenetwork / roadmap