This is an old revision of the document!

---

Git Hooks

pre-commit Hook

pre-commit

#!/bin/sh
 
# LOCATION: MagentoRoot/app/etc/local.xml
mageConfig='../../var/www/clients/web/app/etc/local.xml'
 
# USE MAGNTOs ROOT DIRECTORY
sqlStorage='/root/hook/mysql_structure.sql'
 
# WARNING: cat IS CALLED FOR EACH VARIABLE - TODO: IMPROVE LOGIC/SYNTAX
host=$(cat ${mageConfig} | sed -n '/<connection>/,/<\/connection>/p' | sed -n -e 's/.*<host>\(.*\)<\/host>.*/\1/p' | sed -n -e 's/.*CDATA\[\(.*\)\]\].*/\1/p')
username=$(cat ${mageConfig} | sed -n '/<connection>/,/<\/connection>/p' | sed -n -e 's/.*<username>\(.*\)<\/username>.*/\1/p' | sed -n -e 's/.*CDATA\[\(.*\)\]\].*/\1/p')
password=$(cat ${mageConfig} | sed -n '/<connection>/,/<\/connection>/p' | sed -n -e 's/.*<password>\(.*\)<\/password>.*/\1/p' | sed -n -e 's/.*CDATA\[\(.*\)\]\].*/\1/p')
dbname=$(cat ${mageConfig} | sed -n '/<connection>/,/<\/connection>/p' | sed -n -e 's/.*<dbname>\(.*\)<\/dbname>.*/\1/p' | sed -n -e 's/.*CDATA\[\(.*\)\]\].*/\1/p')
 
echo ''
echo '--> Tagwork<one>: EXPORT SQL STRUCTURE <--'
echo $host
echo $username
echo $password
echo $dbname
echo '--> END Tagwork<one>: EXPORT SQL STRUCTURE <--'
echo ''
 
# EXPORT SQL STRUCTURE
mysqldump -d -h $host -u $username -p$password $dbname > $sqlStorage