MySQL2Motte

Esta es la herramienta que genera las clases del model para las aplicaciones basadas en Motte que utilicen Mysql como motor de base de datos.

Está basado en 2(dos) archivos:

mysql2motte (generador)
mteTpl.mte (template de clase)

Puede copiar el template que viene con motte y personalizarlo para que se ajuste a sus necesidades y luego decirle a la herramienta que use el nuevo archivo de template con la opción '-t=miTemplate'

Esta herramienta reemplazará las variables('@NOMBRE') del template por los datos recabados de las tablas de la base de datos y creará una clase por cada tabla del modelo.

mysql2motte.sh

#!/bin/bash
 
# Motte MySQL2Class Generator
# PHP Class Generator based on MySQL database structure
# Authors: Pedro Gauna: pgauna@gmail.com, Carlos Gagliardi: carlosgag@gmail.com,
#          Jose Dodero: jose.dodero@gmail.com, GBoksar\/Perro: gustavo@boksar.info),
#          Pablo Erartes: pabloeuy@gmail.com,
#          LinuxTeros: http://linuxteros.codigolibre.net/mottte, INDT Sistemas: http://www.indt.hc.edu.uy
# License: GPLv2+ (http://opensource.org/licenses/gpl-license.php GNU Public license)
# Link:    http://motte.codigolibre.net
# Last update: Wed Set 12 09:09:48 UYT 2007
#
 
VERBOSE=0
INCREMENTAL=0
DBUSER=""
DBPASS=""
DBHOST=""
DBNAME=""
DBHOSTPORT=""
DBHOST=""
CLSPATH="."
TBLSTRUCT=""
TPLFILE=""
URL="LinuxTeros - http:\/\/motte.codigolibre.net/"
AUTHOR="Pedro Gauna, Carlos Gagliardi, Jose Dodero, GBoksar\/Perro, Pablo Erartes"
PACKAGE="motte_project"
 
