lib/db.php

   1 <?php
   2
   3 // i really dont know why i do another obfuscation layer for db's with adodb.
   4 class db {
   5         function init() {
   6
   7                 $sql = 'CREATE TABLE sqlite_sequence(name,seq);';
   8                 $this->dbobject->query($sql);
   9
  10                 $sql = 'CREATE TABLE "hosts" ("ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,"ho_sn_id" INTEGER,"ho_ip" TEXT,"ho_name" TEXT,"ho_desc" TEXT);';
  11                 $this->dbobject->query($sql);
  12
  13                 $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);';
  14                 $this->dbobject->query($sql);
  15
  16                 $sql = 'CREATE TABLE supernet ("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"sn_name" TEXT,"sn_ip" TEXT,"sn_mask" TEXT,"sn_desc" TEXT);';
  17                 $this->dbobject->query($sql);
  18         }
  19
  20         function connect() {
  21                 global $DB_URI;
  22
  23                 try {
  24                         $this->dbobject = new PDO("$DB_URI");
  25                 } catch(PDOException $exep) {
  26                         error_log("execpt on db open");
  27                 }
  28
  29                 if(!$this->dbobject->query("select * from hosts")) {
  30                         error_log("db open for init");
  31                         $this->init();
  32                 }
  33         }
  34
  35         public $dbobject = "";
  36
  37         function dump() {
  38                 $sql = "select * from supernet";
  39                 $res = $this->dbobject->query($sql);
  40
  41                 foreach($res as $row) {
  42                         echo "sn:".$row["sn_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n";
  43                 }
  44                 $sql = "select * from subnet";
  45                 $res = $this->dbobject->query($sql);
  46
  47                 foreach($res as $row) {
  48                         echo "sbn:".$row["sn_id"].":".$row["snid_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n";
  49                 }
  50                 $sql = "select * from hosts";
  51                 $res = $this->dbobject->query($sql);
  52
  53                 foreach($res as $row) {
  54                         echo "hst:".$row["ho_id"].":".$row["ho_sn_id"].":".$row["ho_ip"].":".$row["ho_name"].":".$row["ho_desc"]."\n";
  55                 }
  56         }
  57
  58         function restore($restorefile) {
  59
  60         }
  61 }
  62
  63
  64
  65 $db = new db();
  66 global $db;
  67
  68 ?>