Setup prerelease environment for Release 4.0

[himeshr]

Refer Release Documentation: https://avni.readme.io/docs/release-process-for-the-cloud

• [x] Define environment variable AVNI_ETL_SERVICE_ORIGIN on avni server

• [x] Release server components (server, webapp, rules-server)

• [x] Release etl, ~integration-service, int-admin-app~, media-server and media-client

  ETL Deploy steps

  • • Get list of all organisation and orgGroups that have hasAnalyticsDB enabled
  • • Trigger ETL for all org and orgGroups mentioned in above list using API

  ~### integration-service deploy steps~ ~- - Before starting the server (it will fail if started anyway) run the sqls - https://github.com/avniproject/integration-service/blob/f0a85f10bc925bd74b6ec20d664af3d4c129f677/- egration-data/src/main/resources/db/onetime/prestart-merged-sql-files-to-one-folder.sql#L3-L2~ ~- - After starting the intergration service - run the sql present in keeweb with name "Goonj Integration Config".~ ~- - Restart the service~ ~- - Ensure Integration Health checks are working fine on prod for Power and other modules~

• [x] Update avni-media Lambdas

  • • Deploy avni media lambda (scripts/deploy-lambda-functions.sh) for https://github.com/avniproject/avni-media/issues/132

• [x] Create avni-client pre-release bundle from circleci

• [x] Inform in channel

[himeshr]

Prerelease APK : https://app.circleci.com/pipelines/github/avniproject/avni-client/1844/workflows/f0acac63-af77-4af7-97b7-f16a2e7915cd/jobs/11502/artifacts

[himeshr]

List of orgs to trigger ETL for

-- Get list of all organisation and orgGroups that have hasAnalyticsDB enabled

• select uuid from organisation where organisation.has_analytics_db = true; O/P : "d2bfe0d0-dddf-49db-8ac4-9eabfa652cd9" "aa37a437-054b-4b51-a197-db42ea9c6e1b" "0b1eaa64-ff89-4d77-b116-aa6dc8feae20" "b6dce7d5-9fa9-486e-8a5c-57baa992c24f"

• select uuid from organisation_group where organisation_group.has_analytics_db = true; O/P:

Postman collection to use for triggering ETL jobs

AVNI ETL.postman_collection.json.zip

[himeshr]

ETL enabled for following orgs in Pre-release:

"RWB 2023","0b1eaa64-ff89-4d77-b116-aa6dc8feae20" "GoonjUAT","63af72e6-5954-4096-93af-1312e47e2e64" "RWB NITI Aayog 2022","aa37a437-054b-4b51-a197-db42ea9c6e1b" "TestAB","b6dce7d5-9fa9-486e-8a5c-57baa992c24f" "RWB NGOs 2023","c349bb29-d309-4b10-9d2b-a986a3bd99ab" "RWB NITI Aayog UAT","d2bfe0d0-dddf-49db-8ac4-9eabfa652cd9" "JSSCP","d3a75adf-e5fb-4262-8681-c5f5eb36a88b"

[himeshr]

Commands to deploy lambda changes: needs aws access configured

himeshr@Himeshs-MacBook-Pro scripts % pwd /Users/himeshr/IdeaProjects/avni-media/scripts himeshr@Himeshs-MacBook-Pro scripts % ./deploy-lambda-functions.sh \<environment>