Example #1
0
 /**
  * Ensures that a REPLACE query is properly built.
  */
 public function testReplaceQuery()
 {
     $query = Query::replace();
     $options = array('type' => 'REPLACE', 'table' => 'replaceTable', 'rows' => array(array('user_id' => 1, 'user_name' => 'My Name')), 'keys' => array('user_id'));
     $query->into($options['table'])->values($options['rows'][0])->keys($options['keys']);
     $queryOptions = $query->getOptions();
     foreach ($options as $key => $value) {
         $this->assertArrayHasKey($key, $queryOptions);
         $this->assertEquals($options[$key], $queryOptions[$key]);
     }
 }
 /**
  * Creates an instance of ReplaceQuery for testing.
  */
 public function setUp()
 {
     $this->replaceQuery = Query::replace();
 }