# finish <message>
# if a message is received the program finishes
#
function finish {
	eraseTmp
	VERBOSE=1
 
	if [ "$1" == "help" ]; then
		shift
 
		message "$1" 1
		message "MySQL2Motte - Mysql database parser for automagic creation of classes"
		message "Motte v1.0 <http://motte.codigolibre.net> <http://linuxteros.codigolibre.net/proyectos/motte>\nThis program is licensed under GPLv2+(http://opensource.org/licenses/gpl-license.php GNU Public license)\n\nAuthors:\tPedro Gauna, Carlos Gagliardi, Jose Dodero, GBoksar/Perro, Pablo Erartes" 1
		message "Parameters: (order is irrelevant)\n\tOptionals:\n\t\t-v  or  --verbose\n\t\t-i  or  --autoincremental (not functional yet)\n\t\t-o=  or  --output=  <TargetDirectory>\n\t\t-t=  or  --template=  <template_file>\t(If none specified default Motte class template will be used)\n\t\t\tVariables to replaced on template:\n\t\t\t\t@AUTHOR\t\tApplication authors.\n\t\t\t\t@URL\t\tApplication URL.\n\t\t\t\t@PACKAGE\tApplication package name.\n\t\t\t\t@DATE\t\tDate/time when class was created.\n\t\t\t\t@TBLSTRUCT\tOriginal DB table structure for the class.\n\t\t\t\t@INCLUDES\tOther classes needed for foreign keys validation and default values.\n\t\t\t\t@TABLE\t\tDB table name being processed.\n\t\t\t\t@CTR\t\tControls for NOT NULL fields.\n\t\t\t\t@INICIALIZE\tDefault values for each fields.\n\t\t\t\t@SERIAL\t\tFunction to obtain auto-numeric ID form serial table.\n\t\t\t\t@CTRI\t\tIntegrity checks.\n\t\t-a=  or  --author=  <authors>*\n\t\t-l=  or  --url=  <url>*\n\t\t-k=  or  --package=  <package_name>*\n\n\t\t\t*Can't contain special chars(\\ or \") or the should be escaped like \\\\\ and \\\".\n\n\tConnection Values:\n\t\t-u=  or  --user=  <BDuser>\n\t\t-p=  or  --passwd=  <BDpass>\n\t\t-d=  or  --database=  <BDname>\n\n\tOptional Connection values:\n\t\t-h=  or  --host=  <BDhost>\n\t\t-P=  or  --port=  <BDhostport>" 1
		message "\t\t\-x=  or --export=  <file>\tExports default Motte class template to specified file. If none is specified will be exported to \"mteTpl.mte\"." 1
		message "Syntax:\t$0 [-v] [-i] -u=<user> -p=<passwd> -d=<database> [-h=<host_ip>] [-P=<host_port>] [-o=<output_directory>] [-t=<my_template_file>] [-a=<author_name>] [-u=<app_url>] [-k=<package_name>]\nor\n\t$0 -x[=<destination_file>]" 1
		message "Usage:\t$0 -v -u=myuser -p=mypass -d=testdb\n\t\tor\n\t$0 -x" 1
		if [ "$1" != "" ]; then
			exit 1
		else
			exit 0
		fi
	else
		message "$1" 1
		exit 1
	fi
}
 
 
# message <text> [1|2]
# show runtime messages if verbose option was set (-v or --verbose)
# 1- leaves an empty line after the text
# 2- leaves an empty line before and after the text
#
function message {
	if [ "$VERBOSE" == "1" ]; then
		if [ "$2" == "2"  ]; then echo ""; fi
		echo -e "$1"
		if [ "$2" == "2"  ] || [ "$2" == "1"  ]; then echo ""; fi
	fi
}
 
 
# eraseTmp [<file_pattern>]
# erase temporary files with name starting with argument received and ending with .mte.tmp
# if no argument is received, will erase all temporary files.
#
function eraseTmp {
	if [ -d ./mte_Tmp_dir ] && [ "$1" == "" ]; then
		rm -rf  ./mte_Tmp_dir
	fi
	if [ "$1" != "" ]; then
		FILE_PATTERN="_$1_*.mte.tmp"
		if [ $(ls ./mte_Tmp_dir/${FILE_PATTERN}|> | wc -w) -gt 0 ]; then
			rm ./mte_Tmp_dir/$FILE_PATTERN
		fi
	fi
}
 
#
#
#
#
function createTplFile {
 
	# ToDo Perro...
	#  >> ./mte_Tmp_dir/mteTpl.mte
        # echo not implemented yet...
	cp ./mteTpl.mte ./mte_Tmp_dir
}
 
#
#  ==============================================================================================
#
#                                 A R G U M E N T S   C H E C K
#
#  ==============================================================================================
#
 
 
 
# Check for at least 3 args received
#
if [ "$#" -lt "3" ] && [ "$#" != "1" ]; then
	finish help "Too few arguments($# of 3)..."
fi
if [ "$#" != "1" ]; then
	while [ $# -gt 0 ]; do
		value=$1
		PAR=${value%=*}
		PARVALUE=${value#*=}
 
		case "$PAR" in
			-v | --verbose)
				VERBOSE=1
				;;
			-i | --autoincremental)
				INCREMENTAL=1
				;;
			-u | --user)
				DBUSER="-u $PARVALUE"
				;;
			-p | --passwd)
				DBPASS="--password=$PARVALUE"
				;;
			-d | --database)
				DBNAME=$PARVALUE
				;;
			-h | --host)
				DBHOST="-h $PARVALUE"
				;;
			-P | --port)
				DBHOSTPORT="-P$PARVALUE"
				;;
			-o | --output)
				CLSPATH=$PARVALUE
				;;
			-h | --help)
				finish "help"
				;;
			-t | --template)
				TPLFILE="$PARVALUE"
				;;
			-k | --package)
				PACKAGE="$PARVALUE"
				;;
			-a | --author)
				AUTHOR="$PARVALUE"
				;;
			-l | --url)
				URL="$PARVALUE"
				;;
			*)
				finish help "You have specified an invalid argument!"
		esac
		shift
	done
