<?php
# $Id$
# http://www.mapbender.org/index.php/class_database_table_constraint.php
# Copyright (C) 2002 CCGIS 
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

//
// TODO
// this version implements foreign key constraints only!
//
//

class database_table_constraint{
	/*
	* Class variables:
	*/
	var $conSymbol;		
	var $conColumn;
	var $conTableName;
	var $conTableColumnName;
	var $conOnDelete; 
	var $conOnUpdate; 
	
	
	
	function database_table_constraint($conSymbol, $conColumn, $conTableName, $conTableColumnName, $conOnDelete, $conOnUpdate) {
		#$this->conSymbol = $conSymbol;		
		$this->conSymbol = "";		
		$this->conColumn = trim($conColumn);
		$this->conTableName = trim($conTableName);
		$this->conTableColumnName = trim($conTableColumnName);
		$this->conOnDelete = trim($conOnDelete); 
		$this->conOnUpdate = trim($conOnUpdate); 
	}
	
	function getConstraint() {
		return array(conSymbol => $this->conSymbol, conColumn => $this->conColumn, conTableName => $this->conTableName, conTableColumnName => $this->conTableColumnName, conOnDelete => $this->conOnDelete, conOnUpdate => $this->conOnUpdate);
	}
	
	function getName() {
		return $this->conSymbol;
	}
	
	function getColumn() {
		return $this->conColumn;
	}
	
	function getTableName() {
		return $this->conTableName;
	}
	
	function getTableColumnName() {
		return $this->conTableColumnName;
	}
	
	function getOnDelete() {
		return $this->conOnDelete;
	}
	
	function getOnUpdate() {
		return $this->conOnUpdate;
	}
	
	function getMysql() {
		$sql = "";
		$sql .= " CONSTRAINT";
		if ($this->getName()) {
			$sql .= " " . $this->getName();
		}
		$sql .= " FOREIGN KEY";
		$sql .= " (" . $this->getColumn() . ")";
		$sql .= " REFERENCES";
		$sql .= " " . $this->getTableName() . " (" . $this->getTableColumnName() . ")";
		
		if ($this->getOnDelete()) {
			$sql .= " ON DELETE " . $this->getOnDelete();
		}
		if ($this->getOnUpdate()) {
			$sql .= " ON UPDATE " . $this->getOnUpdate();
		}
		$sql .= "\n\n";
		return $sql;
	}
	
	function destroyConstraint () {
		settype(&$this, 'null');
	}
}

?>