development-2023-08-30.50

What's Changed

• Adds database connection and basic Trusts endpoint by @LewisDaleUK in #2
• Change file structure so that TramsDataApi.sln is top level by @RobertM905 in #4
• Update azure-pipeline to add test step with a mssql server container by @RobertM905 in #5
• Update tests to use DbFixture by @RobertM905 in #6
• Add db container for tests by @RobertM905 in #7
• Update full test action to only run for PRs as the main deploy includ… by @RobertM905 in #8
• Update github actions by @RobertM905 in #9
• Added basic factory, response models for Trust by @LewisDaleUK in #10
• Fixed typos in IFDDataResponse by @LewisDaleUK in #11
• Move database to gateway by @LewisDaleUK in #12
• Add ifd data and academies to trusts by @RobertM905 in #13
• Enable swagger in prod by @LewisDaleUK in #15
• Get establishment by ukprn by @RobertM905 in #14
• Index trusts by @LewisDaleUK in #16
• Modify get trusts route by @LewisDaleUK in #17
• Added get all and get by id routes for academy conversion projects by @madeviv in #19
• WIP: Create academy transfer project by @RobertM905 in #18
• Added route to get establishment by URN by @madeviv in #20
• Add rationale fields to academy conversion project response by @rf-mt in #21
• Add instructions to README for database migrations by @LewisDaleUK in #22
• Quick patch to fix heading levels by @LewisDaleUK in #23
• Patch academy transfer project by @RobertM905 in #24
• Get academy transfer project by @LewisDaleUK in #25
• Index academy transfer projects route by @RobertM905 in #26
• Replace urn with ukprn for trusts by @LewisDaleUK in #27
• Updated searching to return values based on all matches by @LewisDaleUK in #28
• Update rationale property names in academy conversion response by @rf-mt in #29
• Make RddOrEsfaIntervention nullable for AT Requests by @danielburnley in #30
• Update academy conversion project by @rf-mt in #31
• Add pagination to index trusts by @RobertM905 in #32
• Rationale mark as complete + Academy Conversion Project table by @rf-mt in #33
• Map Local Authority Information Template fields by @rf-mt in #34
• Fix local authority fields in integration tests by @rf-mt in #36
• A2B: Risks and issues by @madeviv in #35
• Set LA dates to null if they're set to default DateTime in update request by @rf-mt in #37
• Added mapping for a2b school performance additional info by @madeviv in #38
• Get educational performance KeyStage 1 and 2 data by @RobertM905 in #41
• Map school budget information fields when updating by @rf-mt in #40
• Update progress scores by @RobertM905 in #42
• Map general information data by @madeviv in #43
• Added integration for A2B school and trust info by @madeviv in #45
• Add key stage 4 data by @RobertM905 in #44
• Add AT general information author and recommendation fields by @StewartBarker in #47
• Group national education performance data by year by @RobertM905 in #48
• Add general information object to request and response models by @StewartBarker in #49
• Project notes by @rf-mt in #46
• Added hosted service to sync academy conversion projects by @madeviv in #51
• Add national average data to key stage 2 by @RobertM905 in #53
• Order project notes by date descending when retrieving by @rf-mt in #52
• Allow removing date when value default by @madeviv in #54
• Get trust name and refactor to gateways by @madeviv in #55
• Index establishments by @LewisDaleUK in #56
• Map school pupil forecasts additional info when updating and retrieving ACP by @rf-mt in #57
• Add national and local authority data by @RobertM905 in #58
• Api key management by @LewisDaleUK in #59
• Map key stage additional info when retrieving and updating ACP by @rf-mt in #60
• Only return ACPs if they have a school name by @rf-mt in #61
• Ensure project note date is set correctly regardless of where code is hosted by @rf-mt in #62
• Add AT additional information fields by @StewartBarker in #63
• Sync pupil forecast fields to ACP + map in response by @rf-mt in #64
• Add fuzzy search by @nouriach in #50
• Map pupil forecast fields in update request by @rf-mt in #65
• Update README.md to include instructions on creating a Personal Access Token for Github by @LewisDaleUK in #66
• Add keystage 5 response data and update tests by @RobertM905 in #67
• Correct mapping of ACP application received date by @rf-mt in #68
• 70670: MisEstablishment returning null for Further Education Establishments by @nouriach in #69
• Add check for account's local authority when getting education performance data by @RobertM905 in #71
• Remove incorrect Assigned to me date mapping in Ifd pipeline sync by @rf-mt in #70
• 70834 Missing Academy Performance Data by @nouriach in #72
• Amend academy conversion data to use GeneralDetailsAcademyUrn by @StewartBarker in #75
• Revert view academy conversions urn by @StewartBarker in #76
• Fix to academy performance data by @StewartBarker in #77
• Map previous head teacher board fields when updating and retrieving ACP by @rf-mt in #74
• Add API versioning by @nouriach in #78
• Add conditional to check GroupType is Trust by @nouriach in #79
• Add logging by @LewisDaleUK in #73
• Revert "Add logging" by @LewisDaleUK in #80
• Add census data in csv by @RobertM905 in #81
• Add cesnsus data file as a resource to fix filepath issues by @RobertM905 in #83
• Add census SEN field to EstablishmentResponseFactory by @StewartBarker in #84
• Explicitly require Newtonsoft.Json in csproj files by @LewisDaleUK in #82
• KS4 additional info by @rf-mt in #85
• Revert "Revert "Add logging"" by @LewisDaleUK in #86
• Only return single and multi academy trusts by @danielburnley in #87
• KS5 additional info by @rf-mt in #88
• Add entering ebacc ks4 data by @RobertM905 in #89
• Change la and national fields to use entering ebacc field by @RobertM905 in #90
• Add applied general and academy progress data to ks5 by @RobertM905 in #91
• Add middleware for decoding query params by @RobertM905 in #92
• Set distance to hq field to null when updated with default decimal by @rf-mt in #93
• (71578) Add state filter to conversion projects route by @RobertM905 in #94
• Add extra fileds to business central route by @RobertM905 in #95
• 74379 add paging to api v2 response by @MartinWheelerMT in #96
• Add conversion support grant to a2b projects by @danielburnley in #98
• Fix - Paging Response and ProjectStatus when search without state on V2 Controller by @MartinWheelerMT in #97
• Update academy type and route & conversion grant by @danielburnley in #99
• 75595 / 75594 - Update and enrich swagger doc by @MartinWheelerMT in #100
• Support patching conversion grant fields by @danielburnley in #101
• Allow dates to be updated to null by @StewartBarker in #102
• Handle partially available data when building KS5 response by @MartinWheelerMT in #103
• Add concerns cases by @RobertM905 in #104
• AT-Add fields to state if the date fields are required by @StewartBarker in #105
• Add get concerns case by ukprn and urn by @RobertM905 in #106
• 76934 Add Address and TrustType to trusts controller by @MartinWheelerMT in #107
• 76934 - Add paging to V2 trusts controller by @MartinWheelerMT in #108
• Fixes to concerns endpoints by @RobertM905 in #109
• fix/500-errors-on-concerns-endpoints by @MartinWheelerMT in #110
• Update v2 trust endpoint naming to be consistent with v1 endpoints by @RobertM905 in #112
• Rename ReasonForReview to ReasonAtReview in concerns request by @RobertM905 in #111
• Add index route for concerns statuses by @RobertM905 in #113
• Add create concerns record route by @RobertM905 in #114
• Add single object v2 response by @RobertM905 in #115
• Remove depreciated table column from gias establishment by @RobertM905 in #116
• Add fk relationship between ConcernsRecords and ConcernsCases by @RobertM905 in #117
• Add concerns ratings by @RobertM905 in #119
• Update v2 controllers to use the single response by @RobertM905 in #118
• Add PATCH update route for Concerns Cases by @RobertM905 in #120
• Rename reviewed at field for concerns case response by @RobertM905 in #121
• Add get concerns types route by @RobertM905 in #122
• Update concerns ratings seed data by @RobertM905 in #123
• Add patch route for updating records by @RobertM905 in #124
• Academy conversion - added MP name and party, Get and Update by @CathLass in #125
• 80413 create database models and migrations for A2B entities by @MartinWheelerMT in #126
• Update concerns db object createdat and updatedat fields by @RobertM905 in #127
• Add get concerns records by case urn by @RobertM905 in #128
• A2b create get post endpoints for application by @MartinWheelerMT in #129
• Add get concerns case by owner by @RobertM905 in #130
• A2b create get post endpoints for application key persons by @MartinWheelerMT in #131
• Remove unneeded request models from A2BApplication and A2BApplicationKeyPersons by @MartinWheelerMT in #132
• Add GET / Post Endpoints for A2BApplicationStatus by @MartinWheelerMT in #133
• Add rating urn field to concerns cases by @RobertM905 in #135
• Add Get / POST endpoints for A2BApplyingSchool by @MartinWheelerMT in #134
• Add mapping for case response by @RobertM905 in #138
• Remove primary boolean field from concerns records by @RobertM905 in #136
• Add validation for rating urn when creating and updating concerns cases by @RobertM905 in #137
• Remove primary boolean field from record response and request by @RobertM905 in #139
• Add GET / POST endpoints for A2BApplyingSchool by @MartinWheelerMT in #140
• Add POST/GET routes to create A2B School Loans by @RobertM905 in #141
• Create GET / POST endpoints for A2B School Lease by @MartinWheelerMT in #142
• Create GET / POST endpoints for A2B School Lease by @MartinWheelerMT in #143
• Added readme to solution items by @wystanpalm-madetech in #144
• Feature/cypress test poc configs by @Lisa-V-Sau in #146
• Feature/84613 Update Academy Transfers Project search by @acarbutt in #149
• 76362 - amend A2B External endpoints - Application 1 by @MartinWheelerMT in #148
• Remove node-modules from CypressTest by @MartinWheelerMT in #151
• 763620 amend a2b external endpoints application2 by @MartinWheelerMT in #150
• 85223 create fss api by @HussenShambeshDfE in #152
• Removed the FSSProjectDataView migration files by @mishraksantosh in #154
• Feature/school application form mods by @CathLass in #153
• Feature/87756 add additional information fields for Academy Transfers by @acarbutt in #155
• Remove database name from sql for PP release by @acarbutt in #156
• adding Cypress commands to azure-pipelines.yaml by @MichaelDally in #159
• Added Cypress for Academy Transfer by @asifali3111 in #157
• removed pipeline code - did not work as intended by @MichaelDally in #160
• Feature/81829 new fields project conversion by @HussenShambeshDfE in #158
• Removed proposedacademyadditionfields view migration and skipped integration test by @mishraksantosh in #161
• 89785: Test against json schema by @Lisa-V-Sau in #163
• A2BApplication loans and leases by @CathLass in #162
• 89785: Test against json schema by @Lisa-V-Sau in #164
• Updated Academy E2E tests by @asifali3111 in #166
• Fix Apply To Become internal database issues, remove unneeded A2B entities, correct types of models by @MartinWheelerMT in #169
• Skip json schema tests by @Lisa-V-Sau in #170
• Feature/90276 add section completed columns by @StewartBarker in #168
• Added 2 fields to FSSProject Response , (DB view change to be rolled … by @mishraksantosh in #171
• Reverted the changes to Academic Conversion API (5 addional fileds we… by @mishraksantosh in #172
• Feature/87221 Any Risks by @acarbutt in #173
• Fix: Un-skip test by @Lisa-V-Sau in #174
• Add change in view as part of release 150 by @acarbutt in #175
• SRMA data models and migrations scripts by @Menol-LK in #176

New Contributors

• @LewisDaleUK made their first contribution in #2
• @RobertM905 made their first contribution in #4
• @madeviv made their first contribution in #19
• @rf-mt made their first contribution in #21
• @danielburnley made their first contribution in #30
• @StewartBarker made their first contribution in #47
• @wystanpalm-madetech made their first contribution in #144
• @MichaelDally made their first contribution in #159
• @asifali3111 made their first contribution in #157

Full Changelog: https://github.com/DFE-Digital/academies-api/commits/development-2023-08-30.50