else
	value=$1
	PAR=${value%=*}
	PARVALUE=${value#*=}
	if [ "$PAR" != "-x" ] && [ "$PAR" != "--export" ]; then
		finish help "You have specified an invalid argument!"
	fi
	if [ "$PARVALUE" == "" ] || [ "$PARVALUE" == "-x" ]; then
		TPLFILE="./mteTpl.mte"
	else
		TPLFILE="$PARVALUE"
	fi
	eraseTmp
	mkdir ./mte_Tmp_dir
	if [ "$?" -gt "0" ]; then
		finish help "You don't have writing privileges on this folder... Unable to continue!"
	fi
	createTplFile
	cp ./mte_Tmp_dir/mteTpl.mte $TPLFILE
	finish "Motte Class Template succesfully created: $TPLFILE"
fi
 
if [ "$DBUSER" == "" ] || [ "$DBNAME" == "" ]; then
	finish help "Missing DB connection info(User/Database). Unable to continue!"
fi
 
if [ "$DBPASS" == "" ]; then
	DBPASS="-p"
fi
 
if [ "$CLSPATH" != "." ]; then
	if [ ! -d "$CLSPATH" ]; then
		finish help "Specified output directory don't exist! ($CLSPATH)"
	fi
fi
 
#
# Testing temporary directory and directory privileges
#
 
eraseTmp
 
mkdir ./mte_Tmp_dir
if [ "$?" -gt "0" ]; then
	finish help "You don't have writing privileges on this folder... Unable to continue!"
fi
 
# Verify if template file exists.
#
if [ "$TPLFILE" == "" ]; then
	message "No template file specified, usig Motte default class schema..." 1
	createTplFile
	TPLFILE="./mte_Tmp_dir/mteTpl.mte"
fi
if [ ! -f $TPLFILE ]; then
	finish help "Missing template file. The file you specified cannot be found($TPLFILE). Unable to continue!"
fi
 
#
#  ==============================================================================================
#
#                         S T A R T S   D A T A B A S E   P A R S I N G
#
#  ==============================================================================================
#
 
# Create temporary file with database tables
mysql -N $DBUSER $DBPASS $DBHOST $DBHOSTPORT $DBNAME --execute="SHOW TABLES">./mte_Tmp_dir/_tmp_tables.mte.tmp
if [ "$?" -gt "0" ]; then
	finish "Errors trying to connect with server\nUsing: $DBUSER $DBPASS $DBHOST $DBHOSTPORT $DBNAME"
fi
 
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
#        GENERATES TMP FILE FOR STRUCTURE - MUST BE DONE BEFORE PROCESSING TABLE CONTENTS
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
message "Creating temporary files..."
 
for TABLE in $(cat ./mte_Tmp_dir/_tmp_tables.mte.tmp); do
	# Create temporary files for Motte(php) code for eache class
	touch ./mte_Tmp_dir/_${TABLE}|>_INI.mte.tmp
	touch ./mte_Tmp_dir/_${TABLE}|>_INI_COM.mte.tmp
	touch ./mte_Tmp_dir/_${TABLE}|>_INCLUDE.mte.tmp
	touch ./mte_Tmp_dir/_${TABLE}|>_CTR.mte.tmp
	touch ./mte_Tmp_dir/_${TABLE}|>_CTRI.mte.tmp
	touch ./mte_Tmp_dir/_${TABLE}|>_SERIAL.mte.tmp
	touch ./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp
done
 
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
#             GENERATES CLASS CONTENT BASED ON TABLE STRUCTURE
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
message "Obtaining table structure from server..."
 
for TABLE in $(cat ./mte_Tmp_dir/_tmp_tables.mte.tmp); do
 
	if [ -f ${CLSPATH}|>/${TABLE}|>.model.php ]; then
		CLASS_CUSTOMIZED=$(echo $(grep @Customized ${CLSPATH}|>/${TABLE}|>.model.php | cut -f3 -d' '))
	else
		CLASS_CUSTOMIZED="false"
	fi
 
	if [ "$CLASS_CUSTOMIZED" == "false" ]; then
        # create temporary files based on table structure
 
		message "   Reading table structure for (${TABLE}) from server..."
 
		mysql -N $DBUSER $DBPASS $DBHOST $DBHOSTPORT $DBNAME --execute="DESCRIBE ${TABLE}" | sed s/"\t"/":"/g > ./mte_Tmp_dir/_tmp_fields.mte.tmp
		if [ "$?" -gt "0" ]; then
			finish "Error when trying to connect to DB\nUsing: $DBUSER $DBPASS $DBHOST $DBHOSTPORT $DBNAME"
		fi
 
		message "      Processing fields from table: ${TABLE}"
 
		TBLSTRUCT="\n*\tTable Structure: ${TABLE}\n*\n";
 
		for LINE in $(cat ./mte_Tmp_dir/_tmp_fields.mte.tmp); do
 
			# Get field name
			FIELD=$(echo "${LINE}"|cut -d: -f1)
 
			# Get field type
			TIPO=$(echo "${LINE}"|cut -d: -f2|cut -d'(' -f1)
 
			# Set 1 if field is table Primary key (Should be named as table with "_id" sufix)
			FIELD_KEY=0
			if [ "${FIELD}" == "${TABLE}_id" ]; then
				FIELD_KEY=1
			fi
 
			# Set 1 if field is required (NOT NULL/YES)
			FIELD_CTR=0
			if [ "$(echo ${LINE}|cut -d: -f3)" != "YES" ]; then
				FIELD_CTR=1
			fi
 
			# Getting default value from table structure
			FIELD_DEFAULT=$(echo "${LINE}"|cut -d: -f5)
 
			# Set 1 if Field is a foreign key (Foreing keys should be named as referenced table name and "_id" sufix)
			FIELD_FK=0
			FIELD_FK_ID=$(echo ${FIELD}|>|cut -d_ --fields=1-$(expr $(echo ${FIELD}|>|sed "s/_/\n/g"|wc -l) - 1))
			FIELD_FK_TABLE=$(echo ${FIELD_FK_ID}|>|cut -d_ --fields=1-$(expr $(echo ${FIELD_FK_ID}|>|sed "s/_/\n/g"|wc -l) - 1))
 
			if [ "$(echo ${FIELD}|grep _id|wc -w)" == "1" ] && [ "${FIELD_FK_TABLE}" != "${TABLE}" ]; then
				FIELD_FK=1
			fi
 
			# Generating Motte(php) code based on field type and expected behavior
			if [ "${FIELD_KEY}" == "1" ]; then
				# Auto_incremental / Uses a "serial" table for autonumeric values on InnoDB
			   	echo "include_once(MTE_MODEL.'\/serial.model.php');\n">>./mte_Tmp_dir/_${TABLE}|>_INCLUDE.mte.tmp
				echo "\n\t\t\/\/ Load autoincremental value\n\t\tif (\$this->countErrorExec() == 0){\n\t\t\t\/\/ Ask for autoincremental value\n\t\t\t\$tblSerial = new tbl_serial(\$this->getEngine());\n\t\t\t\$record['${FIELD}'] = \$tblSerial->getNextValue('${FIELD}');\n\t\t}\n">>./mte_Tmp_dir/_${TABLE}|>_SERIAL.mte.tmp
			else
				if [ "${FIELD_FK}" == "1" ]; then
					# Add include_once based on foreign fields
					echo "include_once(MTE_MODEL.'\/$(echo ${FIELD}|cut -d_ -f1).model.php');\t\/\/ Foreign field\n">>./mte_Tmp_dir/_${TABLE}|>_INCLUDE.mte.tmp
 
					# Initialize foreign fields with corresponding table default value
					echo "\n\t\t\/\/ Initialize foreign fields ${FIELD}\n\t\t\$tbl${FIELD_FK_TABLE} = new tbl_${FIELD_FK_TABLE}(\$this->getEngine());\n\t\t\$record['${FIELD}'] = \$tbl$tbl${FIELD_FK_TABLE}->getDafaultId();\n\n">>./mte_Tmp_dir/_${TABLE}|>_INI.mte.tmp
 
					# Record check for needed values (NOT NULL Fields)
					echo "\n\t\t\/\/ ${FIELD}\n\t\t\$tbl${FIELD_FK_TABLE} = new tbl_${FIELD_FK_TABLE}(\$this->getEngine());\n\t\tif (!\$tbl${FIELD_FK_TABLE}->exists(\"${FIELD_FK_ID}_id='\".\$record['${FIELD}'].\"'\"))\n\t\t\t\$this->addErrorExec(\$this->_i18n('No data could be found for field').' ${FIELD} ');\n">>./mte_Tmp_dir/_${TABLE}|>_CTR.mte.tmp
 
					# Integrity check control for record deletion based on foreign key on other tables
					echo "\n\t\t\/\/ Integrity for ${TABLE}\n\t\t\$tbl${TABLE} = new tbl_${TABLE}(\$this->getEngine());\n\t\t if (\$tbl${TABLE}->exists(\"${FIELD}='\".\$record['${FIELD}'].\"'\"))\n\t\t\t\$this->addErrorExec(\$tbl${TABLE}->getTableComment());\n">>./mte_Tmp_dir/_${FIELD_FK_TABLE}|>_CTRI.mte.tmp
 
					# Add include_once for tables used at Integrity check on record deletion.
					echo "include_once(MTE_MODEL.'\/${TABLE}.model.php');\t\/\/ Integrity Check\n">>./mte_Tmp_dir/_${FIELD_FK_TABLE}|>_INCLUDE.mte.tmp
 
				else
					# Inicializing class attributes with default values
					if [ "${FIELD_DEFAULT}" != "" ] && [ "${FIELD_DEFAULT}" != "NULL" ]; then
						VALUE="\"$(echo ${FIELD_DEFAULT} | sed "s/\\//\\\\\//g" )\"";
					else
						case "$(echo ${TIPO} | tr 'A-Z' 'a-z' )" in
							numeric | bit | int | decimal | tinyint | smallint | mediumint | integer | bigint | real | double | float | decimal)
								VALUE='0'
								;;
							varchar | char | text | tinytext | mediumtext | longtext)
								VALUE='\"\"'
								;;
							date)
								VALUE="date('Y-m-d')"
								;;
							time)
								VALUE="date('H:i:s')"
								;;
							year)
								VALUE="date('Y')"
								;;
 
							datetime | timestamp)
								VALUE="date('Y-m-d H:i:s')"
								;;
						esac
					fi
 
					echo "${FIELD}=${VALUE}">>./mte_Tmp_dir/_${TABLE}|>_INI_COM.mte.tmp
 
					# Control de datos
					VALUE=''
					if [ "${FIELD_CTR}" == "1" ]; then
						COMMON_FIELD="\n\t\t\/\/ ${FIELD}\n\t\tif ("
						COMMON_FIELD2="\$record['${FIELD}'] == '')\n\t\t\t\$this->addErrorExec(\$this->_i18n('Field').' "
						# based on field type
						case "$(echo ${TIPO} | tr 'A-Z' 'a-z' )" in
							int)
								VALUE="$COMMON_FIELD !is_int($COMMON_FIELD2 ${FIELD} '.\$this->_i18n('must receive an integer value.'));"
								;;
	                                                decimal)
								VALUE="$COMMON_FIELD !is_float($COMMON_FIELD2 ${FIELD}  '.\$this->_i18n('must receive a numeric value.'));"
								;;
							varchar | char)
								VALUE="$COMMON_FIELD $COMMON_FIELD2 ${FIELD} '.\$this->_i18n('cannot be empty.'));"
								;;
						esac
						echo "${VALUE}">>./mte_Tmp_dir/_${TABLE}|>_CTR.mte.tmp
					fi
				fi
			fi
 
			message "         Field ${LINE}..."
		done
 
		# Var assignment alingment
		if [ "$(cat ./mte_Tmp_dir/_${TABLE}_INI_COM.mte.tmp | wc -l)" -gt "0" ]; then
			echo "\n\t\t\/\/ Initialize others fields\n">>./mte_Tmp_dir/_${TABLE}|>_INI.mte.tmp
 
			# Max length
			MAX_LENGTH=0
			for LINE in $(cat ./mte_Tmp_dir/_${TABLE}|>_INI_COM.mte.tmp); do
				LINE_LENGTH=$(echo ${LINE}|> | cut -d= -f1 | wc -m)
				if [ ${LINE_LENGTH}|> -gt ${MAX_LENGTH}|> ]; then
					MAX_LENGTH=${LINE_LENGTH}|>
				fi
			done
			MAX_LENGTH=$(expr ${MAX_LENGTH}|> + 1)
 
			for LINE in $(cat ./mte_Tmp_dir/_${TABLE}|>_INI_COM.mte.tmp); do
				LINE_LENGTH=$(echo ${LINE}|> | cut -d= -f1 | wc -m)
				BEFORE="\t\t\$record['$(echo ${LINE} | cut -d= -f1)']"
				AFTER="$(echo ${LINE} | cut -d= -f2);\n"
				SPACES=$(echo '################################' | cut -c 1-$(expr ${MAX_LENGTH}|> - ${LINE_LENGTH}|>))
				echo "${BEFORE}${SPACES}= ${AFTER}"|sed s/'#'/'\\ '/g>>./mte_Tmp_dir/_${TABLE}|>_INI.mte.tmp
			done
		fi
 
		# Add comment line for Class
		MAX_LENGTH='0:0:0:0:0:0'
		echo "field:type:null:key:default:extra">./mte_Tmp_dir/_tmp_fieldsc.mte.tmp
		cat ./mte_Tmp_dir/_tmp_fields.mte.tmp>>./mte_Tmp_dir/_tmp_fieldsc.mte.tmp
		for LINE in $(cat ./mte_Tmp_dir/_tmp_fieldsc.mte.tmp); do
			COUNTER=1
			LENAUX=''
			while [  $COUNTER -lt 7 ]; do
				# Maximo actual
				MAX_LENGTH_AUX=$(echo ${MAX_LENGTH}|> | cut -d: -f${COUNTER}|>)
				declare -i MAX_LENGTH_AUX
				LINE_LENGTH=$(echo ${LINE}|> | cut -d: -f${COUNTER}|> | wc -m)
				LINE_LENGTH=$(expr ${LINE_LENGTH}|> + 1)
				if [ ${LINE_LENGTH}|> -gt ${MAX_LENGTH_AUX}|> ]; then
					LENAUX=${LENAUX}|>${LINE_LENGTH}|>':'
				else
					LENAUX=${LENAUX}|>${MAX_LENGTH_AUX}|>':'
				fi
				COUNTER=$(expr ${COUNTER}|> + 1)
			done
			MAX_LENGTH=${LENAUX}|>
		done
 
 
		echo "\n*\tTable structure: ${TABLE}\n*\n">>./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp
		HEADER=''
		COUNTER=1
	        while [  $COUNTER -lt 7 ]; do
			MAX_LENGTH_AUX=$(echo ${MAX_LENGTH}|> | cut -d: -f${COUNTER}|>)
			SPACES=$(echo '----------------------------------------------------------------------------' | cut -c 1-${MAX_LENGTH_AUX}|>)
			HEADER="${HEADER}${SPACES}+"
			COUNTER=$(expr ${COUNTER}|> + 1)
		done
 
		echo "*\t+${HEADER}\n">>./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp
		LINE_NBR=1
		for LINE in $(cat ./mte_Tmp_dir/_tmp_fieldsc.mte.tmp); do
			COUNTER=1
			AUX='#'
	        	while [  $COUNTER -lt 7 ]; do
				LINE_LENGTH=$(echo ${LINE}|> | cut -d: -f${COUNTER}|> | wc -m)
				MAX_LENGTH_AUX=$(echo ${MAX_LENGTH}|> | cut -d: -f${COUNTER}|>)
				BEFORE=$(echo ${LINE}|> | cut -d: -f${COUNTER}|>)
				SPACES=$(echo '#################################################' | cut -c 1-$(expr ${MAX_LENGTH_AUX}|> - ${LINE_LENGTH}|>))
				AUX=${AUX}|>${BEFORE}|>${SPACES}|>"|#"
				COUNTER=$(expr ${COUNTER}|> + 1)
			done
			echo "*\t|${AUX}\n" | sed s/'#'/'\\ '/g | sed -r s/'\/'/'\\\/'/g >>./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp
			if [ "${LINE_NBR}" == "1" ]; then
				echo "*\t+${HEADER}\n">>./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp
			fi
			LINE_NBR=$(expr ${LINE_NBR}|> + 1)
		done
		echo "*\t+${HEADER}">>./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp
	else
		message "   Ignoring table (${TABLE}) because \"CUSTOMIZED\" tag is set to TRUE..."
	fi
