PHP db_drop_sequence_if_exists Examples

Example #1

File: project_weekly_metric.php Project: neymanna/fusionforge

if ($sys_database_type == 'mysql') {
    $sql .= "SELECT ranking,100-(100*((ranking-1)/{$counts})),group_id ";
} else {
    $sql .= "SELECT ranking,100-(100*((ranking::float-1)/{$counts})),group_id ";
}
$sql .= "\nFROM project_metric_weekly_tmp1\nORDER BY ranking ASC";
$rel = db_query($sql);
if (!$rel) {
    $err .= "\n\n***ERROR: {$sql}\n\n" . db_error();
}
//
//	Now archive the metric
//
db_query("DELETE FROM stats_project_metric WHERE month='{$this_year}{$this_month}' AND day='{$this_day}'");
$sql = "INSERT INTO stats_project_metric (month,day,group_id,ranking,percentile) ";
if ($sys_database_type == 'mysql') {
    $sql .= "SELECT '{$this_year}{$this_month}', '{$this_day}',group_id,ranking,percentile ";
} else {
    $sql .= "SELECT '{$this_year}{$this_month}'::int, '{$this_day}'::int,group_id,ranking,percentile ";
}
$sql .= "\n\tFROM project_weekly_metric";
$rel = db_query($sql);
if (!$rel) {
    $err .= "\n\n***ERROR: {$sql}\n\n" . db_error();
}
$err .= db_error();
db_drop_sequence_if_exists("project_metric_weekly_seq");
db_drop_table_if_exists("project_counts_weekly_tmp");
db_drop_table_if_exists("project_metric_weekly_tmp1");
db_drop_sequence_if_exists("project_metric_week_ranking_seq");
cron_entry(8, $err);

Example #2

File: calculate_user_metric.php Project: neymanna/fusionforge

        if (!$res || db_affected_rows($res) < 1) {
            $err .= "Error in round {$i} setting importance factor: ";
            $err .= '<p>' . $sql . '<p>';
            $err .= db_error();
            exit;
        }
    }
}
db_commit();
db_query("DELETE FROM user_metric;");
db_query("INSERT INTO user_metric SELECT * FROM user_metric" . ($i - 1) . ";");
//$err .= '<p>'.db_error().'<p>';
/*
	Now run through and drop the tmp tables
*/
// $err .= "<p>Cleaning up tables<p>";
for ($i = 1; $i < 9; $i++) {
    db_drop_table_if_exists("user_metric_tmp1_" . $i);
    db_drop_sequence_if_exists("user_metric_tmp1_" . $i . "_ranking_seq");
    db_drop_table_if_exists("user_metric" . $i);
}
$err .= db_error();
$t = time();
$ts_month = date('Ym', $t);
$ts_day = date('d', $t);
db_begin();
db_query("DELETE FROM user_metric_history WHERE month='{$ts_month}' AND day='{$ts_day}'");
db_query("\n\tINSERT INTO user_metric_history\n\tSELECT '{$ts_month}','{$ts_day}',user_id,ranking,metric\n\tFROM user_metric\n");
$err .= db_error();
cron_entry(1, $err);
db_commit();