public function deleteKeys($keys) { $key_str = implode(', ', $keys); $sql = <<<SQL DELETE FROM translations_engine WHERE key IN ({$key_str}) SQL; try { $this->writer->query($sql); } catch (\Exception $e) { throw new \RuntimeException($e->getMessage(), $e->getCode(), $e); } return true; }
/** * Delete an object by id from database * @param int $int object identifier * @return boolean */ public function deleteById($id) { $this->validateTableAndIdentityColumn(); // If the soft delete is activated if ($this->deleteColumnName) { $query = <<<EOQ UPDATE {$this->getTableName()} SET {$this->deleteColumnName} = 1 WHERE {$this->escapeCharacter}{$this->identityColumn}{$this->escapeCharacter} = %s EOQ; } else { $query = <<<EOQ DELETE FROM {$this->getTableName()} WHERE {$this->escapeCharacter}{$this->identityColumn}{$this->escapeCharacter} = %s EOQ; } $params = array('identity' => $id); return (bool) $this->db->query($query, $params); }