done
 
 
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
#              GENERATES MOTTE(php) CLASS AND REPLACE TEMPLATE VARIABLES WITH GENERATED CONTENT
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
message "DB Structure scan completed. Generating Motte Classes..." 2
 
for TABLE in $(cat ./mte_Tmp_dir/_tmp_tables.mte.tmp); do
 
        if [ -f ${CLSPATH}|>/${TABLE}|>.model.php ]; then
                CLASS_CUSTOMIZED=$(echo $(grep @Customized ${CLSPATH}|>/${TABLE}|>.model.php | cut -f3 -d' '))
        else
                CLASS_CUSTOMIZED="false"
        fi
 
	if [ "$CLASS_CUSTOMIZED" == "false" ]; then
		message "   Motte Class: ${TABLE}.model.php"
 
		INI=$(cat ./mte_Tmp_dir/_${TABLE}|>_INI.mte.tmp)
		CTR=$(cat ./mte_Tmp_dir/_${TABLE}|>_CTR.mte.tmp)
		INCLUDE=$(cat ./mte_Tmp_dir/_${TABLE}|>_INCLUDE.mte.tmp | uniq)
		SERIAL=$(cat ./mte_Tmp_dir/_${TABLE}|>_SERIAL.mte.tmp)
		CTRI=$(cat ./mte_Tmp_dir/_${TABLE}|>_CTRI.mte.tmp)
		TBLSTRUCT=$(cat ./mte_Tmp_dir/_${TABLE}|>_TBLSTRUCT.mte.tmp)
 
	        sed -e "s/@DATE/$(date)/g" \
		    -e "s/@TABLE/$(echo ${TABLE})/g" \
		    -e "s/@INICIALIZE/$(echo ${INI})/g" \
		    -e "s/@SERIAL/$(echo ${SERIAL})/g" \
		    -e "s/@CTRI/$(echo ${CTRI})/g" \
		    -e "s/@CTR/$(echo ${CTR})/g" \
		    -e "s/@INCLUDES/$(echo ${INCLUDE})/g" \
		    -e "s/@TBLSTRUCT/$(echo $TBLSTRUCT)/g" \
		        $TPLFILE > ./mte_Tmp_dir/${TABLE}|>.model.tmp
 
		cat ./mte_Tmp_dir/${TABLE}|>.model.tmp |sed -r s/^[' ']//g> $CLSPATH/${TABLE}|>.model.php
	else
	        message "   Ignoring table (${TABLE}) because \"CUSTOMIZED\" tag is set to TRUE..."
	fi
