* EF Database Support Init (#1221)
* scaffolding for ef support
* deleted old postgres repos
* added tables to oncreate
* updated all the things to .NET 5
* Addition to #1221: Migrated DockerFiles from dotnet/3.1 to 5.0 (#1223)
* Migrated DockerFiles from dotnet/3.1 to 5.0
* Migrated SSO/Dockerfile from dotnet 3.1 to 5.0
Co-authored-by: Daniel James Smith <djsmith85@users.noreply.github.com>
* EFDatabaseSupport: Updated links and description in README.md and SETUP.md (#1232)
* Updated requirements in README.md
* Updated link to documentation of app-secrets
* upgraded dotnet version to 5.0
* Ef database support implementation examples (#1265)
* mostly finished testing the user repo
* finished testing user repo
* finished org, user, ssoconfig, and ssouser ef implementations
* removed unused prop
* fixed a sql file
* fixed a spacing issue
* fixed a spacing issue
* removed extra database creation
* refactoring
* MsSql => SqlServer
* refactoring
* code review fixes
* build fix
* code review
* continued attempts to fix the the build
* skipped another test
* finished all create test
* initial pass at several repos
* continued building out repos
* initial pass at several repos
* initial pass at device repo
* initial pass at collection repo
* initial run of all Entity Framework implementations
* signup, signin, create/edit ciphers works
* sync working
* all web vault pages seem to load with 100% 200s
* bulkcopy, folders, and favorites
* group and collection management
* sso, groups, emergency access, send
* get basic creates matching on all repos
* got everything building again post merge
* removed some IDE config files
* cleanup
* no more notimplemented methods in the cipher repo
* no more not implementeds everywhere
* cleaned up schema/navigation properties and fixed tests
* removed a sql comment that was written in c# style
* fixed build issues from merge
* removed unsupported db providers
* formatting
* code review refactors
* naming cleanup for queries
* added provider methods
* cipher repo cleanup
* implemented several missing procedures from the EF implementation surround account revision dates, keys, and storage
* fixed the build
* added a null check
* consolidated some cipher repo methods
* formatting fix
* cleaned up indentation of queries
* removed .idea file
* generated postgres migrations
* added mysql migrations
* formatting
* Bug Fixes & Formatting
* Formatting
* fixed a bug with bulk import when using MySql
* code review fixes
* fixed the build
* implemented new methods
* formatting
* fixed the build
* cleaned up select statements in ef queries
* formatting
* formatting
* formatting
Co-authored-by: Daniel James Smith <djsmith85@users.noreply.github.com>
* Revert "Encode into b64 to avoid illegal xml encoding when sending to Azure (#1425)"
This reverts commit 2c9a5bb4ab.
* Azure queue to use base64 encoding universally
* Ensure byte size calc is using encoded byte count
* Remove message text extension from blockIP svc
* Remove unused using on blockIp hosted service
* Encode into b64 to avoid illegal xml encoding when sending to Azure
* Revert "Encode into b64 to avoid illegal xml encoding when sending to Azure"
This reverts commit d50de941da.
* HtmlEncode strings if they use multi-byte characters
* Add serializer to event processor
* Rename to used class
* Formatting
* PR feedback
* Remove hard coded database name
* Update permissions on build scripts
* Update Setup project and run scripts for configuring database name
* Remove hyphen from database name flag
* Update with suggested changes, still needs testing
* Revert SQL statements to concatenantion for testing
* Fix typo
* Update util/Setup/EnvironmentFileBuilder.cs
Co-authored-by: Chad Scharf <3904944+cscharf@users.noreply.github.com>
* Update SQL commands to prevent SQL injection attacks
Co-authored-by: Chad Scharf <3904944+cscharf@users.noreply.github.com>
* Creat TVP prior to opening sql connection
Data Table creation is slow. connection may be timing out while we create it.
* USe MARS-enabled connections to fix connection issue
https://github.com/dotnet/SqlClient/issues/54
* Update workflow for db migrations
* Remove typo
* Updating qa-deploy workflow for database migrations
* Test DB migrations on test database
* Remove test code
* Test inputs as boolean
* Update if statements to properly test for truth value
* Fix typo
* Add if to deploy so that it will execute always after database steps
* adding the EventProcessor docker container
* fixing the matrix name in the setup step
* changing the name of the EventsProcessor application
* adding the missing docker repo login as well as changing how we are setting the docker trust environment variables
* Added SsoConfigService tests
* Cleanup whitespace in SsoConfigServiceTests
* Work on PolicyServiceTests
* Refactor PolicyService to remove uneeded calls
* Implement Code Coverage
* Continued work on PolicyServiceTests
* Revert "Implement Code Coverage"
This reverts commit 4ada179ada.
* Fix PolicyServiceTests after rebasing
* Cleanup unused namespaces
* Added assertions that saving or logging of save aren't happening on exceptions
* updating the qa deploy to dynamically pull the publish profile instead of proxying it through a key vault
* fixing the download-artifact hash
* fixing typo
* trying out the custom keyvault getter
* fixing the new deploy matrix
* fixing the custom action path
* setting custom action commit hash
* paramaterized the deploy job
* adding the staging slot to the publish profiles
* trying a custom way to pull the publishing profile
* removing the publish profile altogether since it might not even be needed
* removing unnecessary publish profile stuff
* removing the subscription id from the qa deploy workflow
* adding auto swap for QA identity
* adding the rest of the webapp slot swapping automation
* fixing the job dependencies
* fixing the matrix name variable and adding some debugging code
* removing admin and identity out of the matrix swap
* switching the alive check
* fixing the identity endpoint
* fixing the while loops
* adding in sleeps to see if it is a matrix issue
* running the matrix sequentially to see if that rids us of the slot swapping conflits
* removing the sleep command in the matrix
* removing the sequential controller
* disabling the build and deploy for swapping tests
* changing the live test a bit
* fixing the identity status url
* adding in a fail safe if not hit the alive endpoint
* fixing the azure secret names
* removing the debugging code
* Update QA Deploy Workflow (#1387)
* Testing workflow
* Add whitespace to workflow
Co-authored-by: Vince Grassia <593223+vgrassia@users.noreply.github.com>
* fix release asset upload
* adding Version to release name
* restricting QA deploys to only manual trigger
* constraining all releases to the rc branch
* removing the release message update
Addison Beck
Vincent Salucci
Oscar Hinton
Davis Templeton
Chad Scharf
Thomas Rittson
Matt Gibson
Joseph Flinn
Vince Grassia
Justin Baur
Kyle Spearrin
Matt Portune
Jens Spanier