<?php

/*
FileArts
Copyright (C) 2007 Peter Goodman, Geoffrey Goodman

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
of the License, 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., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

class FARelation {}

class FAManyToManyRelation extends FARelation {
	function FAManyToManyRelation(&$left, &$middle, &$right) {
		$this->_left = &$left;
		$this->_middle = &$middle;
		$this->_right = &$right;
	}
	
	function &createQuery($id) {
		$left_key = $this->_middle->getForeignKey($this->_left->getName());
		
		$middle_table = $this->_middle->getTable();
		$middle_key = $this->_middle->getForeignKey($this->_right->getName());
		
		$right_table = $this->_right->getTable();
		$right_pk = $this->_right->getPrimaryKey();
		
		$select = "r.*";
		$from = "$middle_table as m, $right_table as r";
		$where = "m.$left_key=? AND m.$middle_key=r.$right_pk";
		
		$query = &new FAQuery($select, $from, $where);
		$query->bind(1, $id);
		
		return $query;
	}
}

// The left table has the foreign key
class FALeftRelation extends FARelation {
	function FALeftRelation(&$left, &$right) {
		$this->_left = &$left;
		$this->_right = &$right;
	}
	
	function &createQuery($id) {
		$left_table = $this->_left->getTable();
		$left_key = $this->_left->getForeignKey($this->_left->getName());
		$left_pk = $this->_left->getPrimaryKey();
		
		$right_table = $this->_right->getTable();
		$right_pk = $this->_right->getPrimaryKey();
		
		$select = "r.*";
		$from = "$left_table as l, $right_table as r";
		$where = "l.$left_key=r.$right_pk AND l.$left_pk=?";
		
		$query = &new FAQuery($select, $from, $where);
		$query->bind(1, $id);
		
		return $query;
	}
}

// The right table has the foreign key
class FAOneToManyRelation extends FARelation {
	function FAOneToManyRelation(&$left, &$right) {
		$this->_left = &$left;
		$this->_right = &$right;
	}
	
	function &createQuery($id) {
		$right_table = $this->_right->getTable();
		$right_key = $this->_right->getForeignKey($this->_left->getName());
		
		$select = "r.*";
		$from = "$right_table as r";
		$where = "r.$right_key=?";
		
		$query = &new FAQuery($select, $from, $where);
		$query->bind($id);
		
		return $query;
	}
}

?>