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'); }