<?php
error_reporting(E_ALL);
include 'config.inc';
$db = pg_connect($conn_str);
$fields = array('num' => '1234', 'str' => 'XXX', 'bin' => 'YYY');
$ids = array('num' => '1234');
if (!pg_delete($db, $table_name, $ids)) {
echo "Error\n";
} else {
echo "Ok\n";
}
* these will include annual netgwcu values to be calculated from the annual gwcu and recharge values
* (keeping them separate in the data is important for subzone calculations)
* the year range and impacted stream reaches and most other data can be determined from
* the zone's stream depletion input data records for this "scenario"
* each record represents one response function application
* in other words, each record will be used to create a time series of stream depletions (usually 20 years long)
* these stream depletions will be saved separately in the pg database to be aggregated later via queries
* to create exactly the reposne that the user desires (without having to reconvolute the same data over and over)
*/
//$excitation_array=array(2001=>5.0,2002=>10.0,2003=>0.0,2004=>15.0);
// clear out the previous data for this stream depletion scenario
$delete_array['model_version'] = $rgmodelversion;
$delete_array['nzone'] = $rgresponsezone;
$delete_array['nsubzone'] = $rgresponsezone;
$delete_array['nscenario'] = $rgstreamdepletionscenario;
pg_delete($pgconnection, $rgstreamdepletiondatatable, $delete_array);
// subtimestep
$subtimestepcount = $options[RGSUBTIMESTEPCOUNT];
// get the str depl scenario records
$query = "SELECT model_version, nzone, nsubzone, nreach, nscenario, nyear,";
$query .= " subzone_gwcu_af, subzone_recharge_af, zone_gwcu_af, zone_recharge_af, streamflow_aprsep_af,";
$query .= " grouping_type, streamflow_avg_af, resp_fn_type, resp_fn_ndx";
$query .= " FROM {$rgstreamdepletionscenariotable}";
$query .= " WHERE model_version={$rgmodelversion}";
$query .= " AND nzone={$rgresponsezone}";
$query .= " AND nsubzone={$rgresponsesubzone}";
$query .= " AND nscenario={$rgstreamdepletionscenario}";
$query .= " ORDER BY nyear, nreach";
$results = pg_query($pgconnection, $query);
$recordcount = 0;
$model_version = array();
<?php
require_once 'config.inc';
$dbh = pg_connect($conn_str);
$tbl_name = 'test_47199';
@pg_query("DROP TABLE {$tbl_name}");
pg_query("CREATE TABLE {$tbl_name} (null_field INT, not_null_field INT NOT NULL)");
pg_insert($dbh, $tbl_name, array('null_field' => null, 'not_null_field' => 1));
pg_insert($dbh, $tbl_name, array('null_field' => null, 'not_null_field' => 2));
var_dump(pg_fetch_all(pg_query('SELECT * FROM ' . $tbl_name)));
$query = pg_delete($dbh, $tbl_name, array('null_field' => NULL, 'not_null_field' => 2), PGSQL_DML_STRING | PGSQL_DML_EXEC);
echo $query, "\n";
$query = pg_update($dbh, $tbl_name, array('null_field' => NULL, 'not_null_field' => 0), array('not_null_field' => 1, 'null_field' => ''), PGSQL_DML_STRING | PGSQL_DML_EXEC);
echo $query, "\n";
var_dump(pg_fetch_all(pg_query('SELECT * FROM ' . $tbl_name)));
@pg_query("DROP TABLE {$tbl_name}");
pg_close($dbh);
echo PHP_EOL . "Done" . PHP_EOL;
<?php
include 'config.inc';
$conn = pg_connect($conn_str);
pg_query('CREATE SCHEMA phptests');
pg_query('CREATE TABLE foo (id INT, id2 INT)');
pg_query('CREATE TABLE phptests.foo (id INT, id2 INT)');
pg_insert($conn, 'foo', array('id' => 1, 'id2' => 1));
pg_insert($conn, 'foo', array('id' => 1, 'id2' => 2));
pg_insert($conn, 'foo', array('id' => 1, 'id2' => 2));
pg_insert($conn, 'foo', array('id' => 3, 'id2' => 3));
pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 1));
pg_insert($conn, 'phptests.foo', array('id' => 1, 'id2' => 2));
pg_insert($conn, 'phptests.foo', array('id' => 2, 'id2' => 3));
pg_insert($conn, 'phptests.foo', array('id' => 2, 'id2' => 3));
pg_delete($conn, 'foo', array('id' => 1, 'id2' => 0));
pg_delete($conn, 'foo', array('id' => 1, 'id2' => 2));
var_dump(pg_delete($conn, 'foo', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
pg_delete($conn, 'phptests.foo', array('id' => 2, 'id2' => 1));
pg_delete($conn, 'phptests.foo', array('id' => 2, 'id2' => 3));
var_dump(pg_delete($conn, 'phptests.foo', array('id' => 2, 'id2' => 3), PGSQL_DML_STRING));
var_dump(pg_fetch_all(pg_query('SELECT * FROM foo')));
var_dump(pg_fetch_all(pg_query('SELECT * FROM phptests.foo')));
/* Inexistent */
pg_delete($conn, 'bar', array('id' => 1, 'id2' => 2));
var_dump(pg_delete($conn, 'bar', array('id' => 1, 'id2' => 2), PGSQL_DML_STRING));
pg_query('DROP TABLE foo');
pg_query('DROP TABLE phptests.foo');
pg_query('DROP SCHEMA phptests');
}
if ($table == 'public.location_user' || $table == 'public.group_user') {
break;
//relasjonstabeller skal ikke returnere noen id
}
$result = pg_query($conn, "select currval('" . $table . "_" . $json_object->table . "_id_seq');");
break;
case "update":
$result = pg_update($conn, $table, $values, $conditions);
break;
case "select":
$sql = "select " . implode(", ", $to_select) . " from " . $table . " where " . implode(" and ", $conditions_array) . ";";
$result = pg_query($conn, $sql);
break;
case "delete":
$result = pg_delete($conn, $table, $conditions);
break;
case "sql":
$result = pg_query($conn, $sql);
$str = "[";
while ($result_row = pg_fetch_assoc($result)) {
$str .= json_encode($result_row) . ",";
}
$str = rtrim($str, ",");
$str .= "]";
echo $str;
exit;
}
if (is_bool($result)) {
echo $result ? 'true' : 'false';
exit;
/**
* Delete data with param
* \param[in] table name of table
* \param[in] condition associative array of field=>value
*/
function delete($table, $cond, $options = PGSQL_DML_EXEC)
{
$res = pg_delete($this->conn, $table, $cond, $options);
if (!$res) {
throw new Exception(DB_ERR . 'Delete: ' . pg_last_error($this->conn));
}
}
