GitHub-Bitwarden/server - server - Gitea: Git with a cup of tea

Author	SHA1	Message	Date
Brandon Treston	81bff5e5cf	[PM-11622] use organization domains (#5560 ) * DBO changes * Add migration scripts * wip * wip * wip * add EF migrations * run dotnet format * cleanup * revert business logic * wip * add update statement to mssql migration script * fix user service tests * increment license, add UseOrganizationDomains * add migration helpers to seed initial value from UseSso * clean up * cleanup * fix mssql migrations * fix license version and test * fix file names * fix license json * add missing property to license test * rename file * fix migrations * fix migration * add WHERE to helper scripts * separate schema/data migrations * restore comment * Merge conflict * fix migrations * add new property to migration * wip * fix file names * fix file name	7 months ago
Ike	02fee8c1e9	[PM-8108] Add Duo SDK v4 metadata to Duo Two Factor Provider (#4774 ) * Migrate Duo Two Factor Configuration to support both v2 and v4 * Postgres Migrations * SQLite migrations * comment updates for SQLite; Query changes for consistency; * comment clean up; formatting	1 year ago
Rui Tomé	f5caecc6d6	[AC-1722] Deprecate "Edit/Delete Assigned Collections" custom permissions (#4604 ) * Add SQL script to migrate custom users with specific permissions to User type Remove 'editAssignedCollections' and 'deleteAssignedCollections' properties from Permissions in OrganizationUser table. Migrate custom users who only have these permissions to the User type. * Add MySQL migration to migrate custom users with specific permissions to User type * Add Postgres migration to migrate custom users with specific permissions to User type * Add Sqlite migration to migrate custom users with specific permissions to User type * Update AutoFixture usage in tests to resolve creating ILogger mock instances * Update EF integration tests database contexts to use each respective Migrations assembly. Configure Sqlite instance * Add RunMigration method to BaseEntityFrameworkRepository * Add FinalFlexibleCollectionsDataMigrationsTests * Improve data migration efficiency by using OPENJSON instead of multiple JSON_EXTRACT * Add batching to the sql data migrations * Update DbMigrator to run a specific script based on its name * Update DatabaseDataAttribute to be able to test a specific migration * Add reference to the migration projects to Infrastructure.IntegrationTest * Add integration test to test the migration FinalFlexibleCollectionsDataMigrations * Remove EFIntegration tests and remove RunMigration method from BaseEntityFrameworkRepository * Add IMigrationTesterService and implementations for SQL and EF migrations * Add FinalFlexibleCollectionsDataMigrationsTests and remove test from OrganizationUserRepositoryTests * Update sql data migration script based on performance feedback * Bump date on EF migration scripts * Add xmldoc comments to IMigrationTesterService and each implementation * Bump up the date on the EF migration scripts * Bump up dates on EF migrations * Added tests to assert no unwanted changes are made to the permissions json. Refactor tests. * Revert changes made to DbMigrator and refactor SqlMigrationTesterService to not use it. * Add method description * Fix test to assert no changes are made to custom user * Remove unnecessary COALESCE and SELECT CASE * Unident lines on SQL script * Update DatabaseDataAttribute MigrationName property to be nullable * Fix null reference checks * Remove unnecessary COALESCE from Postgres script * Bump dates on migration scripts * Bump up dates on EF migrations * Add migration tests for handling null * Add test for non json values * Fix test * Remove migrations * Recreate EF migrations * Update Postgres data migration script to check for valid JSON in Permissions column --------- Co-authored-by: Thomas Rittson <31796059+eliykat@users.noreply.github.com> Co-authored-by: Thomas Rittson <trittson@bitwarden.com>	1 year ago
Rui Tomé	b3e5076128	[AC-1978] Flexible collections: EF data migrations for deprecated permissions (#3969 ) * [AC-1682] Added MySql migration and script (cherry picked from commit `d367f6de6b`) * [AC-1682] Added Postgres migration and script (cherry picked from commit `9bde1604da`) * [AC-1682] Added Sqlite migration and script (cherry picked from commit `262887f9c3`) * [AC-1682] dotnet format (cherry picked from commit `00eea0621c`) * [AC-1682] Fixed Sqlite query (cherry picked from commit `26f5bf8afd`) * [AC-1682] Drop temp tables if they exist when starting the scripts (cherry picked from commit `c20912f95c`) * [AC-1682] Removed MySql transaction from script because EF migration already wraps it under its own transaction (cherry picked from commit `7b54d78d67`) * [AC-1682] Setting FlexibleCollections = 1 only for Orgs that had data migrated in previous steps (cherry picked from commit `28bba94d81`) * [AC-1682] Updated queries to check for OrganizationId (cherry picked from commit `a957530d5e`) * [AC-1682] Fixed MySql script (cherry picked from commit `deee483ab7`) * [AC-1682] Fixed Postgres query (cherry picked from commit `c3ca9ec3c8`) * [AC-1682] Fix Sqlite query (cherry picked from commit `fada0a81bf`) * [AC-1682] Reverted scripts back to enabling Flexible Collections to all existing Orgs (cherry picked from commit `bd3b21b969`) * [AC-1682] Removed dropping temporary table from scripts (cherry picked from commit `eb7794d592`) * [AC-1682] Removed other temp table drops (cherry picked from commit `26768b7bf8`) * [AC-1978] Fix issue that allows the web app to have the user type Manager available (cherry picked from commit `2890f78870`) * [AC-1682] Bump dates on migration scripts --------- Co-authored-by: Thomas Rittson <31796059+eliykat@users.noreply.github.com>	2 years ago
Matt Bishop	b97a1a9ed2	[PM-5519] [PM-5526] [PM-5624] [PM-5600] More Grant SQL fixes (#3668 ) * SQLite scripts to apply autoincrementing Id key * Drop erroneous Id column if created	2 years ago