done
 
message "Erasing temporary files..."
 
# Erasing tmp files
eraseTmp
 
message "Task finished." 1
exit 0

mteTpl.mte

<?php
/**
* @filesource
* @author Sistemas INDT / Pablo Erartes (pabloeuy@gmail.com) / Gustavo Boksar (gustavo@boksar.info)
* @url http://decreto.indt.edu.uy
* @package Decreto_160_006
* @subpackage model
* @version 2.0
* @license http://opensource.org/licenses/gpl-license.php GNU Public license (GPLv2+)
*
* Ultima actualizacion: @DATE
*
* @Customized false
*
*@TBLSTRUCT
*
*/
 
/**
 *  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 *                       I N C L U D E S
 *  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 */
@INCLUDES
 
/**
* Clase para manejar Tabla tbl_@TABLE
*
*/
class tbl_@TABLE extends mteTableSql{
	/**
	 * Table Comment
	 *
	 * @var string
	 * @access private
	 */
	private $_tableComment;
 
	/**
	 * Constructor
	 *
	 * @param mteCnxMySql $engine
	 * @access public
	 * @return tbl_@TABLE
	 */
	public function __construct($engine) {
		// Invoking parent constructor
		parent::__construct('@TABLE',$engine);
		$this->setTableComment("@TABLE"); // Replace this value for a more user-friendly description
	}
 
