deploy.ps1

# Enter the first Resource Group name (i.e. openhack1)
$resourceGroup1Name = "openhack1"
# Enter the second Resource Group name (i.e. openhack2)
$resourceGroup2Name = "openhack2"
# Enter the location for the first resource group (i.e. westus2)
$location1 = "westus2"
# Enter the location for the second resource group (i.e. eastus)
$location2 = "eastus"
# Enter the SQL Server username (i.e. openhackadmin)
$sqlAdministratorLogin = "openhackadmin"
# Enter the SQL Server password (i.e. Password123)
$sqlAdministratorLoginPassword = "Password123"

$suffix = -join ((48..57) + (97..122) | Get-Random -Count 13 | % {[char]$_})
$suffix2 = -join ((48..57) + (97..122) | Get-Random -Count 13 | % {[char]$_})
$databaseName = "Movies"
$sqlserverName = "openhacksql-$suffix"

New-AzResourceGroup -Name $resourceGroup1Name -Location $location1
New-AzResourceGroup -Name $resourceGroup2Name -Location $location2

$templateUri = "https://raw.githubusercontent.com/solliancenet/nosql-openhack/master/azuredeploy.json"

$outputs = New-AzResourceGroupDeployment `
    -ResourceGroupName $resourceGroup1Name `
    -TemplateUri $templateUri `
    -secondResourceGroup $resourcegroup2Name `
    -secondLocation $location2 `
    -sqlserverName $sqlserverName `
    -sqlAdministratorLogin $sqlAdministratorLogin `
    -sqlAdministratorLoginPassword $(ConvertTo-SecureString -String $sqlAdministratorLoginPassword -AsPlainText -Force) `
    -suffix $suffix `
    -suffix2 $suffix2

#$sqlSvrFqdn = $outputs.Outputs["sqlSvrFqdn"].value
#$sqlserverName = $outputs.Outputs["sqlserverName"].value

$importRequest = New-AzSqlDatabaseImport -ResourceGroupName $resourceGroup1Name `
    -ServerName $sqlserverName -DatabaseName $databaseName `
    -DatabaseMaxSizeBytes "2147483648" `
    -StorageKeyType "SharedAccessKey" `
    -StorageKey "?sp=rl&st=2019-11-26T21:16:46Z&se=2025-11-27T21:36:00Z&sv=2019-02-02&sr=b&sig=P15nBXR2bD2jBnHX92%2BwWRxMnvTeUl3EdBNhLXnZ95s%3D" `
    -StorageUri "https://databricksdemostore.blob.core.windows.net/data/nosql-openhack/movies.bacpac" `
    -Edition "Basic" -ServiceObjectiveName "Basic" `
    -AdministratorLogin $sqlAdministratorLogin `
    -AdministratorLoginPassword $(ConvertTo-SecureString -String $sqlAdministratorLoginPassword -AsPlainText -Force)

$importStatus = Get-AzSqlDatabaseImportExportStatus -OperationStatusLink $importRequest.OperationStatusLink

[Console]::Write("Importing database")
while ($importStatus.Status -eq "InProgress") {
    $importStatus = Get-AzSqlDatabaseImportExportStatus -OperationStatusLink $importRequest.OperationStatusLink
    [Console]::Write(".")
    Start-Sleep -s 10
}

[Console]::WriteLine("")
$importStatus

$webUrl = "https://openhackweb-" + $suffix + ".azurewebsites.net"
[Console]::WriteLine("Checking Website Availability")
$availabilityResult = Invoke-WebRequest $webUrl

if($availabilityResult.StatusCode -eq 200) {
    Write-Output ("Website is available")
}
else {
    Write-Output("Website availability check failed for team: " + $teamName)
}