279 |
{ |
{ |
280 |
create_database_schema |
create_database_schema |
281 |
|
|
282 |
# update database version |
# update database schema version |
283 |
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version" |
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_schema_version_${i}) ]] |
if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]] |
303 |
then |
then |
306 |
fi |
fi |
307 |
done |
done |
308 |
|
|
309 |
# update database version |
# update database schema version |
310 |
mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta(version) VALUES ('${MCORE_SQL_DB_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VERSION}';" || die "updating version" |
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 |
} |
} |
330 |
|
|
331 |
case $1 in |
case $1 in |