uarJZqER

1@ECHO OFF
2
3REM Release testing for Windows. Covers basic cases.
4REM Akiban needs to be manually installed
5SETLOCAL
6
7SET INSTALLER=%1
8IF NOT DEFINED INSTALLER (
9    ECHO "Usage: %0 [akiban-installer.exe]"
10    GOTO:EOF
11)
12
13REM Semi-automated installation process
14IF EXIST "C:\Program Files\Akiban\bin" (
15    ECHO Found an existing Akiban installation. Uninstalling...
16    FOR %%f IN ("C:\Program Files\Akiban\unins*.exe") DO (
17    	%%f /VERYSILENT
18    )
19)
20IF ERRORLEVEL 1 GOTO:EOF
21
22ECHO Stopping Akiban Server...
23taskkill /f /im javaw.exe
24
25ECHO Installing Akiban using %1...
26"%INSTALLER%" /VERYSILENT
27IF ERRORLEVEL 1 GOTO:EOF
28
29ECHO Sleeping until the installer starts Akiban...
30timeout 15
31
32CALL:sqlCmd "DROP SCHEMA IF EXISTS test CASCADE"
33ECHO Testing basic inserts...
34CALL:sqlCmd "CREATE SCHEMA test"
35IF ERRORLEVEL 1 GOTO :EOF
36CALL:sqlCmd "CREATE TABLE test.customers(id INT, name VARCHAR(255))"
37IF ERRORLEVEL 1 GOTO :EOF
38CALL:sqlCmd "INSERT INTO test.customers (id, name) VALUES (1, 'foo'), (2, 'bar')"
39IF ERRORLEVEL 1 GOTO :EOF
40
41ECHO Testing akdump...
42SET AKDUMP_PATH="C:\Program Files\Akiban\bin\akdump.cmd"
43%AKDUMP_PATH%
44IF ERRORLEVEL 1 GOTO :EOF
45
46ENDLOCAL
47:EOF
48
49:sqlCmd
50psql -h localhost -p 15432 -c "%~1"
51GOTO:EOF