X-Git-Url: http://git.pjr.cc/?p=php-bacula-disk-changer.git;a=blobdiff_plain;f=lib%2Flib.php;h=42d30a5d4a4b82511255d6b288c900ffae0d9624;hp=b3d9bbc7f3711e882119cd6b3af051245d859d04;hb=45477c40560ea3bda92e4c03c7ed564228a92bd8;hpb=754af6334eb9dc27818f355409f5528c714dce83

diff --git a/lib/lib.php b/lib/lib.php
index b3d9bbc..42d30a5 100644
--- a/lib/lib.php
+++ b/lib/lib.php
@@ -1 +1,68 @@
 <?php
+
+function db_getDB($changer_name)
+{
+	global $BASE_DATA, $BASE_LIB, $BACULA_USER;
+	
+	try {
+		$dbobject = new PDO("sqlite:$BASE_DATA/$changer_name"."db");
+	} catch(PDOException $exep) {
+		echo "<font color='red'>Cannot open sqlitedb, ".$exep->getMessage()."</font><br>";
+		return;
+	}
+	
+	
+	db_createDB($dbobject);
+	
+	return $dbobject;
+}
+
+function db_createDB($dbobject)
+{
+	
+	if($dbobject->query("select * from disk_list")) {
+		//error_log("table exists?");
+	} else {
+		//error_log("table not exists?");
+		$dbobject->query('CREATE TABLE "disk_list" ("disk_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"disk_name" TEXT NOT NULL);');
+		$dbobject->query('CREATE TABLE sqlite_sequence(name,seq)');
+		$dbobject->query('CREATE TABLE "config" ("config_name" TEXT NOT NULL,"config_value" TEXT NOT NULL)');
+
+		// TODO create action group here
+		
+	}
+}
+
+function conf_getVal($name)
+{
+	$db = db_getDB();
+	
+	$sql = "select conf_val from conf where conf_name=='$name'";
+	error_log("from getval: ".$sql);
+	
+	$res = $db->query($sql);
+	
+	if(!$res) return false;
+	
+	$val = false;
+	
+	foreach($res as $row) {
+		$val = $row["conf_val"];
+	}
+	
+	return $val;
+}
+
+function conf_setVal($name, $value)
+{
+	$db = db_getDB();
+	
+	$sql = "delete from conf where conf_name=='$name'";
+	$db->query($sql);
+	
+	$sql = "insert into conf values ('$name', '$value')";
+	$db->query($sql);
+	
+	error_log("from setval: ".$sql);
+}
+?>
\ No newline at end of file