IT Partners README.MD file

Summary:

This is the new Program Information for IT Partners, used to organize programs, credentials, and courses.

Production location:

This consists of five applications:

• ProgramInformationV2: The Blazor server application to handle back-end functions. https://programcourse.itpartners.illinois.edu
• ProgramInformationV2.Function: The Function Application for the API. https://programcourseapi.itpartners.illinois.edu
• ProgramInformationV2.LoadFromEdw: A console application used to batch load items from EDW
• ProgramInformationV2.Data: The data access for all the processes
• ProgramInformationV2.Search: The data access for searching (accessing AWS OpenSearch Service)

Development location:

Currently, none. We do development on local machines, and will host temporary sites when end users need to see development work.

How to deploy to production/development:

CI/CD

How to set up locally:

Download and point to an empty AWS OpenSearch Service. The function code will install the necessary indicies, and the blazor app will install the database tables.

You can get your IP address by using http://checkip.amazonaws.com/.

Information about EF Core Tools:

Make sure the ProgramInformationV2 project is set up as the startup project before running the commands below:

Add-Migration -Name {migration name} -Project ProgramInformationV2.Data

Update-Database -Project ProgramInformationV2.Data

If you run into the issue "The certificate chain was issued by an authority that is not trusted.", then add TrustServerCertificate=True to the connection string.

Console App

The console application is used to run batches of imports manually. This probably will be done once a semester. The two types of import batches are:

• Course Information. This uses the https://courses.illinois.edu/cisapp/explorer/schedule/ application to get courses by rubric and load them. This overwrites existing course information in the system.
• Faculty Names. This takes a list of names and does a mass change of faculty names to add NetIDs and URLs. The information can be pulled from the directory API using the attached HTML page.

Code to delete the test items in the OpenSearch Service

`` POST /pcr2_courses/_delete_by_query { "query": { "match": { "source": "test" } } }

POST /pcr2_requirementsets/_delete_by_query { "query": { "match": { "source": "test" } } }

POST /pcr2_programs/_delete_by_query { "query": { "match": { "source": "test" } } }

POST /pcr2_staticcode/_delete_by_query { "query": { "match": { "source": "test" } } } ``