updateclass.php

Go to the documentation of this file.

<?php
/**
 * Update the SQL structure of a table of a DbObj Object
 *
 * @param string $appc the application directory (WHAT, FDL, ...)
 * @param string $class the class name of the DbObj Class
 * @param string $dbname the SQL database name (anakeen, freedom)
 * @author Anakeen 2002
 * @version $Id: updateclass.php.in,v 1.8 2008/12/31 14:39:35 jerome Exp $
 * @license http://creativecommons.org/licenses/by-nc-sa/2.0/fr/ Anakeen - licence CC
 * @package FDL
 * @subpackage CORE
 */
/**
 */

include_once('Class.Application.php');

$appclass = getHttpVars('appc', 'WHAT');
$class = getHttpVars('class', '');
$db = getHttpVars('dbcoord', getDbAccess());

include_once("$pubdir/$appclass/Class.$class.php");

$o= new $class($db);

$dbid=pg_connect($db);
if (! $dbid) {
  print _("cannot access to  database $db\n");
  exit(1);
} else print _("access granted to  database $db\n");

$sql=array();
$rq=@pg_query ($dbid, "select * from ".$o->dbtable." LIMIT 1;");
if (!$rq) {
  // table not exist : just create
  $o->Create();
  // $sqlcmds = explode(";",$o->sqlcreate);
  //   while (list($k,$sqlquery)=each($sqlcmds)) {
  //     if (chop($sqlquery) != "")
  //       $sql[]=$sqlquery;
  // }
} else {
  $row=0;
  
  if (pg_result_error($rq) == "") {
    if (pg_num_rows($rq) > 0 ) {
      $row= pg_fetch_array($rq,0,PGSQL_ASSOC);
      if ($row) {
        $fieds = array_intersect($o->fields,array_keys($row));
        $sql[]= "CREATE TABLE ".$o->dbtable."_old AS SELECT * FROM ".$o->dbtable.";";
      }
    }
    $sql[]= "DROP TABLE ".$o->dbtable.";";
  }
  $sqlcmds = explode(";",$o->sqlcreate);
  while (list($k,$sqlquery)=each($sqlcmds)) {
    if (chop($sqlquery) != "")
      $sql[]=$sqlquery;
  }
  
  if ($row) {
    $sql[]= "INSERT INTO ".$o->dbtable." (".implode(",", $fieds).") SELECT ".implode(",", $fieds). " FROM ".$o->dbtable."_old";
    
    $sql[]= "DROP TABLE ".$o->dbtable."_old;";
  }
}
while (list($k,$v) = each ($sql)) {
  print "Sql:$v\n";
  $rq=@pg_exec ($dbid, $v);
  if (! $rq) {
    if (preg_match("/create sequence/",$v, $reg)) {
      $pgmess = pg_errormessage($dbid);
      echo "".$pgmess."\n";
      
    } else {
      $pgmess = pg_errormessage($dbid);
      echo "".$pgmess."\n";
      echo ""."ABORTED"."\n";
      break;
    }
    
  }
}

pg_close($dbid);

?>