diff options
| author | xue <> | 2005-11-16 18:44:00 +0000 |
|---|---|---|
| committer | xue <> | 2005-11-16 18:44:00 +0000 |
| commit | e496a122dc31ca318ea5fe56ed1d8c231fd14b53 (patch) | |
| tree | e6dd75645cef1f17a79718553b8a48c128c9b9e5 /demos/personal | |
| parent | 28f69400fcb8ee74a2ea4bbf81afa00c1e6d5263 (diff) | |
Diffstat (limited to 'demos/personal')
| -rw-r--r-- | demos/personal/protected/data1/DataModule.php | 120 |
1 files changed, 120 insertions, 0 deletions
diff --git a/demos/personal/protected/data1/DataModule.php b/demos/personal/protected/data1/DataModule.php new file mode 100644 index 00000000..03ee3496 --- /dev/null +++ b/demos/personal/protected/data1/DataModule.php @@ -0,0 +1,120 @@ +<?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='Application.data.site';
+ /**
+ * @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 IApplication 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 |