3 function db_getDB($changer_name)
5 global $BASE_DATA, $BASE_LIB, $BACULA_USER;
8 $dbobject = new PDO("sqlite:$BASE_DATA/$changer_name".".db");
9 } catch(PDOException $exep) {
10 echo "<font color='red'>Cannot open sqlitedb, ".$exep->getMessage()."</font><br>";
15 db_createDB($dbobject);
20 function db_createDB($dbobject)
23 if($dbobject->query("select * from disk_list")) {
24 //error_log("table exists?");
26 //error_log("table not exists?");
27 $dbobject->query('CREATE TABLE "disk_list" ("disk_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"disk_name" TEXT NOT NULL);');
28 $dbobject->query('CREATE TABLE sqlite_sequence(name,seq)');
29 $dbobject->query('CREATE TABLE "config" ("config_name" TEXT NOT NULL,"config_value" TEXT NOT NULL)');
30 $dbobject->query('CREATE TABLE "slots" ("slots_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"slot_no" INTEGER,"disk_id" INTEGER,"tape_name" TEXT)');
32 // TODO create action group here
37 function conf_getVal($changer, $name)
39 $db = db_getDB($changer);
41 $sql = "select config_value from config where config_name=='$name'";
42 //error_log("from getval: ".$sql);
44 $res = $db->query($sql);
46 if(!$res) return false;
50 foreach($res as $row) {
51 $val = $row["config_value"];
57 function conf_setVal($changer, $name, $value)
59 $db = db_getDB($changer);
61 $sql = "delete from config where config_name=='$name'";
64 $sql = "insert into config values ('$name', '$value')";
67 //error_log("from setval: ".$sql);
70 function add_diskToDB($changer, $diskid)
72 $db = db_getDB($changer);
74 $sql = "select * from disk_list where disk_name=='$diskid'";
75 $res = $db->query($sql);
76 if(!$res) return false;
79 foreach($res as $row) {
80 $val = $row["disk_id"];
84 $sql = "insert into disk_list values(NULL, '$diskid')";
86 return $db->lastInsertId();
88 echo "Disk already existed in db, will create more tapes?\n";