X-Git-Url: http://git.pjr.cc/?p=otpcentral.git;a=blobdiff_plain;f=php%2Flib%2Fdb.php;fp=php%2Flib%2Fdb.php;h=027ce53ef0457ce11c78ac65f2f77c9075d25e56;hp=0000000000000000000000000000000000000000;hb=b6cadf03d1dcbe1d0c22a7dde09d516a2ed3e8f4;hpb=679295975fca3ceba63268f7ca7fd007fcb7e571

diff --git a/php/lib/db.php b/php/lib/db.php
new file mode 100644
index 0000000..027ce53
--- /dev/null
+++ b/php/lib/db.php
@@ -0,0 +1,62 @@
+<?php
+class db {
+	function init() {
+
+		$sql = 'CREATE TABLE sqlite_sequence(name,seq);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE "hosts" ("ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,"ho_sn_id" INTEGER,"ho_ip" TEXT,"ho_name" TEXT,"ho_desc" TEXT);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE subnet ("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"snid_id" INTEGER,"sn_ip" TEXT,"sn_mask" TEXT,"sn_name" TEXT, "sn_desc" TEXT);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE supernet ("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"sn_name" TEXT,"sn_ip" TEXT,"sn_mask" TEXT,"sn_desc" TEXT);';
+		$this->dbobject->query($sql);
+	}
+	
+	function connect() {
+		global $DB_URI;
+		
+		try {
+			$this->dbobject = new PDO("$DB_URI");
+		} catch(PDOException $exep) {
+			error_log("execpt on db open");
+		}
+		
+		if(!$this->dbobject->query("select * from hosts")) {
+			error_log("db open for init");
+			$this->init();
+		}
+		
+	}
+
+	public $dbobject = "";
+	
+	function dump() {
+		$sql = "select * from supernet";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			echo "sn:".$row["sn_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n";
+		}
+		$sql = "select * from subnet";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			echo "sbn:".$row["sn_id"].":".$row["snid_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n";
+		}
+		$sql = "select * from hosts";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			echo "hst:".$row["ho_id"].":".$row["ho_sn_id"].":".$row["ho_ip"].":".$row["ho_name"].":".$row["ho_desc"]."\n";
+		}
+	}
+	
+	function restore($restorefile) {
+		
+	}
+}
+
+?>
\ No newline at end of file