public function freeResult($name)
{
if (isset($this->result[$name])) {
pg_FreeResult($this->result[$name]);
unset($this->result[$name]);
}
}
function listarErrores($db, $date_ini)
{
$query = "SELECT \r\n\t\t\t id_migracion,\r\n\t\t\t verificado,\r\n\t\t\t consulta,\r\n\t\t\t operacion,\r\n\t\t\t migracion,\r\n\t\t\t fecha_reg,\r\n\t\t\t fecha_mig,\r\n\t\t\t desc_error\r\n\t\t\tFROM \r\n\t\t\t migracion.tmig_migracion m\r\n\t\t\tWHERE m.migracion = 'falla' \r\n\t\t\tand (fecha_correo <= '{$date_ini}' \r\n\t\t\tor fecha_correo is NULL);";
echo $query;
echo "<BR>FECHA ---> " . date("Y/m/d H:i:s") . "<BR>";
$query_upd = "\nUPDATE \r\n\t migracion.tmig_migracion set \r\n\t fecha_correo = '" . date("Y/m/d H:i:s") . "'\r\n\t WHERE\r\n\t\t\t id_migracion = ";
$salida = array();
if ($result = pg_query($db, $query)) {
while ($row = pg_fetch_array($result)) {
$consulta = $query_upd . $row["id_migracion"] . ';';
echo $consulta;
pg_query($db, $consulta);
//enviarCorreo($row['consulta'],$row['desc_error'],$row['operacion'],$row['fecha_mig']);
}
//Libera la memoria
pg_FreeResult($result);
} else {
print 'Error al ejecutar funcion. ' . pg_last_error($db);
}
return $salida;
}
function free()
{
// free the postgresql result tables
return @pg_FreeResult($this->result);
}
function sql_free_result($res)
{
global $dbtype;
switch ($dbtype) {
case "MySQL":
$row = mysql_free_result($res);
return $row;
break;
case "mSQL":
$row = msql_free_result($res);
return $row;
break;
case "postgres":
case "postgres_local":
$rows = pg_FreeResult($res->get_result());
return $rows;
break;
case "ODBC":
case "ODBC_Adabas":
$rows = odbc_free_result($res);
return $rows;
break;
case "Interbase":
echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
return $rows;
break;
case "Sybase":
$rows = sybase_free_result($res);
return $rows;
break;
}
}
function metadata($table = "")
{
$count = 0;
$id = 0;
$res = array();
if ($table) {
$this->connect();
$id = pg_exec($this->Link_ID, "SELECT * FROM {$table}");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->halt("Metadata query failed.");
}
} else {
$id = $this->Query_ID;
if (!$id) {
$this->halt("No query specified.");
}
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]["table"] = $table;
$res[$i]["name"] = pg_FieldName($id, $i);
$res[$i]["type"] = pg_FieldType($id, $i);
$res[$i]["len"] = pg_FieldSize($id, $i);
$res[$i]["flags"] = "";
}
if ($table) {
pg_FreeResult($id);
}
return $res;
}
function metadata($table)
{
$count = 0;
$id = 0;
$res = array();
$this->connect();
$id = pg_exec($this->Link_ID, "select * from {$table} LIMIT 1");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->Errors->addError("Metadata query failed: " . $this->Error);
return 0;
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]["table"] = $table;
$res[$i]["name"] = pg_FieldName($id, $i);
$res[$i]["type"] = pg_FieldType($id, $i);
$res[$i]["len"] = pg_FieldSize($id, $i);
$res[$i]["flags"] = "";
}
pg_FreeResult($id);
return $res;
}
function insert_id($col = "", $tbl = "", $qual = "")
{
global $FC_Link_ID;
if (!empty($FC_Link_ID)) {
$this->Link_ID = $FC_Link_ID;
}
$ires = pg_Exec($this->Link_ID, "select {$col} from {$tbl} where {$qual}");
if (!pg_Fetch_Row($ires, 0)) {
return 0;
}
$iseq = pg_Result($ires, 0, "{$col}");
pg_FreeResult($ires);
return $iseq;
}
function clean_results()
{
if ($this->Query_ID != 0) {
pg_FreeResult($this->Query_ID);
}
}
function free_result($query_id)
{
return pg_FreeResult($query_id);
}
function metadata($table = "", $iArr = 0)
{
$count = 0;
$id = 0;
$res = array();
if ($table) {
$this->connect();
$id = pg_exec($this->conn, "select * from {$table}");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->halt("Metadata query failed.");
}
} else {
$id = $this->rs[$iArr];
if (!$id) {
$this->halt("No query specified.");
}
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res['fields'][$i]["name"] = pg_FieldName($id, $i);
$res['fields'][$i]["type"] = pg_FieldType($id, $i);
$res['fields'][$i]["pkey"] = "0";
}
$this->query("select a.attname, t.typname, case when a.attlen = -1 then 0 " . "else a.attlen end + case when a.atttypmod = -1 then 0 " . "else (a.atttypmod - 4) end ," . "case when d.description isnull THEN a.attname else d.description end , " . "a.attnum from pg_class c " . "inner join pg_attribute a ON (c.oid = a.attrelid AND a.attnum > 0) " . "INNER JOIN pg_type t ON (a.atttypid = t.oid) " . "LEFT OUTER JOIN pg_description d ON (c.relfilenode = d.objoid AND a.attnum = d.objsubid) " . "where c.relname = '" . $table . "' order by a.attnum");
for ($i = 0; $i < $this->numrecords(); $i++) {
$res['fields'][$i]["size"] = $this->f($i, 2);
$res['fields'][$i]["desc"] = $this->f($i, 3);
}
$j = 0;
for ($i = 0; $i < $count; $i++) {
$this->query("SELECT relname, indkey[" . $i . "] " . "FROM pg_catalog.pg_index join pg_catalog.pg_class " . "ON pg_index.indrelid = pg_class.oid " . "WHERE indisprimary=true " . "AND relname = '" . $table . "';", 1);
if ($this->f(0, 1, 1) != "0") {
$res['fields'][$this->f(0, 1, 1) - 1]["pkey"] = "1";
$res['pkey'][$j++] = pg_FieldName($id, $this->f(0, 1, 1) - 1);
}
}
if ($table) {
pg_FreeResult($id);
}
$this->query(' SELECT cl.relname AS table_name, a.attname AS column_name, ' . 'clf.relname AS foreign_table_name, af.attname AS foreign_column_name ' . 'FROM pg_attribute a ' . 'JOIN pg_class cl ON a.attrelid = cl.oid AND cl.relkind = \'r\'::"char" ' . 'JOIN pg_namespace n ON n.oid = cl.relnamespace ' . 'JOIN pg_constraint ct ON a.attrelid = ct.conrelid AND ct.confrelid <> 0::oid ' . 'AND ct.conkey[1] = a.attnum ' . 'JOIN pg_class clf ON ct.confrelid = clf.oid AND clf.relkind = \'r\'::"char" ' . 'JOIN pg_namespace nf ON nf.oid = clf.relnamespace ' . 'JOIN pg_attribute af ON af.attrelid = ct.confrelid AND af.attnum = ct.confkey[1] ' . 'WHERE cl.relname = \'' . $table . '\';');
for ($i = 0; $i < $this->numrecords(); $i++) {
$res['foreign'][$i]["idcol"] = $this->f($i, 'column_name');
$res['foreign'][$i]["foretable"] = $this->f($i, 'foreign_table_name');
$res['foreign'][$i]["forecol"] = $this->f($i, 'foreign_column_name');
}
$this->disconnect();
return $res;
}
function metadata($table)
{
$count = 0;
$id = 0;
$res = array();
$this->connect();
$id = pg_exec($this->Link_ID, "select * from {$table}");
if ($id < 0) {
$this->Error = pg_ErrorMessage($id);
$this->Errno = 1;
$this->halt('Metadata query failed.');
}
$count = pg_NumFields($id);
for ($i = 0; $i < $count; $i++) {
$res[$i]['table'] = $table;
$res[$i]['name'] = pg_FieldName($id, $i);
$res[$i]['type'] = pg_FieldType($id, $i);
$res[$i]['len'] = pg_FieldSize($id, $i);
$res[$i]['flags'] = '';
}
pg_FreeResult($id);
return $res;
}
function GetLastInsertID($sTable)
{
@($res = pg_Exec($this->conn, "select currval('seq_{$sTable}')"));
if ($res) {
$Record = @pg_fetch_array($res, 0);
@pg_FreeResult($res);
return $Record[0];
}
trigger_error("Error getting last insert ID for table {$sTable}! " . pg_ErrorMessage());
return -1;
}
