diff options
author | Matthias <ilovemilk@wusa.io> | 2020-09-20 18:31:05 +0300 |
---|---|---|
committer | Matthias <ilovemilk@wusa.io> | 2020-09-20 18:31:05 +0300 |
commit | 0e1bd80c61b039ce676c68cff430f75ad262a23d (patch) | |
tree | 47d64bd79b17bfdd6c8067de05464b88713af6ab | |
parent | 1afd930be233d7d99cd3598acd4cda1dc0db9760 (diff) |
shorten table name
-rw-r--r-- | appinfo/database.xml | 2 | ||||
-rw-r--r-- | lib/Db/RecoveredFileOperationMapper.php | 16 |
2 files changed, 9 insertions, 9 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml index 2c58641..c9b3a33 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -104,7 +104,7 @@ </declaration> </table> <table> - <name>*dbprefix*ransomware_detection_recov</name> + <name>*dbprefix*rd_recovery</name> <declaration> <field> <name>id</name> diff --git a/lib/Db/RecoveredFileOperationMapper.php b/lib/Db/RecoveredFileOperationMapper.php index 14c24be..7c57226 100644 --- a/lib/Db/RecoveredFileOperationMapper.php +++ b/lib/Db/RecoveredFileOperationMapper.php @@ -47,7 +47,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function find($id, $userId) { - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` '. + $sql = 'SELECT * FROM `*PREFIX*rd_recovery` '. 'WHERE `id` = ? AND `user_id` = ?'; return $this->findEntity($sql, [$id, $userId]); @@ -65,7 +65,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function findOneByFileName($name, $userId) { - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` '. + $sql = 'SELECT * FROM `*PREFIX*rd_recovery` '. 'WHERE `original_name` = ? AND `user_id` = ?'; return $this->findEntity($sql, [$name, $userId]); @@ -81,7 +81,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function findOneWithHighestId($userId) { - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*rd_recovery` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; return $this->findEntity($sql, [$userId]); @@ -97,7 +97,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function findAll(array $params = [], $limit = null, $offset = null) { - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` WHERE `user_id` = ?'; + $sql = 'SELECT * FROM `*PREFIX*rd_recovery` WHERE `user_id` = ?'; return $this->findEntities($sql, $params, $limit, $offset); } @@ -113,7 +113,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function findSequenceById(array $params = [], $limit = null, $offset = null) { - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` WHERE `sequence` = ? AND `user_id` = ?'; + $sql = 'SELECT * FROM `*PREFIX*rd_recovery` WHERE `sequence` = ? AND `user_id` = ?'; return $this->findEntities($sql, $params, $limit, $offset); } @@ -125,7 +125,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function deleteById($id, $userId) { - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_recov` WHERE `id` = ? AND `user_id` = ?'; + $sql = 'DELETE FROM `*PREFIX*rd_recovery` WHERE `id` = ? AND `user_id` = ?'; $stmt = $this->execute($sql, [$id, $userId]); $stmt->closeCursor(); } @@ -137,7 +137,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function deleteSequenceById($sequence, $userId) { - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_recov` WHERE `sequence` = ? AND `user_id` = ?'; + $sql = 'DELETE FROM `*PREFIX*rd_recovery` WHERE `sequence` = ? AND `user_id` = ?'; $stmt = $this->execute($sql, [$sequence, $userId]); $stmt->closeCursor(); } @@ -149,7 +149,7 @@ class RecoveredFileOperationMapper extends Mapper */ public function deleteFileOperationsBefore($timestamp) { - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_recov` WHERE `timestamp` < ?'; + $sql = 'DELETE FROM `*PREFIX*rd_recovery` WHERE `timestamp` < ?'; $stmt = $this->execute($sql, [$timestamp]); $stmt->closeCursor(); } |