Skip to content

Commit 87e8fe7

Browse files
committed
Config Repo: Use INSERT ... ON DUPLICATE KEY UPDATE query
1 parent 8698586 commit 87e8fe7

1 file changed

Lines changed: 11 additions & 11 deletions

File tree

src/App/Repository/ConfigRepository.php

Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -129,17 +129,17 @@ private function insertOrUpdate($group, $key, $value)
129129
{
130130
$value = json_encode($value);
131131

132-
try {
133-
DB::insert('config', array('group_name', 'config_key', 'config_value'))
134-
->values(array($group, $key, $value))
135-
->execute($this->db);
136-
} catch (\Database_Exception $e) {
137-
DB::update('config')
138-
->set(array('config_value' => $value))
139-
->where('group_name', '=', $group)
140-
->where('config_key', '=', $key)
141-
->execute($this->db);
142-
}
132+
DB::query(Database::INSERT, "
133+
INSERT INTO `config`
134+
(`group_name`, `config_key`, `config_value`) VALUES (:group, :key, :value)
135+
ON DUPLICATE KEY UPDATE `config_value` = :value;
136+
")
137+
->parameters([
138+
':group' => $group,
139+
':key' => $key,
140+
':value' => $value
141+
])
142+
->execute($this->db);
143143
}
144144

145145
// ConfigRepository

0 commit comments

Comments
 (0)