DBConnectionTest.php

<?php
 
import('lib.pkp.tests.DatabaseTestCase');
import('lib.pkp.classes.db.DBConnection');
 
class DBConnectionTest extends DatabaseTestCase {
   const CONFIG_PGSQL = 'pgsql';
 
   public function testInitDefaultDBConnection() {
      $conn = new DBConnection();
      $dbConn = $conn->getDBConn();
      switch (Config::getVar('database', 'driver')) {
         case 'mysqli':
            self::assertInstanceOf('ADODB_mysqli', $dbConn);
            break;
         case 'mysql':
            self::assertInstanceOf('ADODB_mysql', $dbConn);
            break;
         case 'postgres':
            self::assertInstanceOf('ADODB_postgres7', $dbConn);
            break;
         case 'postgres64':
            self::assertInstanceOf('ADODB_postgres64', $dbConn);
            break;
         case 'postgres7':
            self::assertInstanceOf('ADODB_postgres7', $dbConn);
            break;
         case 'postgres8':
            self::assertInstanceOf('ADODB_postgres8', $dbConn);
            break;
         case 'postgres9':
            self::assertInstanceOf('ADODB_postgres9', $dbConn);
            break;
         default:
            $this->fail('Unknown DB driver.');
            return false;
      }
      $conn->disconnect();
      unset($conn);
   }
 
   public function testInitPostgresDBConnection() {
      $this->markTestSkipped();
      $this->setTestConfiguration(self::CONFIG_PGSQL);
      $conn = new DBConnection();
      $dbConn = $conn->getDBConn();
      self::assertInstanceOf('ADODB_postgres7', $dbConn);
      $conn->disconnect();
      unset($conn);
   }
 
   public function testInitCustomDBConnection() {
      $this->markTestSkipped();
      $this->setTestConfiguration(self::CONFIG_PGSQL);
      $conn = new DBConnection('sqlite', 'localhost', 'ojs', 'ojs', 'ojs', true, false, false);
      $dbConn = $conn->getDBConn();
      self::assertInstanceOf('ADODB_sqlite', $dbConn);
      $conn->disconnect();
      unset($conn);
   }
}