DBDataXMLParserTest.php

<?php
 
import('lib.pkp.tests.DatabaseTestCase');
import('lib.pkp.classes.db.DBDataXMLParser');
 
class DBDataXMLParserTest extends DatabaseTestCase {
   public function testParseSQLData() {
      $dataXMLParser = new DBDataXMLParser();
      $dataXMLParser->setDBConn(DBConnection::getConn());
      $sql = $dataXMLParser->parseData(dirname(__FILE__) . '/data-sql.xml');
      switch (Config::getVar('database', 'driver')) {
         case 'mysqli':
         case 'mysql':
            $this->assertEquals(array('RAW QUERY', 'RAW MYSQL QUERY'), $sql);
            break;
         case 'postgres':
         case 'postgres64':
         case 'postgres7':
         case 'postgres8':
         case 'postgres9':
            $this->assertEquals(array('RAW QUERY', 'RAW POSTGRESQL QUERY'), $sql);
            break;
         default: $this->fail('Unknown DB driver.');
      }
   }
 
   public function testParseTableData() {
      $dataXMLParser = new DBDataXMLParser();
      $dataXMLParser->setDBConn(DBConnection::getConn());
      $sql = $dataXMLParser->parseData(dirname(__FILE__) . '/data-table.xml');
      $this->assertEquals(array(
         'INSERT INTO mytable (notnullable_col, nullable_col, normal_col) VALUES (\'\', NULL, \'MY_VALUE_1\')',
         'INSERT INTO mytable (notnullable_col, nullable_col, normal_col, default_col) VALUES (\'\', NULL, \'MY_VALUE_2\', \'DEFAULT_OVERRIDDEN\')'
      ), $sql);
   }
 
   public function testParseSQLDDL() {
      $dataXMLParser = new DBDataXMLParser();
      $dataXMLParser->setDBConn(DBConnection::getConn());
      switch (Config::getVar('database', 'driver')) {
         case 'mysql':
         case 'mysqli':
            $this->assertEquals(
               array(
                  array('DROP TABLE IF EXISTS myDropTable'),
                  array('ALTER TABLE myModTable DROP COLUMN myDropColumn'),
                  array('RENAME TABLE sessions TO myNewTableName'),
               ),
               $dataXMLParser->parseData(dirname(__FILE__) . '/data-ddl.xml')
            );
            break;
         case 'postgres':
         case 'postgres64':
         case 'postgres7':
         case 'postgres8':
         case 'postgres9':
            $this->markTestSkipped('PostgreSQL/ADODB weirdness prevents this test.');
            break;
         default: $this->fail('Unknown DB driver.');
      }
   }
}