test/SqlCodeTest.php

   1 <?php
   2
   3 require_once('simpletest/unit_tester.php');
   4 require_once('simpletest/reporter.php');
   5
   6 class SqlCodeTest extends UnitTestCase {
   7
   8     function setUp()
   9     {
  10         require_once '../lib/code.php';
  11                 $this->query = 'select * from test';
  12                 $this->md5 = md5($this->query);
  13                 $this->sqlCode = new SqlCode($this->query);
  14                 $this->db =& new PDO("sqlite:bazdig-test.db");
  15     }
  16
  17     function tearDown()
  18     {
  19     }
  20
  21     function testtoSQLinsert()
  22     {
  23         $result   = $this->sqlCode->toSQLinsert();
  24         $expected = "/insert/i";
  25         $this->assertWantedPattern($expected, $result);
  26         $expected = "/'md5:".$this->md5."'/";
  27         $this->assertWantedPattern($expected, $result);
  28     }
  29
  30     function testtoSQLselect()
  31     {
  32         $result   = $this->sqlCode->toSQLselect();
  33         $expected = "/select/i";
  34         $this->assertWantedPattern($expected, $result);
  35         $expected = "/id='md5:".$this->md5."'/";
  36         $this->assertWantedPattern($expected, $result);
  37     }
  38
  39     function testsql_select()
  40     {
  41                 $options = " where code like 'select %'";
  42         $result   = SqlCode::sql_select($options);
  43         $expected = "/$options/i";
  44         $this->assertWantedPattern($expected, $result);
  45         $expected = "/select.+id.+from/i";
  46         $this->assertWantedPattern($expected, $result);
  47         $expected = "/select.+code.+from/i";
  48         $this->assertWantedPattern($expected, $result);
  49         $expected = "/select.+date.+from/i";
  50         $this->assertWantedPattern($expected, $result);
  51     }
  52
  53     function testselect()
  54     {
  55     }
  56
  57         function testcount()
  58         {
  59         }
  60
  61     function testsave()
  62     {
  63     }
  64
  65     function testload()
  66     {
  67     }
  68
  69     function testset_db()
  70     {
  71     }
  72
  73 }
  74 // Running the test.
  75 $test =& new SqlCodeTest;
  76 $test->run(new HtmlReporter());
  77 ?>