1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
|
@rem Copyright (C) from 2009 to Present EPAM Systems.
@rem
@rem This file is part of Indigo toolkit.
@rem
@rem Licensed under the Apache License, Version 2.0 (the "License");
@rem you may not use this file except in compliance with the License.
@rem You may obtain a copy of the License at
@rem
@rem http://www.apache.org/licenses/LICENSE-2.0
@rem
@rem Unless required by applicable law or agreed to in writing, software
@rem distributed under the License is distributed on an "AS IS" BASIS,
@rem WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
@rem See the License for the specific language governing permissions and
@rem limitations under the License.
@echo off
set dbaname=
set dbapass=
set database=
set bingoname=bingo
set bingopass=B!ngoB!ngo
set y=
set server=
if exist bingo_saved_params.bat call bingo_saved_params.bat
goto L2
:L1
shift
:L2
if "%1" == "" goto L3
if "%1" == "-dbaname" goto got_dbaname
if "%1" == "-dbapass" goto got_dbapass
if "%1" == "-database" goto got_database
if "%1" == "-bingoname" goto got_bingoname
if "%1" == "-bingopass" goto got_bingopass
if "%1" == "-server" goto got_server
if "%1" == "-y" goto got_y
if "%1" == "-help" goto usage
if "%1" == "-?" goto usage
if "%1" == "/?" goto usage
goto badparam
:got_dbaname
shift
set dbaname=%1
goto L1
:got_dbapass
shift
set dbapass=%1
goto L1
:got_database
shift
set database=%1
goto L1
:got_server
shift
set server=%1
goto L1
:got_bingoname
shift
set bingoname=%1
goto L1
:got_bingopass
shift
set bingopass=%1
goto L1
:got_y
set y=1
goto L1
:badparam
echo Unknown parameter: %1
goto end
:L3
if "%database%" == "" goto no_database
if "%dbaname%" == "" goto no_dbaname
:L5
goto confirm
:no_database
echo Database not specified (use -database)
goto end
:no_dbaname
if "%dbapass%" == "" goto L5
echo DBA password specfied without a DBA name (use -dbaname)
goto end
:confirm
rem Save existing parameters
echo set dbaname=%dbaname%>> bingo_saved_params.bat
echo set dbapass=%dbapass%>> bingo_saved_params.bat
echo set database=%database%>> bingo_saved_params.bat
echo set server=%server%>> bingo_saved_params.bat
echo set bingoname=%bingoname%>> bingo_saved_params.bat
echo set bingopass=%bingopass%>> bingo_saved_params.bat
if not "%dbaname%" == "" echo DBA name : %dbaname%
if not "%dbapass%" == "" echo DBA password : %dbapass%
if not "%server%" == "" echo Server : %server%
echo Database : %database%
echo Bingo name : %bingoname%
echo Bingo password : %bingopass%
if "%y%"=="1" goto L4
set /p proceed=Proceed (y/N)?
if "%proceed%"=="y" goto L4
if "%proceed%"=="Y" goto L4
echo Aborting
goto end
:L4
rem Execute sql stripts
set bingo_sqlcmd_arguments=-vbingo=%bingoname% -vbingo_pass=%bingopass% -b -vdatabase=%database% -vbingo_assembly_path="%CD%\assembly\bingo-sqlserver" -e
if not "%dbaname%" == "" set bingo_sqlcmd_arguments=%bingo_sqlcmd_arguments% -U %dbaname%
if not "%dbapass%" == "" set bingo_sqlcmd_arguments=%bingo_sqlcmd_arguments% -P %dbapass%
if not "%server%" == "" set bingo_sqlcmd_arguments=%bingo_sqlcmd_arguments% -S %server%
sqlcmd -i bingo_create.sql %bingo_sqlcmd_arguments%
goto end
:usage
echo Usage: bingo-sqlserver-install.bat [parameters]
echo Parameters:
echo -?, -help
echo Print this help message
echo -server name
echo SQL Server name (default is local SQL Server)
echo -database database (obligatory)
echo Database to install on.
echo -dbaname name
echo Database administrator login (default is current user).
echo -dbapass password
echo Database administrator password.
echo If the password is not specified, you will have to enter it later.
echo -bingoname name
echo Name of cartridge pseudo-user (default "bingo").
echo -bingopass password
echo Password of the pseudo-user (default "bingo").
echo -y
echo Do not ask for confirmation.
goto end
:end
set dbaname=
set dbapass=
set instance=
set bingoname=
set bingopass=
set database=
set y=
set bingo_sqlcmd_arguments=
set server=
|
