Deploy NameX Jobs and Services to Test and Finish Testing

[mengdong19]

NameX API has been deployed to prod. There are also updates to the jobs and services under NameX, see list bellow. These updated need to be deployed to test for testing.

Deploy checklist:
DEVELOPMENT:
Confirm all deployed to Dev

• Emailer
  • NAMEX PAY
  • SOLR UPDATER
  • SOLR FEEDER
  • SOLR_SYNONYMS_API
  • SOLR_ADMIN_APP - Richard also has some commits in main (confirm if they need to go to prod, or should they be removed)
  • NR Day Job
  • In Progress Job
  • BAD DESIGNATION JOB
  • BAD NAME NOTIFIER JOB
  • NOTEBOOK REPORT
  • SFTP_NUANS_REPORT

Confirm all tested in Dev

• Emailer
  • NAMEX PAY
  • SOLR UPDATER
  • SOLR FEEDER
  • SOLR_SYNONYMS_API
  • SOLR_ADMIN_APP - Richard also has some commits in main (confirm if they need to go to prod, or should they be removed)
  • NR Day Job
  • In Progress Job
  • BAD DESIGNATION JOB
  • BAD NAME NOTIFIER JOB
  • NOTEBOOK REPORT
  • SFTP_NUANS_REPORT

TEST:
Confirm all deployed to TEST

• Emailer
  • NAMEX PAY
  • SOLR UPDATER
  • SOLR FEEDER
  • SOLR_SYNONYMS_API
  • SOLR_ADMIN_APP - Richard also has some commits in main (confirm if they need to go to prod, or should they be removed)
  • NR Day Job
  • In Progress Job
  • BAD DESIGNATION JOB
  • BAD NAME NOTIFIER JOB
  • NOTEBOOK REPORT
  • SFTP_NUANS_REPORT

Confirm all tested in TEST

• Emailer
  • NAMEX PAY
  • SOLR UPDATER
  • SOLR FEEDER
  • SOLR_SYNONYMS_API
  • SOLR_ADMIN_APP - Richard also has some commits in main (confirm if they need to go to prod, or should they be removed)
  • NR Day Job
  • In Progress Job
  • BAD DESIGNATION JOB
  • BAD NAME NOTIFIER JOB
  • NOTEBOOK REPORT
  • SFTP_NUANS_REPORT

PRODUCTION:

• create draft github release with notes from document Omid Saved

• create zenhub release tag / add notes from draft github release

• tag this ticket with the zenhub release

• services to be deployed to PROD listed below: list each service including any config changes or post deployment steps

  • Service / Job list
    • 29493 rm nr attachment from magic-link consent-accepted emails namex#1862 29493 rm nr attachment from magic-link consent-accepted emails - Emailer
    • Namex pay db update namex#1891 Namex pay db update - NAMEX PAY
    • Solr updater upgrade namex#1896 Solr updater upgrade - SOLR UPDATER
    • Solr updater upgrade (#1896) namex#1897 Solr updater upgrade - SOLR UPDATER & NAMEX PAY
    • Feature nr day job db update namex#1900 Feature nr day job db update - NR Day Job
    • Inporgress job namex#1906 Inporgress job - In Progress Job
    • Emailer queue upgrade (#1911) namex#1912 Emailer queue upgrade - Emailer
    • Solr Feeder - search endpoint change namex#1914 Solr Feeder - search endpoint change - SOLR FEEDER
    • Feature db connector solr synonyms api namex#1918 Feature db connector solr synonyms api - Emailer, solr_synonyms_api
    • Feature solr admin sql connector namex#1924 Feature solr admin sql connector - solr_admin_app
    • Feature bad designator cloudsql namex#1928 Feature bad designator cloudsql - bad_designation_notifier
    • Feature cloudsql bad name notifier namex#1930 Feature cloudsql bad name notifier - bad_name_notifier
    • use cloudsql (#1931) namex#1932 use cloudsql - notebook_report
    • Feature cloudsql sftp nuans (#1933) namex#1934 Feature cloudsql sftp nuans - sftp_nuans_report
  • post deplyment steps:
    • upgrade db
    • run ___ script/job

• Dev to ensure that the commit list is represented on the release report

• QA to schedule the release with staff/clients (daytime's best or when staff are available for rollback)

• All dev/test pipeline test suites green

• Dev/QA chat to plan for testing (unless already automated)

• OCM requirements listed below

  • fill this out (i.e. None, ...)

• deployment to sandbox (remove if not applicable)

  • external dependencies resolved
  • configs updated, services deployed, post deployment complete
  • regression testing complete
  • mandatory wait time complete

• deployment to prod

  • OCM steps completed
  • external dependencies resolved
  • configs updated, services deployed, post deployment complete
  • regression testing complete

• publish github release containing auto generated notes

[ozamani9gh]

Release Notes for DRAFT github release.

29493 rm nr attachment from magic-link consent-accepted emails by @EPortman in bcgov/namex#1862
Namex pay db update (#1891) by @bolyachevets in bcgov/namex#1892
Solr updater upgrade (#1896) by @bolyachevets in bcgov/namex#1897
Feature nr day job db update by @bolyachevets in bcgov/namex#1900
Inporgress job (#1906) by @bolyachevets in bcgov/namex#1907
Emailer queue upgrade (#1911) by @bolyachevets in bcgov/namex#1912
Solr Feeder - search endpoint change by @kialj876 in bcgov/namex#1914
Feature db connector solr synonyms api by @bolyachevets in bcgov/namex#1918
Feature solr admin sql connector by @bolyachevets in bcgov/namex#1924
Feature bad designator cloudsql by @bolyachevets in bcgov/namex#1928
Feature cloudsql bad name notifier by @bolyachevets in bcgov/namex#1930
use cloudsql (#1931) by @bolyachevets in bcgov/namex#1932
Feature cloudsql sftp nuans (#1933) by @bolyachevets in bcgov/namex#1934

[mengdong19]

SOLR_SYNONYMS_API deploy is blocked by the following ticket. All other services and jobs are pushed to test ready for QA.
https://app.zenhub.com/workspaces/names-team-board-new-655554cbddd49510027dad2e/issues/gh/bcgov/entity/31778