diff options
author | Matthias Held <ilovemilk@wusa.io> | 2018-07-20 00:04:13 +0300 |
---|---|---|
committer | Matthias Held <ilovemilk@wusa.io> | 2018-07-20 00:04:13 +0300 |
commit | 215f9032c63b70ded85e70b44b0538907551de4b (patch) | |
tree | 0907207a024b40236985dae26936251a531ddbfc /tests/Unit | |
parent | fea0a00fcd59e6dd4c7d7e7fecd0739beea8de69 (diff) |
Shorten database name
Diffstat (limited to 'tests/Unit')
-rw-r--r-- | tests/Unit/Db/FileOperationMapperTest.php | 28 | ||||
-rw-r--r-- | tests/Unit/Service/FileOperationServiceTest.php | 28 |
2 files changed, 28 insertions, 28 deletions
diff --git a/tests/Unit/Db/FileOperationMapperTest.php b/tests/Unit/Db/FileOperationMapperTest.php index 20fb584..917a99a 100644 --- a/tests/Unit/Db/FileOperationMapperTest.php +++ b/tests/Unit/Db/FileOperationMapperTest.php @@ -55,7 +55,7 @@ class FileOperationMapperTest extends MapperTestUtility $userId = 'john'; $id = 3; $rows = [['id' => $this->fileOperations[0]->getId()]]; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `id` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$id, $userId], $rows); @@ -68,7 +68,7 @@ class FileOperationMapperTest extends MapperTestUtility { $userId = 'john'; $id = 3; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `id` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$id, $userId]); @@ -83,7 +83,7 @@ class FileOperationMapperTest extends MapperTestUtility $userId = 'john'; $id = 3; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `id` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$id, $userId], $rows); @@ -98,7 +98,7 @@ class FileOperationMapperTest extends MapperTestUtility $userId = 'john'; $name = 'test'; $rows = [['id' => $this->fileOperations[0]->getId()]]; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `original_name` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$name, $userId], $rows); @@ -111,7 +111,7 @@ class FileOperationMapperTest extends MapperTestUtility { $userId = 'john'; $name = 'test'; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `original_name` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$name, $userId]); @@ -126,7 +126,7 @@ class FileOperationMapperTest extends MapperTestUtility $userId = 'john'; $name = 'test'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `original_name` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$name, $userId], $rows); @@ -140,7 +140,7 @@ class FileOperationMapperTest extends MapperTestUtility { $userId = 'john'; $rows = [['id' => $this->fileOperations[0]->getId()]]; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; $this->setMapperResult($sql, [$userId], $rows); @@ -152,7 +152,7 @@ class FileOperationMapperTest extends MapperTestUtility public function testFindOneWithHighestIdNotFound() { $userId = 'john'; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; $this->setMapperResult($sql, [$userId]); @@ -166,7 +166,7 @@ class FileOperationMapperTest extends MapperTestUtility { $userId = 'john'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; $this->setMapperResult($sql, [$userId], $rows); @@ -180,7 +180,7 @@ class FileOperationMapperTest extends MapperTestUtility { $userId = 'john'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'; + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'; $this->setMapperResult($sql, [$userId], $rows); $result = $this->mapper->findAll([$userId]); @@ -192,7 +192,7 @@ class FileOperationMapperTest extends MapperTestUtility $userId = 'john'; $sequence = '1'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `sequence` = ? AND `user_id` = ?'; + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `sequence` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$sequence, $userId], $rows); $result = $this->mapper->findSequenceById([$sequence, $userId]); @@ -204,7 +204,7 @@ class FileOperationMapperTest extends MapperTestUtility $fileOperation = new FileOperation(); $fileOperation->setId(3); - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_file_operation` WHERE `id` = ?'; + $sql = 'DELETE FROM `*PREFIX*ransomware_detection` WHERE `id` = ?'; $arguments = [$fileOperation->getId()]; $this->setMapperResult($sql, $arguments, [], null, null, true); @@ -219,7 +219,7 @@ class FileOperationMapperTest extends MapperTestUtility $fileOperation->setUserId($userId); $fileOperation->setId(3); - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_file_operation` WHERE `id` = ? AND `user_id` = ?'; + $sql = 'DELETE FROM `*PREFIX*ransomware_detection` WHERE `id` = ? AND `user_id` = ?'; $arguments = [$fileOperation->getId(), $userId]; $this->setMapperResult($sql, $arguments, [], null, null, true); @@ -235,7 +235,7 @@ class FileOperationMapperTest extends MapperTestUtility $fileOperation->setUserId($userId); $fileOperation->setSequence(1); - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_file_operation` WHERE `sequence` = ? AND `user_id` = ?'; + $sql = 'DELETE FROM `*PREFIX*ransomware_detection` WHERE `sequence` = ? AND `user_id` = ?'; $arguments = [$fileOperation->getSequence(), $userId]; $this->setMapperResult($sql, $arguments, [], null, null, true); diff --git a/tests/Unit/Service/FileOperationServiceTest.php b/tests/Unit/Service/FileOperationServiceTest.php index be9dca8..9be9620 100644 --- a/tests/Unit/Service/FileOperationServiceTest.php +++ b/tests/Unit/Service/FileOperationServiceTest.php @@ -58,7 +58,7 @@ class FileOperationServiceTest extends MapperTestUtility $userId = 'john'; $id = 3; $rows = [['id' => $this->fileOperations[0]->getId()]]; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `id` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$id, $userId], $rows); @@ -71,7 +71,7 @@ class FileOperationServiceTest extends MapperTestUtility { $userId = 'john'; $id = 3; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `id` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$id, $userId]); @@ -86,7 +86,7 @@ class FileOperationServiceTest extends MapperTestUtility $userId = 'john'; $id = 3; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `id` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$id, $userId], $rows); @@ -101,7 +101,7 @@ class FileOperationServiceTest extends MapperTestUtility $userId = 'john'; $name = 'test'; $rows = [['id' => $this->fileOperations[0]->getId()]]; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `original_name` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$name, $userId], $rows); @@ -114,7 +114,7 @@ class FileOperationServiceTest extends MapperTestUtility { $userId = 'john'; $name = 'test'; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `original_name` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$name, $userId]); @@ -129,7 +129,7 @@ class FileOperationServiceTest extends MapperTestUtility $userId = 'john'; $name = 'test'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` '. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` '. 'WHERE `original_name` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$name, $userId], $rows); @@ -143,7 +143,7 @@ class FileOperationServiceTest extends MapperTestUtility { $userId = 'john'; $rows = [['id' => $this->fileOperations[0]->getId()]]; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; $this->setMapperResult($sql, [$userId], $rows); @@ -155,7 +155,7 @@ class FileOperationServiceTest extends MapperTestUtility public function testFindOneWithHighestIdNotFound() { $userId = 'john'; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; $this->setMapperResult($sql, [$userId]); @@ -169,7 +169,7 @@ class FileOperationServiceTest extends MapperTestUtility { $userId = 'john'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'. + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'. 'ORDER BY id DESC LIMIT 1'; $this->setMapperResult($sql, [$userId], $rows); @@ -183,7 +183,7 @@ class FileOperationServiceTest extends MapperTestUtility { $userId = 'john'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `user_id` = ?'; + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `user_id` = ?'; $this->setMapperResult($sql, [$userId], $rows); $result = $this->service->findAll(); @@ -195,7 +195,7 @@ class FileOperationServiceTest extends MapperTestUtility $userId = 'john'; $sequence = '1'; $rows = $this->twoRows; - $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_file_operation` WHERE `sequence` = ? AND `user_id` = ?'; + $sql = 'SELECT * FROM `*PREFIX*ransomware_detection` WHERE `sequence` = ? AND `user_id` = ?'; $this->setMapperResult($sql, [$sequence, $userId], $rows); $result = $this->service->findSequenceById([$sequence]); @@ -209,7 +209,7 @@ class FileOperationServiceTest extends MapperTestUtility $fileOperation->setUserId($userId); $fileOperation->setId(3); - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_file_operation` WHERE `id` = ? AND `user_id` = ?'; + $sql = 'DELETE FROM `*PREFIX*ransomware_detection` WHERE `id` = ? AND `user_id` = ?'; $arguments = [$fileOperation->getId(), $userId]; $this->setMapperResult($sql, $arguments, [], null, null, true); @@ -225,7 +225,7 @@ class FileOperationServiceTest extends MapperTestUtility $fileOperation->setUserId($userId); $fileOperation->setSequence(1); - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_file_operation` WHERE `sequence` = ? AND `user_id` = ?'; + $sql = 'DELETE FROM `*PREFIX*ransomware_detection` WHERE `sequence` = ? AND `user_id` = ?'; $arguments = [$fileOperation->getSequence(), $userId]; $this->setMapperResult($sql, $arguments, [], null, null, true); @@ -242,7 +242,7 @@ class FileOperationServiceTest extends MapperTestUtility $fileOperation->setSequence(1); $fileOperation->setTimestamp(strtotime('-1 week')); - $sql = 'DELETE FROM `*PREFIX*ransomware_detection_file_operation` WHERE `timestamp` < ?'; + $sql = 'DELETE FROM `*PREFIX*ransomware_detection` WHERE `timestamp` < ?'; $time = time(); $arguments = [$time]; |