[Summary view] [Print] [Text view]

   1  <?php
   2  /*
   3   * Limb PHP Framework
   4   *
   5   * @link http://limb-project.com 
   6   * @copyright  Copyright &copy; 2004-2007 BIT(http://bit-creative.com)
   7   * @license    LGPL http://www.gnu.org/copyleft/lesser.html 
   8   */
   9  lmb_require('limb/dbal/src/criteria/lmbSQLFieldCriteria.class.php');
  10  lmb_require('limb/dbal/src/lmbSimpleDb.class.php');
  11  lmb_require('limb/dbal/src/query/lmbDeleteQuery.class.php');
  12  
  13  class lmbDeleteQueryTest extends UnitTestCase
  14  {
  15    var $query;
  16    var $db;
  17  
  18    function setUp()
  19    {
  20      $toolkit = lmbToolkit :: save();
  21      $this->conn = $toolkit->getDefaultDbConnection();
  22      $this->db = new lmbSimpleDb($this->conn);
  23  
  24      $this->_dbCleanUp();
  25    }
  26  
  27    function tearDown()
  28    {
  29      $this->_dbCleanUp();
  30    }
  31  
  32    function _dbCleanUp()
  33    {
  34      $this->db->delete('test_db_table');
  35    }
  36  
  37    function testDelete()
  38    {
  39      $this->db->insert('test_db_table', array('id' => 100));
  40      $this->db->insert('test_db_table', array('id' => 101));
  41  
  42      $query = new lmbDeleteQuery('test_db_table', $this->conn);
  43      $stmt = $query->getStatement();
  44      $stmt->execute();
  45  
  46      $rs = $this->db->select('test_db_table');
  47      $this->assertEqual($rs->count(), 0);
  48    }
  49  
  50    function testDeleteFiltered()
  51    {
  52      $this->db->insert('test_db_table', array('id' => 100));
  53      $this->db->insert('test_db_table', array('id' => 101));
  54      $this->db->insert('test_db_table', array('id' => 102));
  55  
  56      $query = new lmbDeleteQuery('test_db_table', $this->conn);
  57      $query->addCriteria(new lmbSQLFieldCriteria('id', 100));
  58      $stmt = $query->getStatement();
  59      $stmt->execute();
  60  
  61      $rs = $this->db->select('test_db_table')->sort(array('id' => 'ASC'));
  62      $arr = $rs->getArray();
  63      $this->assertEqual($arr[0]['id'], 101);
  64      $this->assertEqual($arr[1]['id'], 102);
  65      $this->assertEqual(sizeof($arr), 2);
  66    }
  67  }
  68  ?>