	/**
	* Destructor
	*
	* @access public
	*/
	public function __destruct(){
	}
 
	/**
	 *  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	 *                   C L A S S   M E T H O D S
	 *  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	 */
 
	/**
	* Set table comment
	*
	* @access public
	* @param string $comment
	*/
	public function setTableComment($comment){
		$this->_tableComment = $comment;
	}
 
	/**
	* Get table comment
	*
	* @access public
	* @return string
	*/
	public function getTableComment(){
		return $this->_tableComment;
	}
 
	/**
	 * Checking record and fields values
	 *
	 * @access private
	 * @param array $record
	 */
	private function _ctrRecord($record){
		@CTR
	}
 
	/**
	 * Returns default Id
	 *
	 * @access public
	 * @param array $record
	 */
	public function getDafaultId(){
		return 0;
	}
 
	/**
	 * Create select
	 *
	 * @access public
	 * @param string $fieldName
	 * @param string $where
	 * @param string $order
	 * @return array
	 */
	public function createSelect($fieldName, $where = '', $order = ''){
		$result = array();
 
		return $result;
	}
 
	/**
	 * Returns select data
	 *
	 * @access public
	 * @param string $where
	 * @param string $order
	 * @return array
	 */
	public function getSelectData($where = '', $order = ''){
		$result = array();
 
		return $result;
	}
 
