From 3f0149b5b74d4017ba7f4ca28aa8a3e2053db964 Mon Sep 17 00:00:00 2001
From: "Christophe.Boulain" <>
Date: Mon, 15 Jun 2009 07:49:42 +0000
Subject: Primilary import of new db stuff

---
 framework/Db/schema/sqlite/TSqliteSchema.php | 134 +++++++++++++++++++++++++++
 1 file changed, 134 insertions(+)
 create mode 100755 framework/Db/schema/sqlite/TSqliteSchema.php

(limited to 'framework/Db/schema/sqlite/TSqliteSchema.php')

diff --git a/framework/Db/schema/sqlite/TSqliteSchema.php b/framework/Db/schema/sqlite/TSqliteSchema.php
new file mode 100755
index 00000000..1c6ba78f
--- /dev/null
+++ b/framework/Db/schema/sqlite/TSqliteSchema.php
@@ -0,0 +1,134 @@
+<?php
+/**
+ * TSqliteSchema class file.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2009 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+prado::using('System.db.schema.TDbSchema');
+prado::using('System.db.schema.TDbTableSchema');
+prado::using('System.db.schema.sqlite.TSqliteColumnSchema');
+prado::using('System.db.schema.sqlite.TSqliteCommandBuilder');
+
+/**
+ * TSqliteSchema is the class for retrieving metadata information from a SQLite (2/3) database.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @version $Id$
+ * @package system.db.schema.sqlite
+ * @since 1.0
+ */
+class TSqliteSchema extends TDbSchema
+{
+	/**
+	 * Returns all table names in the database.
+	 * @param string the schema of the tables. This is not used for sqlite database.
+	 * @return array all table names in the database.
+	 * @since 1.0.2
+	 */
+	protected function findTableNames($schema='')
+	{
+		$sql="SELECT DISTINCT tbl_name FROM sqlite_master WHERE tbl_name<>'sqlite_sequence'";
+		return $this->getDbConnection()->createCommand($sql)->queryColumn();
+	}
+
+	/**
+	 * Creates a command builder for the database.
+	 * @return TSqliteCommandBuilder command builder instance
+	 */
+	protected function createCommandBuilder()
+	{
+		return new TSqliteCommandBuilder($this);
+	}
+
+	/**
+	 * Creates a table instance representing the metadata for the named table.
+	 * @return TDbTableSchema driver dependent table metadata. Null if the table does not exist.
+	 */
+	protected function createTable($name)
+	{
+		$db=$this->getDbConnection();
+
+		$table=new TDbTableSchema;
+		$table->name=$name;
+		$table->rawName=$this->quoteTableName($name);
+
+		if($this->findColumns($table))
+		{
+			$this->findConstraints($table);
+			return $table;
+		}
+		else
+			return null;
+	}
+
+	/**
+	 * Collects the table column metadata.
+	 * @param TDbTableSchema the table metadata
+	 * @return boolean whether the table exists in the database
+	 */
+	protected function findColumns($table)
+	{
+		$sql="PRAGMA table_info({$table->rawName})";
+		$columns=$this->getDbConnection()->createCommand($sql)->queryAll();
+		if(empty($columns))
+			return false;
+
+		foreach($columns as $column)
+		{
+			$c=$this->createColumn($column);
+			$table->columns[$c->name]=$c;
+			if($c->isPrimaryKey)
+			{
+				if($table->primaryKey===null)
+					$table->primaryKey=$c->name;
+				else if(is_string($table->primaryKey))
+					$table->primaryKey=array($table->primaryKey,$c->name);
+				else
+					$table->primaryKey[]=$c->name;
+			}
+		}
+		if(is_string($table->primaryKey) && !strncasecmp($table->columns[$table->primaryKey]->dbType,'int',3))
+			$table->sequenceName='';
+
+		return true;
+	}
+
+	/**
+	 * Collects the foreign key column details for the given table.
+	 * @param TDbTableSchema the table metadata
+	 */
+	protected function findConstraints($table)
+	{
+		$foreignKeys=array();
+		$sql="PRAGMA foreign_key_list({$table->rawName})";
+		$keys=$this->getDbConnection()->createCommand($sql)->queryAll();
+		foreach($keys as $key)
+		{
+			$column=$table->columns[$key['from']];
+			$column->isForeignKey=true;
+			$foreignKeys[$key['from']]=array($key['table'],$key['to']);
+		}
+		$table->foreignKeys=$foreignKeys;
+	}
+
+	/**
+	 * Creates a table column.
+	 * @param array column metadata
+	 * @return TDbColumnSchema normalized column metadata
+	 */
+	protected function createColumn($column)
+	{
+		$c=new TSqliteColumnSchema;
+		$c->name=$column['name'];
+		$c->rawName=$this->quoteColumnName($c->name);
+		$c->allowNull=!$column['notnull'];
+		$c->isPrimaryKey=$column['pk']!=0;
+		$c->isForeignKey=false;
+		$c->init(strtolower($column['type']),$column['dflt_value']);
+		return $c;
+	}
+}
-- 
cgit v1.2.3