e2e-1.ps1

Set-StrictMode -Version 2.0
$ErrorActionPreference = 'stop'

# Taken from psake https://github.com/psake/psake
<#
.SYNOPSIS
  This is a helper function that runs a scriptblock and checks the PS variable $lastexitcode
  to see if an error occcured. If an error is detected then an exception is thrown.
  This function allows you to run command-line programs without having to
  explicitly check the $lastexitcode variable.
.EXAMPLE
  exec { svn info $repository_trunk } "Error executing SVN. Please verify SVN command-line client is installed"
#>
function Exec
{
    [CmdletBinding()]
    param(
        [Parameter(Position=0,Mandatory=1)][scriptblock]$cmd,
        [Parameter(Position=1,Mandatory=0)][string]$errorMessage = ("Error executing command {0}" -f $cmd)
    )
    Write-Output "$ $cmd"
    & $cmd
    if ($lastexitcode -ne 0) {
        throw ("Exec: (${LastExitCode}) ${ErrorMessage}")
    }
}


$TEST_GPKG=(Join-Path $PSScriptRoot '..\data\e2e.gpkg')
Write-Output "Test data is at: ${TEST_GPKG}"

$TMP_GUID=([string] [System.Guid]::NewGuid())
$TMP_PATH=(New-Item -ItemType Directory -Path (Join-Path ([System.IO.Path]::GetTempPath()) "sno-e2e.${TMP_GUID}"))
Write-Output "Using temp folder: ${TMP_PATH}"

$SNO_PATH=(Get-Command sno).source
If ((Get-Item $SNO_PATH).Directory.Name -eq 'Scripts') {
    # Virtualenv
    $SNO_PREFIX=(Get-Item (Get-Command sno).source).Directory.Parent.FullName
} Else {
    # Installation
    $SNO_PREFIX=(Get-Item (Get-Command sno).source).DirectoryName
}
Write-Output "Sno is at: ${SNO_PATH} (Prefix: ${SNO_PREFIX})"

# Spatialite / SQLite
$SPATIALITE=("${SNO_PREFIX}\mod_spatialite" -replace '\\', '/').ToLower()
$SQLITE=(Join-Path $SNO_PREFIX 'sqlite3.exe')

New-Item -ItemType Directory -Path "${TMP_PATH}\test"
Push-Location "${TMP_PATH}\test"
try {
    Exec { sno init . }
    Exec { sno -v config --local 'user.name' 'Sno E2E Test 1' }
    Exec { sno -v config --local 'user.email' 'sno-e2e-test-1@email.invalid' }
    Exec { sno -v config --local 'core.pager' false }
    Exec { sno import "GPKG:${TEST_GPKG}" "--table=mylayer" }

    Exec { sno log }
    Exec { sno checkout }
    Exec { sno switch -c 'edit-1' }
    Write-Output "$  <updating working copy> sqlite3"
    & $SQLITE -bail -echo test.gpkg "
      SELECT load_extension('$SPATIALITE');
      SELECT EnableGpkgMode();
      INSERT INTO mylayer (fid, geom) VALUES (999, GeomFromEWKT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
      SELECT COUNT(*) FROM mylayer;
    "
    if (! $?) {
        throw ("sqlite3: $LastExitCode")
    }

    Exec { sno status }
    Exec { sno diff }
    Exec { sno commit -m 'my-commit' }
    Exec { sno switch 'master' }
    Exec { sno status }
    Exec { sno merge 'edit-1' --no-ff }
    Exec { sno log }
}
catch {
    Write-Output ">>> E2E Error: $($PSItem.ToString())"
}
finally {
    Pop-Location
    Remove-Item -Force -Recurse "$TMP_PATH"
}

Write-Output ">>> E2E Success"