90 |
|
|
91 |
for ((i=1; i<count; i++)) |
for ((i=1; i<count; i++)) |
92 |
do |
do |
93 |
line="${TABLE_DEFINITION[${i}]}" |
line=( ${TABLE_DEFINITION[${i}]} ) |
94 |
column="${line%% *}" |
column="${line[0]}" |
95 |
opts="${line/${column} /}" |
opts="${line[*]:1}" |
96 |
|
|
97 |
case ${opts} in |
case ${opts} in |
98 |
*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;; |
*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;; |
123 |
fi |
fi |
124 |
} |
} |
125 |
|
|
126 |
|
# TABLE_DEFINITION=( |
127 |
|
# "table_name" |
128 |
|
# "column1_name after_column column1_argvs" |
129 |
|
# "column2_name after_column column2_argvs" |
130 |
|
# "columnN_name after_column columnN_argvs" |
131 |
|
# ) |
132 |
|
sql_add_column() |
133 |
|
{ |
134 |
|
local table |
135 |
|
local count |
136 |
|
local i |
137 |
|
local line |
138 |
|
local opts |
139 |
|
local column |
140 |
|
local autoincrement |
141 |
|
local primary |
142 |
|
|
143 |
|
table="${TABLE_DEFINITION[0]}" |
144 |
|
count="${#TABLE_DEFINITION[*]}" |
145 |
|
|
146 |
|
for ((i=1; i<count; i++)) |
147 |
|
do |
148 |
|
line=( ${TABLE_DEFINITION[${i}]} ) |
149 |
|
column="${line[0]}" |
150 |
|
after="${line[1]}" |
151 |
|
opts="${line[*]:2}" |
152 |
|
|
153 |
|
case ${opts} in |
154 |
|
*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;; |
155 |
|
*"primary key"*) opts="${opts//primary key}"; primary="${column}" ;; |
156 |
|
esac |
157 |
|
|
158 |
|
case ${opts} in |
159 |
|
*AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;; |
160 |
|
*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;; |
161 |
|
esac |
162 |
|
|
163 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts}) AFTER ${after_column};" || die "add column '${table}'" |
164 |
|
done |
165 |
|
|
166 |
|
if [[ -n ${primary} ]] |
167 |
|
then |
168 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'" |
169 |
|
fi |
170 |
|
if [[ -n ${autoincrement} ]] |
171 |
|
then |
172 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'" |
173 |
|
fi |
174 |
|
} |
175 |
|
|
176 |
|
# TABLE_DEFINITION=( |
177 |
|
# "table_name" |
178 |
|
# "column1_name column1_argvs" |
179 |
|
# "column2_name column2_argvs" |
180 |
|
# "columnN_name columnN_argvs" |
181 |
|
# ) |
182 |
|
sql_modify_column() |
183 |
|
{ |
184 |
|
local table |
185 |
|
local count |
186 |
|
local i |
187 |
|
local line |
188 |
|
local opts |
189 |
|
local column |
190 |
|
local autoincrement |
191 |
|
local primary |
192 |
|
|
193 |
|
table="${TABLE_DEFINITION[0]}" |
194 |
|
count="${#TABLE_DEFINITION[*]}" |
195 |
|
|
196 |
|
for ((i=1; i<count; i++)) |
197 |
|
do |
198 |
|
line=( ${TABLE_DEFINITION[${i}]} ) |
199 |
|
column="${line[0]}" |
200 |
|
opts="${line[*]:1}" |
201 |
|
|
202 |
|
case ${opts} in |
203 |
|
*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;; |
204 |
|
*"primary key"*) opts="${opts//primary key}"; primary="${column}" ;; |
205 |
|
esac |
206 |
|
|
207 |
|
case ${opts} in |
208 |
|
*AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;; |
209 |
|
*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;; |
210 |
|
esac |
211 |
|
|
212 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts});" || die "modify table '${table}'" |
213 |
|
done |
214 |
|
|
215 |
|
if [[ -n ${primary} ]] |
216 |
|
then |
217 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'" |
218 |
|
fi |
219 |
|
if [[ -n ${autoincrement} ]] |
220 |
|
then |
221 |
|
mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'" |
222 |
|
fi |
223 |
|
} |
224 |
|
|
225 |
# VALUE_DEFINITION=( |
# VALUE_DEFINITION=( |
226 |
# "table_name, value_column_name, bool_column_name, id_column_name" |
# "table_name, value_column_name, bool_column_name, id_column_name" |
227 |
# "value1, bool1" |
# "value1, bool1" |
278 |
create_database() |
create_database() |
279 |
{ |
{ |
280 |
create_database_schema |
create_database_schema |
281 |
|
|
282 |
|
# update database schema version |
283 |
|
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_schema(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating schema version" |
284 |
} |
} |
285 |
|
|
286 |
update_database() |
update_database() |
287 |
{ |
{ |
288 |
local current_sql_db_version |
local current_sql_db_schema_version |
289 |
local i |
local i |
290 |
|
|
291 |
current_sql_db_version=$(mysqldo "SELECT MAX(version) from meta;") |
current_sql_db_schema_version=$(mysqldo "SELECT MAX(version) from meta_schema;") |
292 |
|
|
293 |
if [[ ${current_sql_db_version} = ${MCORE_SQL_DB_VERSION} ]] |
if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]] |
294 |
then |
then |
295 |
echo "Database is already up to date" |
echo "Database is already up to date" |
296 |
return 0 |
return 0 |
297 |
fi |
fi |
298 |
|
|
299 |
# run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_VERSION |
# run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_SCHEMA_VERSION |
300 |
for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_VERSION}) |
for i in $(seq $((${current_sql_db_schema_version}+1)) ${MCORE_SQL_DB_SCHEMA_VERSION}) |
301 |
do |
do |
302 |
if [[ -n $(typeset -f update_to_database_version_${i}) ]] |
if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]] |
303 |
then |
then |
304 |
echo "Running update_to_database_schema_version_${i}()" |
echo "Running update_to_database_schema_version_${i}()" |
305 |
update_to_database_schema_version_${i} |
update_to_database_schema_version_${i} || die |
306 |
fi |
fi |
307 |
done |
done |
308 |
|
|
309 |
|
# update database schema version |
310 |
|
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_schema(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating schema version" |
311 |
} |
} |
312 |
|
|
313 |
fill_database() |
fill_database() |
314 |
{ |
{ |
315 |
|
local current_sql_db_values_version |
316 |
|
local i |
317 |
|
|
318 |
|
current_sql_db_values_version=$(mysqldo "SELECT MAX(version) from meta_values;") |
319 |
|
|
320 |
|
if [[ ${current_sql_db_values_version} = ${MCORE_SQL_DB_VALUES_VERSION} ]] |
321 |
|
then |
322 |
|
echo "Database values are already up to date" |
323 |
|
return 0 |
324 |
|
fi |
325 |
|
|
326 |
create_database_values |
create_database_values |
327 |
|
# update database values version |
328 |
|
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_values(version) VALUES ('${MCORE_SQL_DB_VALUES_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VALUES_VERSION}';" || die "updating values version" |
329 |
|
fi |
330 |
} |
} |
331 |
|
|
332 |
case $1 in |
case $1 in |