<?php
// $Id: mysql.inc,v 1.2 2009/02/20 02:08:13 boombatower Exp $
/**
 * @file
 * PostgreSQL review backend.
 *
 * @author Josh Waihi ("fiasco", http://drupal.org/user/188162)
 *
 * Copyright 2008-2009 by Jimmy Berry ("boombatower", http://drupal.org/user/214218)
 */

class PIFRClientReviewDB_pgsql implements PIFRClientReviewDB {

  public function clearDatabase($name, $username, $password) {
    db_set_active('testbed');
    $rs = db_query('SELECT table_name FROM information_schema.tables WHERE table_schema = \'public\' AND table_catalog=\'drupal-pifr\'');
    $success = TRUE;
    while ($row = db_fetch_object($rs)) {
      $success = $success && db_query("DROP %s", $row->table_name);
    }
    db_set_active('default');
    return $success;
  }

  public function setVariable($name, $username, $password, $variable_name, $variable_value) {
    db_set_active('testbed');
    $success = variable_set($variable_name, $variable_value);
    db_set_active('default');
    return $success;;
  }
}