%echo off

rem Usage: setParameter.bat <parameter> <type> <value>
rem type: 1=integer, 2=float, 3=varchar

if "%~1"=="" goto usage 
if "%~2"=="" goto usage 
if "%~3"=="" goto usage 

if %2==1 goto integer
if %2==2 goto float
if %2==3 goto varchar
goto error

:integer
echo update integer_values set value='%3' where id=(select id from integer_values where id=(select value_id from token_value where token='%1')); > %temp%\afile.sql
echo select value from integer_values where id=(select value_id from token_value where token='%1'); >> %temp%\afile.sql
rem echo pragma busy_timeout=20000; select value from integer_values where id=(select value_id from token_value where token='%1'); >> %temp%\afile.sql
goto run

:float
echo update float_values set value='%3' where id=(select id from float_values where id=(select value_id from token_value where token='%1')); > %temp%\afile.sql
echo select value from float_values where id=(select value_id from token_value where token='%1'); >> %temp%\afile.sql
rem echo pragma busy_timeout=20000; select value from float_values where id=(select value_id from token_value where token='%1'); >> %temp%\afile.sql

goto run

:varchar
echo  update varchar_values set value='%3' where id=(select id from varchar_values where id=(select value_id from token_value where token='%1')); > %temp%\afile.sql
echo select value from varchar_values where id=(select value_id from token_value where token='%1'); >> %temp%\afile.sql
rem echo pragma busy_timeout=20000; select value from varchar_values where id=(select value_id from token_value where token='%1'); >> %temp%\afile.sql
goto run

:error
echo error
goto end

:usage
echo "Usage: setParameter.bat <parameter> <type> <value>"
echo type: 1=integer, 2=float, 3=varchar
goto end

:run

echo .timeout 2000 > %temp%\init.sql

set DBEXE=.
"%DBEXE%\sqlite3.exe" -init %temp%\init.sql "%KSISDB%" < %temp%\afile.sql		
del %temp%\afile.sql

:end