	/**
	 *  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	 *             M O T T E   E V E N T S   H A N D L I N G
	 *  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	 */
 
	/**
	 * When new record is created
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function onNewRecord(&$record){
		// Inicialize Error management
		$this->clearErrorExec();
		@INICIALIZE
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('while initializing data in').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
 
	/**
	 * Things to do before inserting record to DB
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function beforeInsert(&$record){
		// Inicialize error management
		$this->clearErrorExec();
 
		// Data control
		$this->_ctrRecord($record);
		@SERIAL
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('when inserting new record in').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
 
	/**
	 * After inserting a record to DB
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function afterInsert(&$record){
		// Inicialize error management
		$this->clearErrorExec();
 
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('after inserting new record in').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
	/**
	 * Before updating a record
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function beforeUpdate(&$record){
		// Inicialize error management
		$this->clearErrorExec();
 
		// Data control
		$error = $this->_ctrRecord($record);
 
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('when updating record data of').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
	/**
	 * After updating a record
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function afterUpdate(&$record){
		// Inicialize error management
		$this->clearErrorExec();
 
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('after updating record data of').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
 
	/**
	 * Before deleting a record
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function beforeDelete(&$record){
		// Inicialize error management
		$this->clearErrorExec();
		@CTRI
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('when deleting a record of').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
 
	/**
	 * After deleting a record
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function afterDelete(&$record){
		// Inicialize error management
		$this->clearErrorExec();
 
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('after deleting a record of').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
 
	/**
	 * Calculated fields
	 *
	 * @access public
	 * @param array $record
	 * @return string
	 */
	public function onCalcFields(&$record){
		// Inicialize error management
		$this->clearErrorExec();
 
		// Returns
		return $this->parseErrorExec($this->getLiteralError().$this->i18n('on generating calculated fields for').' '.$this->getTableComment().":", $this->i18n('Please verify'),"\n");
	}
}
?>