示例#1
0
 public function testFillByObject()
 {
     $query = new SaveQuery('tbl1', (object) array('col1' => 'col1Value', 'col2' => 'col2Value', 'col3' => 1));
     $this->assertSame('INSERT INTO `tbl1` (`col1`,`col2`,`col3`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE `col1` = ?,`col2` = ?,`col3` = ?', $query->getQuery());
     $this->assertSame('ssissi', $query->getMarker());
     $this->assertSame(array('col1Value', 'col2Value', 1, 'col1Value', 'col2Value', 1), $query->getParameters());
 }
 public function act_delete_query()
 {
     if (isset($_POST['delete_yes']) && is_array($_POST['sq'])) {
         $saveQuery = new SaveQuery();
         foreach ($_POST['sq'] as $query) {
             $saveQuery->DeleteFromRecordNumber($query);
         }
         shnMessageQueue::addInformation(_t('QUERIES_DELETED_SUCCESSFULLY_'));
     }
     set_redirect_header('analysis', 'search_query');
 }