bgui/bugs/bugs_pgsql.php

   1 <?
   2 /*
   3  * bugs_pgsql.php
   4  *
   5  * @(#) $Header$
   6  *
   7  */
   8
   9 class bugs_pgsql_field_class
  10 {
  11         var $name="";
  12         var $table="";
  13
  14         Function SetFieldResult($result,$field)
  15         {
  16                 $this->name=pg_fieldname($result,$field);
  17                 $this->table="";
  18         }
  19 }
  20
  21 class bugs_pgsql_class
  22 {
  23         var $database_hostname="";
  24   var $database_hostport="";
  25         var $database_connection=0;
  26         var $result_fields=array();
  27         var $result_rows=array();
  28
  29         Function Connect($database_name)
  30         {
  31                 global $bugs_database_host,$bugs_debug;
  32
  33                 if($this->database_connection!=0)
  34                 {
  35                         $bugs_debug("The connection to the bugs database is already established!\n");
  36                         return(0);
  37                 }
  38                 if(($this->database_connection=@pg_pconnect($this->database_hostname,$this->database_hostport,$database_name))<=0)
  39                 {
  40                         $bugs_debug("It was not possible to connect to the bugs database!\n");
  41                         return(0);
  42                 }
  43                 return($this->database_connection);
  44         }
  45
  46         Function Query($query)
  47         {
  48                 global $bugs_debug;
  49
  50                 if($this->database_connection<=0)
  51                         $bugs_debug("The connection to the bugs database is not yet established!\n");
  52                 return(pg_Exec($this->database_connection,$query));
  53         }
  54
  55         Function Error()
  56         {
  57                 return(pg_errormessage($this->database_connection));
  58         }
  59
  60         Function CreateDatabase($name)
  61         {
  62                 if($this->database_connection==0)
  63                 {
  64                         if(($link=pg_Connect($this->database_hostname,$this->database_hostport,"template1"))==0)
  65                                 return(0);
  66                 }
  67                 else
  68                         $link=$this->database_connection;
  69                 $success=pg_Exec($link,"CREATE DATABASE $name");
  70                 if($this->database_connection==0)
  71                         pg_Close($link);
  72                 return($success);
  73         }
  74
  75         Function Close()
  76         {
  77                 if($this->database_connection!=0)
  78                 {
  79                         pg_Close($this->database_connection);
  80                         $this->database_connection=0;
  81                 }
  82         }
  83
  84         Function SeparateDateTime()
  85         {
  86                 return(1);
  87         }
  88
  89         Function DateFormat()
  90         {
  91                 return("m-d-Y");
  92         }
  93
  94         Function ScanDate($date)
  95         {
  96                 $scanned_date["month"]=strtok($date,"-");
  97                 $scanned_date["day"]=strtok("-");
  98                 $scanned_date["year"]=strtok(" ");
  99                 return($scanned_date);
 100         }
 101
 102         Function TextFieldsNeedLength()
 103         {
 104                 return(0);
 105         }
 106
 107         Function SupportAutoIncrement()
 108         {
 109                 return(0);
 110         }
 111
 112         Function SupportSequences()
 113         {
 114                 return(0);
 115         }
 116
 117         Function NumberOfRows($result)
 118         {
 119                 return(pg_NumRows($result));
 120         }
 121
 122         Function FreeResult($result)
 123         {
 124                 return(pg_FreeResult($result));
 125         }
 126
 127         Function FetchRow($result,$current_row)
 128         {
 129                 for($row=array(),$field=0;$field<pg_NumFields($result);$field++)
 130                         $row[$field]=pg_result($result,$current_row,$field);
 131                 for($field=0;$field<pg_NumFields($result);$field++)
 132                         $row[pg_FieldName($result,$field)]=pg_result($result,$current_row,$field);
 133                 return($row);
 134         }
 135
 136         Function FetchNextRow($result)
 137         {
 138                 if(!IsSet($this->result_rows["R$result"]))
 139                         $this->result_rows["R$result"]=0;
 140                 if($this->result_rows["R$result"]>=pg_NumRows($result))
 141                         return(0);
 142                 $current_row=$this->result_rows["R$result"]++;
 143                 return($this->FetchRow($result,$current_row));
 144         }
 145
 146         Function NumberOfFields($result)
 147         {
 148                 return(pg_NumFields($result));
 149         }
 150
 151         Function FetchNextField($result)
 152         {
 153                 if(!IsSet($this->result_fields["R$result"]["Object"]))
 154                 {
 155                         $this->result_fields["R$result"]["Object"]=new bugs_pgsql_field_class;
 156                         $this->result_fields["R$result"]["NextField"]=0;
 157                 }
 158                 if($this->result_fields["R$result"]["NextField"]>=pg_NumFields($result))
 159                         return(0);
 160                 $field=$this->result_fields["R$result"]["Object"];
 161                 $field->SetFieldResult($result,$this->result_fields["R$result"]["NextField"]);
 162                 $this->result_fields["R$result"]["NextField"]++;
 163                 return($field);
 164         }
 165
 166         Function FetchArray($result)
 167         {
 168                 return($this->FetchNextRow($result));
 169         }
 170
 171         Function FetchResult($result,$row,$field)
 172         {
 173                 return(pg_result($result,$row,$field));
 174         }
 175 };
 176
 177 ?>