tests/DatabaseTest.php

   1 <?php
   2
   3 require_once( 'PHPUnit.php' );
   4 require_once( '../includes/Defines.php' );
   5 require_once( '../includes/Database.php' );
   6 require_once( '../includes/GlobalFunctions.php' );
   7
   8 class DatabaseTest extends PHPUnit_TestCase {
   9         var $db;
  10
  11         function DatabaseTest( $name ) {
  12                 $this->PHPUnit_TestCase( $name );
  13         }
  14
  15         function setUp() {
  16                 $this->db =& new Database();
  17         }
  18
  19         function tearDown() {
  20                 unset( $this->db );
  21         }
  22
  23         function testFillPreparedEmpty() {
  24                 $sql = $this->db->fillPrepared(
  25                         'SELECT * FROM interwiki', array() );
  26                 $this->assertEquals(
  27                         "SELECT * FROM interwiki",
  28                         $sql);
  29         }
  30
  31         function testFillPreparedQuestion() {
  32                 $sql = $this->db->fillPrepared(
  33                         'SELECT * FROM cur WHERE cur_namespace=? AND cur_title=?',
  34                         array( 4, "Snicker's_paradox" ) );
  35                 $this->assertEquals(
  36                         "SELECT * FROM cur WHERE cur_namespace='4' AND cur_title='Snicker\'s_paradox'",
  37                         $sql);
  38         }
  39
  40         function testFillPreparedBang() {
  41                 $sql = $this->db->fillPrepared(
  42                         'SELECT user_id FROM ! WHERE user_name=?',
  43                         array( '"user"', "Slash's Dot" ) );
  44                 $this->assertEquals(
  45                         "SELECT user_id FROM \"user\" WHERE user_name='Slash\'s Dot'",
  46                         $sql);
  47         }
  48
  49         function testFillPreparedRaw() {
  50                 $sql = $this->db->fillPrepared(
  51                         "SELECT * FROM cur WHERE cur_title='This_\\&_that,_WTF\\?\\!'",
  52                         array( '"user"', "Slash's Dot" ) );
  53                 $this->assertEquals(
  54                         "SELECT * FROM cur WHERE cur_title='This_&_that,_WTF?!'",
  55                         $sql);
  56         }
  57
  58 }
  59
  60 ?>