Changeset 1695 for lliurex-sgdb/trunk/fuentes

Timestamp:

May 26, 2016, 12:13:49 PM (5 years ago)

Author:

jrpelegrina

Message:

Add a function to change sql_mode

Location:

lliurex-sgdb/trunk/fuentes

Files:

• debian/changelog (modified) (1 diff)
• install/usr/sbin/lliurex-sgbd (modified) (5 diffs)

lliurex-sgdb/trunk/fuentes/debian/changelog

@@ +1 @@
+lliurex-sgbd (0.71-lliurex3) xenial; urgency=medium
+
+  * Add a function to change sql_mode
+
+ -- Juan Ramon Pelegrina <juapesai@hotmail.com>  Thu, 26 May 2016 11:58:30 +0200
+
 lliurex-sgbd (0.71-lliurex2) xenial; urgency=medium
 

lliurex-sgdb/trunk/fuentes/install/usr/sbin/lliurex-sgbd

@@ -19 +19 @@
 # --add_include_file -> create include file
 # --db_is_present -> check if database exists
+# --sql_mode -> change sql_mode variable to correct perfomance
 ###########################################################
 
@@ -34 +35 @@
 
 debug=0
+NOW=$(date +"%Y.%m.%d.%H.%M")
 
 read_config_file(){
@@ -147 +149 @@
                 mkdir -p $BACKUP_PATH
         fi
-        NOW=$(date +"%Y.%m.%d.%H.%M")   
+        #NOW=$(date +"%Y.%m.%d.%H.%M")  
         echo "Doing database backup: $BACKUP_PATH/backup.$NOW.sql"
         mysqldump -u root -p$MYSQL_ROOT_PASS $DB_NAME > $BACKUP_PATH"/backup."$NOW".sql" 2>/dev/null
@@ -229 +231 @@
 }
 
+edit_sql_mode(){
+        MYSQLCNF_PATH="/etc/mysql/mysql.cnf"
+        MYSQLCNF_DIR=$(dirname ${MYSQLCNF_PATH})
+        SQLCONFIG_NEW='sql_mode="NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"'
+
+    if [ -f ${MYSQLCNF_PATH}  ]; then
+        SQLCONFIG_OLD=$(sed -e '/sql_mode'/!d ${MYSQLCNF_PATH})
+       
+        if [ -z ${SQLCONFIG_OLD} ]; then
+
+                echo "Doing backup of file ${MYSQLCNF_PATH}"
+                cp ${MYSQLCNF_PATH} ${MYSQLCNF_DIR}"/mysql_"${NOW}".cnf"
+                echo "Adding sql_mode in file ${MYSQLCNF_PATH}"
+                sed -i '$a'${SQLCONFIG_NEW} ${MYSQLCNF_PATH}
+            systemctl restart mysql 
+        else
+                if [[ ${SQLCONFIG_OLD} == ${SQLCONFIG_NEW} ]]; then
+
+                        echo "NOTHING TO DO. File ${MYSQLCNF_PATH} already update"
+                else
+                        echo "Doing backup of file ${MYSQLCNF_PATH}"
+                        cp ${MYSQLCNF_PATH} ${MYSQLCNF_DIR}"/mysql_"${NOW}".cnf"
+                        echo "Adding new sql_mode configuration in file ${MYSQLCNF_PATH}"
+                        sed -i 's/'${SQLCONFIG_OLD}'/'${SQLCONFIG_NEW}'/g' ${MYSQLCNF_PATH}
+                        systemctl restart mysql
+                fi              
+        fi
+    else
+        echo "NOTHING TO DO. File ${MYSQLCNF_PATH} NOT FOUND"   
+    fi  
+}
+
 usage (){
-        echo "usage:  lliurex-sgbd --config package_name | --template package_name | --install package_name  | --upgrade package_name | --remove package_name | --purge package_name | --inject_sql package_name sql_file_with_path | --db_is_present package_name | --add_include_file package_name | --is_include_present package_name "
+        echo "usage:  lliurex-sgbd --config package_name | --template package_name | --install package_name  | --upgrade package_name | --remove package_name | --purge package_name | --inject_sql package_name sql_file_with_path | --db_is_present package_name | --add_include_file package_name | --is_include_present package_name | --sql_mode package_name"
 }
 
@@ -330 +364 @@
         ;;
 
+        --sql_mode)
+                edit_sql_mode
+        ;;      
+
         *)
                 usage