psakefile.ps1

# SPDX-License-Identifier: Apache-2.0
# Licensed to the Ed-Fi Alliance under one or more agreements.
# The Ed-Fi Alliance licenses this file to you under the Apache License, Version 2.0.
# See the LICENSE and NOTICES files in the project root for more information.

include "./psake-build-helpers.ps1"

properties {
	$configuration = "Release"
	$env = "dev"
	$projectRootDirectory = "$(resolve-path .)"
	$publish = "$projectRootDirectory/Publish"
	$productSolution = "$projectRootDirectory/src/API/LeadershipProfileAPI/LeadershipProfileAPI.sln"
	$apiProjectFile = "$projectRootDirectory/src/API/LeadershipProfileAPI/LeadershipProfileAPI.csproj"
	$apiTestProjectFile = "$projectRootDirectory/src/API/LeadershiProfileAPI.Tests/LeadershipProfileAPI.Tests.csproj"
	# $frontendAppFolder = "$projectRootDirectory/src/Web"
	$frontendAppFolder = "$projectRootDirectory/src/API/LeadershipProfileAPI/ClientApp/"
	$artifactsFolder = "$projectRootDirectory/artifacts"
	$testDatabasePassword = "yourStrong(!)Password"
	$localDatabaseContainerName = "SqlServer2019"
	$testDatabaseContainerName = "LeadershipProfileTestDb"
	$testDatabasePort = "1435"
	$dbTestDataUrl = "https://odsassets.blob.core.windows.net/public/TPDM/EdFi_Ods_Populated_Template_TPDM_10.zip"
	$dbTestdataZipFile = "EdFi_Ods_Populated_Template_TPDM_10.zip"
	$dbTestdataBakFile = "EdFi_Ods_Populated_Template_TPDM_10.bak"
	$testDataFolder = "$projectRootDirectory/testdata"
	$dbName = "EdFi_Ods_Populated_Template"
	$dbBackupName = "EdFi_Ods_Populated_Template_Test"
}

task RemovePublishFolders -description "Removes the publish related folders" {
	remove-directory-silently $publish
	remove-directory-silently $artifactsFolder
	remove-directory-silently "$frontendAppFolder/build"
}

task Publish -description "Publish the primary projects for distribution" -depends RemovePublishFolders {
	$minVersion = minver -t v
	$env:MINVERVERSIONOVERRIDE = $minVersion
	exec { dotnet publish -c $configuration "$apiProjectFile" -o $publish}
	pushd -Path $frontendAppFolder
	exec { npm install }
	exec { npm run build }
	popd
	New-Item -ItemType Directory -Force -Path "$artifactsFolder"
	Compress-Archive -Path "$publish" -Destination "$artifactsFolder/LeadershipProfile-API-$minVersion.zip"
	Compress-Archive -Path "$frontendAppFolder/build" -Destination "$artifactsFolder/LeadershipProfile-Frontend-$minVersion.zip"
}

task TestFrontend -description "Run frontend tests" {
	pushd -Path $frontendAppFolder
	exec { npm install }
	exec {npm run test -- --watchAll=false --passWithNoTests --ci }
	popd
}

task TestAPI -description "Run API tests" -depends RecreateTestDatabase, UpdateTestDatabase {
	$env:LPTEST_ConnectionStrings__EdFi = "Server=localhost,$testDatabasePort;Database=$dbName;User Id=sa;Password=$testDatabasePassword;"
	exec { dotnet test "$apiTestProjectFile" }
}

task Test -description "Runs all tests" -depends TestFrontend, TestAPI

task RemoveDbTestContainer -description "Removes the database test container" {
	if (Exist-Container($testDatabaseContainerName)) {
		exec { docker rm "$testDatabaseContainerName" -f }
	}
}

task DownloadDbTestData -description "Downloads the DB test data from blob storage" {
	if (!(Test-Path "$testDataFolder/$dbTestDataZipFile" -PathType Leaf)) {
		Write-Host "Downloading..."
		Invoke-WebRequest "$dbTestDataUrl" -OutFile "$testDataFolder/$dbTestDataZipFile"
	}

	if (!(Test-Path "$testDataFolder/$dbTestDataBakFile" -PathType Leaf)) {
		Write-Host "Unpacking..."
		Expand-Archive -Path "$testDataFolder/$dbTestDataZipFile" -DestinationPath "$testDataFolder"
	}

	Write-Host "Backup available at " -NoNewline
	Write-Host "$testDataFolder/$dbTestDataBakFile" -ForegroundColor Yellow
}

task RecreateTestDatabase -description "Starts a docker container with the test database" -depends RemoveDbTestContainer, DownloadDbTestData {
	Recreate-Docker-Db $testDatabaseContainerName $testDatabasePort $testDatabasePassword
	Restore-Docker-Db $testDatabaseContainerName $testDataFolder $dbTestDataBakFile $testDatabasePassword $dbBackupName $dbName
}

task UpdateTestDatabase -description "Runs the migration scripts on the test database" {
    $roundhouseConnString="Server=localhost,$testDatabasePort;Database=$dbName;User Id=sa;Password=$testDatabasePassword;"
	Update-Database $roundhouseConnString 'TEST'
}

task RunTestDatabase -description "Runs the docker container that has the test database" {
	exec { docker start $testDatabaseContainerName }
}

task UpdateLocalDatabase -description "Runs the migration scripts on the local database" {
	Update-Database "Server=localhost;Database=$dbName;Integrated Security=true;" $env
}

task SeedLocalDatabase -description "Seed test data into your local dev database" {
	Update-Database "Server=localhost;Database=$dbName;Integrated Security=true;" 'TEST'
}

task RecreateLocalDockerDatabase -description "Starts a docker container with the sample database for local dev" -depends DownloadDbTestData {
	Recreate-Docker-Db $localDatabaseContainerName 1433 $testDatabasePassword
	Restore-Docker-Db $localDatabaseContainerName $testDataFolder $dbTestDataBakFile $testDatabasePassword $dbBackupName $dbName
}

task RunLocalDockerDatabase -description "Runs the docker container that has the local database" {
	exec { docker start $localDatabaseContainerName }
}

task RestoreLocalDockerDatabase -description "Restores local db without deleting the container" -depends DownloadDbTestData {
	Write-Host "Restoring local database container"
	Restore-Docker-Db $localDatabaseContainerName $testDataFolder $dbTestDataBakFile $testDatabasePassword $dbBackupName $dbName
}

task UpdateLocalDockerDatabase -description "Runs the migration scripts on the local docker database" {
	$roundhouseConnString="Server=localhost;Database=$dbName;User Id=sa;Password=$testDatabasePassword;"
	Update-Database $roundhouseConnString $env
}

task SeedLocalDockerDatabase -description "Seed test data into your local dev database" {
	$roundhouseConnString="Server=localhost;Database=$dbName;User Id=sa;Password=$testDatabasePassword;"
	Update-Database $roundhouseConnString 'TEST'
}

task SetLocalDockerConnectionString -description "Sets a user secret to override the connection string for the docker db" {
	$roundhouseConnString="Server=localhost;Database=$dbName;User Id=sa;Password=$testDatabasePassword;"
	dotnet user-secrets set "ConnectionStrings:EdFi" "$roundhouseConnString" --project $apiProjectFile
}

task ResetLocalDockerDatabase -description "Recreates and updates the local docker db" -depends RecreateLocalDockerDatabase, UpdateLocalDockerDatabase, SetLocalDockerConnectionString {
}

task Clean -description "Clean back to a fresh state" -depends RemoveDbTestContainer, RemovePublishFolders {
	dotnet clean $productSolution
}