--- a/busui/owa/modules/base/classes/column.php +++ b/busui/owa/modules/base/classes/column.php @@ -1,1 +1,198 @@ - +<?php + +// +// Open Web Analytics - An Open Source Web Analytics Framework +// +// Copyright 2006 Peter Adams. All rights reserved. +// +// Licensed under GPL v2.0 http://www.gnu.org/copyleft/gpl.html +// +// Unless required by applicable law or agreed to in writing, software +// distributed under the License is distributed on an "AS IS" BASIS, +// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +// See the License for the specific language governing permissions and +// limitations under the License. +// +// $Id$ +// + +/** + * Database Column Object + * + * @author Peter Adams <peter@openwebanalytics.com> + * @copyright Copyright © 2006 Peter Adams <peter@openwebanalytics.com> + * @license http://www.gnu.org/copyleft/gpl.html GPL v2.0 + * @category owa + * @package owa + * @version $Revision$ + * @since owa 1.0.0 + */ + +class owa_dbColumn { + + var $name; + + var $value; + + var $data_type; + + var $foriegn_key; + + var $is_primary_key = false; + + var $auto_increment = false; + + var $is_unique = false; + + var $is_not_null = false; + + var $label; + + var $index; + + var $default_value; + + function __construct($name ='', $data_type = '') { + + if ($name) { + $this->setName($name); + } + + if ($data_type) { + $this->setDataType($data_type); + } + + } + + function get($name) { + + return $this->$name; + } + + function set($name, $value) { + + $this->$name = $value; + + return; + } + + function getValue() { + + return $this->value; + } + + function setValue($value) { + + $this->value = $value; + + return; + } + + function getDefinition() { + + $definition = ''; + + $definition .= $this->get('data_type'); + + // Check for auto increment + if ($this->get('auto_increment') == true): + $definition .= ' '.OWA_DTD_AUTO_INCREMENT; + endif; + + // Check for auto Not null + if ($this->get('is_not_null') == true): + $definition .= ' '.OWA_DTD_NOT_NULL; + endif; + + // Check for unique + if ($this->get('is_unique') == true): + $definition .= ' '.OWA_DTD_UNIQUE; + endif; + + // check for primary key + if ($this->get('is_primary_key') == true): + $definition .= ' '.OWA_DTD_PRIMARY_KEY; + //$definition .= sprintf(", INDEX (%s)", $this->get('name')); + endif; + + // check for index + if ($this->get('index') == true): + $definition .= sprintf(", INDEX (%s)", $this->get('name')); + endif; + + return $definition; + + } + + function setDataType($type) { + + $this->data_type = $type; + } + + function setDefaultValue($value) { + + $this->default_value = $value; + } + + function setPrimaryKey() { + + $this->is_primary_key = true; + } + + function setIndex() { + + $this->index = true; + } + + function setNotNull() { + + $this->is_not_null = true; + } + + function setUnique() { + + $this->is_unique = true; + } + + function setLabel($label) { + + $this->label = $label; + } + + function setForeignKey($entity, $column = 'id') { + + $this->foreign_key = array($entity, $column); + } + + function getForeignKey() { + + return $this->foreign_key; + } + + function isForeignKey() { + + if (!empty($this->foreign_key)) { + return true; + } else { + return false; + } + } + + function setAutoIncrement() { + + $this->auto_increment = true; + } + + function setName($name) { + + $this->name = $name; + } + + function getName() { + + return $this->name; + } + + } + +?>