Add deleteEvent helper test.

3 files changed, 80 insertions, 2 deletions

diff --git a/tests/Data_deleteById/DayRecurrings/source.json b/tests/Data_deleteById/DayRecurrings/source.json
new file mode 100644
index 0000000..17ea4cf
--- /dev/null
+++ b/tests/Data_deleteById/DayRecurrings/source.json
@@ -0,0 +1,28 @@
+{
+  "insert_data": [
+    {
+      "id": "1",
+      "start_date": "2015-02-04 11:00:00",
+      "end_date": "2015-02-04 19:30:00",
+      "text": "Event X1",
+      "rec_type": "",
+      "event_length": ""
+    },
+    {
+      "id": "2",
+      "start_date": "2020-07-09 11:00:00",
+      "end_date": "2020-07-09 19:20:00",
+      "text": "Event X2",
+      "rec_type": "day_1___#3",
+      "event_length": "600"
+    }
+  ],
+  "data": [
+    {
+      "id": 1
+    },
+    {
+      "id": 2
+    }
+  ]
+}
\ No newline at end of file
diff --git a/tests/SchedulerHelperTest.php b/tests/SchedulerHelperTest.php
index 9ee80e9..6f69589 100644
--- a/tests/SchedulerHelperTest.php
+++ b/tests/SchedulerHelperTest.php
@@ -28,7 +28,7 @@ class SchedulerHelperTest extends \PHPUnit_Framework_TestCase
 
     public function __destruct()
     {
-        // TODO: Implement __destruct() method.
+        $this->_baseHelper->dropTable();
     }
 
     public function testGetData()
@@ -174,4 +174,51 @@ class SchedulerHelperTest extends \PHPUnit_Framework_TestCase
 
         $this->_logger->logEnd($testName);
     }
+
+    public function testdeleteById(){
+        $testName = "deleteById";
+        $this->_logger->logStart($testName);
+        $schedHelper = new Helper(
+            array(
+                "dbsm" => TestConfig::DBSM,
+                "host" => TestConfig::HOST,
+                "db_name" => TestConfig::DB_NAME,
+                "user" => TestConfig::USER,
+                "password" => TestConfig::PASSWORD,
+                "table_name" => TestConfig::TEMP_TABLE_NAME
+            )
+        );
+        $schedHelper->setFieldsNames(array(
+            $schedHelper::FLD_ID => "id",
+        ));
+
+        $dataHelp = new TestDataHelper($testName);
+        $dataPacks = $dataHelp->getTestDataList();
+        if($dataPacks) {
+            for ($i = 0; $i < count($dataPacks); $i++) {
+                $this->_logger->logStep($testName);
+                $this->_logger->info("$dataPacks[$i] bunch processing....");
+                $source = $dataHelp->getTestSourceData($dataPacks[$i]);
+
+
+                if(!$source){
+                    $this->_logger->warning("There is no data. Bunch is skipped");
+                    continue;
+                }
+
+                $this->_baseHelper->resetTable();
+
+                $this->_baseHelper->insertDataFromJSON($source["insert_data"]);
+
+                foreach($source["data"] as $event){
+                    $schedHelper->deleteById($event["id"]);
+                    $dataFromBase = $this->_baseHelper->getDataFromBase($event["id"]);
+                    $this->assertTrue(count($dataFromBase) === 0,
+                        "Event wasn't removed");
+                }
+            }
+        }
+
+        $this->_logger->logEnd($testName);
+    }
 }
\ No newline at end of file
diff --git a/tests/TestBaseHelper.php b/tests/TestBaseHelper.php
index 99801cb..5372d92 100644
--- a/tests/TestBaseHelper.php
+++ b/tests/TestBaseHelper.php
@@ -100,8 +100,11 @@ class TestBaseHelper
         $this->closeConnection();
     }
 
-    public function getDataFromBase(){
+    public function getDataFromBase($id = NULL){
         $sql = "SELECT * FROM $this->_table_name";
+        if(!is_null($id)){
+            $sql .= " WHERE id=$id";
+        }
         $conn = $this->getConnection()->prepare($sql);
         $conn->execute();
         $data = $conn->fetchAll();