From f8bee13c2caaa769d55d14931809f8d092c9318b Mon Sep 17 00:00:00 2001 From: xue <> Date: Sat, 24 Dec 2005 23:13:56 +0000 Subject: --- demos/personal/protected/Data/application.xml | 31 ------ demos/personal/protected/Modules/DataModule.php | 120 ------------------------ 2 files changed, 151 deletions(-) delete mode 100644 demos/personal/protected/Data/application.xml delete mode 100644 demos/personal/protected/Modules/DataModule.php (limited to 'demos') diff --git a/demos/personal/protected/Data/application.xml b/demos/personal/protected/Data/application.xml deleted file mode 100644 index d0403a50..00000000 --- a/demos/personal/protected/Data/application.xml +++ /dev/null @@ -1,31 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?> - -<application> - <paths> - <alias id="Application" path=".." /> - </paths> - <!-- modules configured and loaded for all services --> - <modules> - <!-- make sure the path "protected" is writable by web server process if you enable this cache - <module id="cache" class="System.Data.TSqliteCache" DbFile="Application.Data.Cache"/> - --> - <module id="session" class="THttpSession" /> - </modules> - <services> - <!-- page service, BasePath is required --> - <service id="page" BasePath="Application.Pages" DefaultPage="home"> - <!-- modules configured and loaded when page service is requested --> - <modules> - <!-- user manager module --> - <module id="users" class="System.Security.TUserManager" PasswordMode="Clear"> - <user name="demo" password="demo" /> - </module> - <!-- auth manager module --> - <module id="auth" class="System.Security.TAuthManager" UserManager="users" LoginPage="login" /> - <!-- - <module id="data" class="Application.Modules.DataModule" DbFile="Application.Data.Site" /> - --> - </modules> - </service> - </services> -</application> \ No newline at end of file diff --git a/demos/personal/protected/Modules/DataModule.php b/demos/personal/protected/Modules/DataModule.php deleted file mode 100644 index 114e0f33..00000000 --- a/demos/personal/protected/Modules/DataModule.php +++ /dev/null @@ -1,120 +0,0 @@ -<?php - -class DataModule extends TComponent implements IModule -{ - /** - * extension of the db file name - */ - const DB_FILE_EXT='.db'; - const DB_SCHEMA=' - CREATE TABLE tblBlogs (id INTEGER PRIMARY KEY, title VARCHAR(256), content TEXT, lastupdate INTEGER, author VARCHAR(64)); - CREATE TABLE tblComments (id INTEGER PRIMARY KEY, bid INTEGER, content TEXT, lastupdate INTEGER, author VARCHAR(64), email VARCHAR(64), option INTEGER); - '; - /** - * @var string id of this module - */ - private $_id=''; - private $_file=null; - /** - * @var SQLiteDatabase the sqlite database instance - */ - private $_db=null; - private $_initialized=false; - - /** - * Destructor. - * Disconnect the db connection. - */ - public function __destruct() - { - $this->_db=null; - parent::__destruct(); - } - - /** - * Initializes this module. - * This method is required by the IModule interface. It checks if the DbFile - * property is set, and creates a SQLiteDatabase instance for it. - * If the database or the tables do not exist, they will be created. - * @param TApplication Prado application, can be null - * @param TXmlElement configuration for this module, can be null - * @throws TConfigurationException DbFile is set invalid - */ - public function init($application,$config) - { - if(!function_exists('sqlite_open')) - throw new TConfigurationException('SQLite extension required.'); - if($this->_file===null) - throw new TConfigurationException('SQLite db file required.'); - if(($fname=Prado::getPathOfNamespace($this->_file,self::DB_FILE_EXT))===null) - throw new TConfigurationException('SQLite db file invalid: '.$this->_file); - $error=''; - if(($this->_db=new SQLiteDatabase($fname,0666,$error))===false) - throw new TConfigurationException('SQLite db connection failed: ',$error); - $res=$this->_db->query('SELECT * FROM sqlite_master WHERE tbl_name=\'tblBlogs\' AND type=\'table\''); - if($res===false || $res->numRows()===0 && $this->_db->query(self::DB_SCHEMA)===false) - throw new TConfigurationException('SQLite db table creation failed: '.sqlite_error_string(sqlite_last_error())); - $this->_initialized=true; - } - - /** - * @return string id of this module - */ - public function getID() - { - return $this->_id; - } - - /** - * @param string id of this module - */ - public function setID($value) - { - $this->_id=$value; - } - - /** - * @return string database file path (in namespace form) - */ - public function getDbFile() - { - return $this->_file; - } - - /** - * @param string database file path (in namespace form) - * @throws TInvalidOperationException if the module is already initialized - */ - public function setDbFile($value) - { - if($this->_initialized) - throw new TInvalidOperationException('DbFile cannot be modified after the module is initialized.'); - else - $this->_file=$value; - } - - public function getBlogsByTime($time) - { - } -} - -class Blog -{ - public $id; - public $title; - public $author; - public $content; - public $lastupdate; - public $comments; -} - -class Comment -{ - public $id; - public $bid; - public $author; - public $content; - public $lastupdate; -} - -?> \ No newline at end of file -- cgit v1.2.3