From 3972774a2ebf82b3bae2dacef7f8aa1aae279096 Mon Sep 17 00:00:00 2001 From: Côme BERNIGAUD Date: Thu, 1 Sep 2011 15:58:47 +0200 Subject: Removed db4app and test_db --- lib/db4app.php | 117 --------------------------------------------------------- 1 file changed, 117 deletions(-) delete mode 100644 lib/db4app.php (limited to 'lib') diff --git a/lib/db4app.php b/lib/db4app.php deleted file mode 100644 index 1200652fada..00000000000 --- a/lib/db4app.php +++ /dev/null @@ -1,117 +0,0 @@ -. - * - */ - -require_once('base.php'); - -/** - * This class manages the access to the database from apps. It basically is a wrapper for - * OC_DB. It allows that apps doesn't contains SQL code. - */ -class OC_DB4App { - /** - * @brief Store an object in the database - * @param $appname Name of the application - * @param $table Name of the database table - * @param $userid Id of owner of the object - * @param $object Object to save in the database - * @returns id of the object in the database - * - */ - static public function store($appname,$tablename,$userid,$object) { - $table = $appname."_".$tablename; - if(OC_DB::connect()) { - $CONFIG_DBTYPE = OC_Config::getValue( "dbtype", "sqlite" ); - if( $CONFIG_DBTYPE == 'sqlite' or $CONFIG_DBTYPE == 'sqlite3' ){ - $idline = "id INTEGER PRIMARY KEY AUTOINCREMENT"; - } else { - $idline = "id int NOT NULL AUTO_INCREMENT"; - } - $query = "CREATE TABLE IF NOT EXISTS *PREFIX*$table ($idline,uid int REFERENCES user(id),object text)"; - OC_DB::query($query); - $query = "INSERT INTO *PREFIX*$table (uid,object) VALUES ('$userid','".OC_DB::escape(base64_encode(serialize($object)))."')"; - OC_DB::query($query); - return OC_DB::insertid(); - } else { - die ("could not connect to database"); - } - } - - /** - * @brief Get an object from the database - * @param $appname Name of the application - * @param $table Name of the database table - * @param $objectid Id of the object - * @returns the object - * - */ - static public function get_object($appname,$tablename,$objectid) { - $table = $appname."_".$tablename; - if(OC_DB::connect()) { - $query = "SELECT object FROM *PREFIX*$table WHERE id='".OC_DB::escape($objectid)."'"; - $q = OC_DB::prepare($query); - $result = $q->execute()->fetchOne(); - return unserialize(base64_decode($result)); - } else { - die ("could not connect to database"); - } - - } - - static public function get_objects($appname,$tablename,$userid) { - $table = $appname."_".$tablename; - if(OC_DB::connect()) { - $query = "SELECT id FROM *PREFIX*$table WHERE uid='".OC_DB::escape($userid)."'"; - $q = OC_DB::prepare($query); - $result = $q->execute()->fetchAll(); - return $result; - } else { - die ("could not connect to database"); - } - } - - static public function delete_object($appname,$tablename,$objectid) { - $table = $appname."_".$tablename; - if(OC_DB::connect()) { - $query = "DELETE FROM *PREFIX*$table WHERE id='".OC_DB::escape($objectid)."'"; - $q = OC_DB::prepare($query); - $q->execute(); - return true; - } else { - die ("could not connect to database"); - } - - } - - static public function drop($appname,$tablename) { - $table = $appname."_".$tablename; - if(OC_DB::connect()) { - $query = "DROP TABLE *PREFIX*$table"; - $q = OC_DB::prepare($query); - $q->execute(); - return true; - } else { - die ("could not connect to database"); - } - - } -} -?> -- cgit v1.2.3