ILIAS  release_9 Revision v9.13-25-g2c18ec4c24f
Public Member Functions | Data Fields | Protected Member Functions
ilDBStepExecutionDBTest Class Reference
+ Inheritance diagram for ilDBStepExecutionDBTest:
+ Collaboration diagram for ilDBStepExecutionDBTest:

Public Member Functions

 testStartedThrowsOnLongClassName ()
 
 testFinishedThrowsOnLongClassName ()
 
 testGetLastStartedStepThrowsOnLongClassName ()
 
 testGetLastFinishedStepThrowsOnLongClassName ()
 
 testStartedThrowsOnStartStepNotLargerThenLastFinishedStep ()
 
 testStartedThrowsWhenLastStepNotFinished ()
 
 testFinishedThrowsWhenOtherStepThenLastIsFinished ()
 
 testGetLastStartedStepStartsWithZero ()
 
 testGetLastFinishedStepStartsWithZero ()
 
 testStartedWritesToDB ()
 
 testFinishedWritesToDB ()
 
 testGetLastStartedStepQueriesDB ()
 
 testGetLastFinishedStepQueriesDB ()
 

Data Fields

const CLASS_NAME_200 = "01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789"
 
const CLASS_NAME_201 = "012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"
 

Protected Member Functions

 setUp ()
 

Detailed Description

Definition at line 21 of file ilDBStepExecutionDBTest.php.

Member Function Documentation

◆ setUp()

ilDBStepExecutionDBTest::setUp ( )
protected

Definition at line 26 of file ilDBStepExecutionDBTest.php.

26  : void
27  {
28  $this->db = $this->createMock(\ilDBInterface::class);
29  $this->execution_db = new \ilDBStepExecutionDB($this->db, fn () => new \DateTime());
30  }

◆ testFinishedThrowsOnLongClassName()

ilDBStepExecutionDBTest::testFinishedThrowsOnLongClassName ( )

Definition at line 38 of file ilDBStepExecutionDBTest.php.

38  : void
39  {
40  $this->expectException(\InvalidArgumentException::class);
41  $this->execution_db->finished(self::CLASS_NAME_201, 1);
42  }

◆ testFinishedThrowsWhenOtherStepThenLastIsFinished()

ilDBStepExecutionDBTest::testFinishedThrowsWhenOtherStepThenLastIsFinished ( )

Definition at line 101 of file ilDBStepExecutionDBTest.php.

101  : void
102  {
103  $STEP = 1;
104  $NOW = "2021-08-12 13:37:23.111111";
105 
106  $execution_db = $this->getMockBuilder(\ilDBStepExecutionDB::class)
107  ->onlyMethods(["getLastStartedStep", "getLastFinishedStep"])
108  ->setConstructorArgs([$this->db, fn () => new \DateTime($NOW)])
109  ->getMock();
110 
111  $execution_db->expects($this->once())
112  ->method("getLastStartedStep")
113  ->with(self::CLASS_NAME_200)
114  ->willReturn(2);
115 
116  $this->expectException(\RuntimeException::class);
117 
118  $execution_db->finished(self::CLASS_NAME_200, $STEP);
119  }

◆ testFinishedWritesToDB()

ilDBStepExecutionDBTest::testFinishedWritesToDB ( )

Definition at line 181 of file ilDBStepExecutionDBTest.php.

References ilDBStepExecutionDB\FIELD_CLASS, ilDBStepExecutionDB\FIELD_FINISHED, ilDBStepExecutionDB\FIELD_STEP, and ilDBStepExecutionDB\TABLE_NAME.

181  : void
182  {
183  $STEP = 2;
184  $NOW = "2021-08-12 13:37:23.222222";
185 
186  $execution_db = $this->getMockBuilder(\ilDBStepExecutionDB::class)
187  ->onlyMethods(["getLastStartedStep", "getLastFinishedStep"])
188  ->setConstructorArgs([$this->db, fn () => new \DateTime($NOW)])
189  ->getMock();
190 
191  $execution_db->expects($this->once())
192  ->method("getLastStartedStep")
193  ->with(self::CLASS_NAME_200)
194  ->willReturn(2);
195 
196  $this->db->expects($this->once())
197  ->method("update")
198  ->with(
199  ilDBStepExecutionDB::TABLE_NAME,
200  [
201  ilDBStepExecutionDB::FIELD_FINISHED => ["text", $NOW]
202  ],
203  [
204  ilDBStepExecutionDB::FIELD_CLASS => ["text", self::CLASS_NAME_200],
205  ilDBStepExecutionDB::FIELD_STEP => ["integer", $STEP]
206  ]
207  );
208 
209  $execution_db->finished(self::CLASS_NAME_200, $STEP);
210  }

◆ testGetLastFinishedStepQueriesDB()

ilDBStepExecutionDBTest::testGetLastFinishedStepQueriesDB ( )

Definition at line 241 of file ilDBStepExecutionDBTest.php.

References ilDBStepExecutionDB\FIELD_CLASS, ilDBStepExecutionDB\FIELD_FINISHED, ilDBStepExecutionDB\FIELD_STEP, and ilDBStepExecutionDB\TABLE_NAME.

241  : void
242  {
243  $STEP = 23;
244 
245  $this->db->expects($this->once())
246  ->method("quote")
247  ->withConsecutive(
248  [self::CLASS_NAME_200, "text"],
249  )
250  ->willReturnOnConsecutiveCalls(
251  "CLASS"
252  );
253 
254  $result = $this->getMockBuilder(ilDBStatement::class)->getMock();
255  $this->db->expects($this->once())
256  ->method("query")
257  ->with(
258  "SELECT MAX(" . ilDBStepExecutionDB::FIELD_STEP . ") AS " . ilDBStepExecutionDB::FIELD_STEP .
259  " FROM " . ilDBStepExecutionDB::TABLE_NAME .
260  " WHERE " . ilDBStepExecutionDB::FIELD_CLASS . " = CLASS" .
261  " AND " . ilDBStepExecutionDB::FIELD_FINISHED . " IS NOT NULL"
262  )
263  ->willReturn($result);
264  $this->db->expects($this->once())
265  ->method("fetchAssoc")
266  ->willReturn([ilDBStepExecutionDB::FIELD_STEP => $STEP]);
267 
268  $this->assertEquals($STEP, $this->execution_db->getLastFinishedStep(self::CLASS_NAME_200));
269  }

◆ testGetLastFinishedStepStartsWithZero()

ilDBStepExecutionDBTest::testGetLastFinishedStepStartsWithZero ( )

Definition at line 134 of file ilDBStepExecutionDBTest.php.

References ilDBStepExecutionDB\FIELD_STEP.

134  : void
135  {
136  $result = $this->getMockBuilder(ilDBStatement::class)->getMock();
137  $this->db
138  ->method("query")
139  ->willReturn($result);
140  $this->db
141  ->method("fetchAssoc")
142  ->willReturn([ilDBStepExecutionDB::FIELD_STEP => null]);
143 
144  $this->assertEquals(0, $this->execution_db->getLastFinishedStep(self::CLASS_NAME_200));
145  }

◆ testGetLastFinishedStepThrowsOnLongClassName()

ilDBStepExecutionDBTest::testGetLastFinishedStepThrowsOnLongClassName ( )

Definition at line 50 of file ilDBStepExecutionDBTest.php.

50  : void
51  {
52  $this->expectException(\InvalidArgumentException::class);
53  $this->execution_db->getLastFinishedStep(self::CLASS_NAME_201);
54  }

◆ testGetLastStartedStepQueriesDB()

ilDBStepExecutionDBTest::testGetLastStartedStepQueriesDB ( )

Definition at line 212 of file ilDBStepExecutionDBTest.php.

References ilDBStepExecutionDB\FIELD_CLASS, ilDBStepExecutionDB\FIELD_STEP, and ilDBStepExecutionDB\TABLE_NAME.

212  : void
213  {
214  $STEP = 23;
215 
216  $this->db->expects($this->once())
217  ->method("quote")
218  ->withConsecutive(
219  [self::CLASS_NAME_200, "text"],
220  )
221  ->willReturnOnConsecutiveCalls(
222  "CLASS"
223  );
224 
225  $result = $this->getMockBuilder(ilDBStatement::class)->getMock();
226  $this->db->expects($this->once())
227  ->method("query")
228  ->with(
229  "SELECT MAX(" . ilDBStepExecutionDB::FIELD_STEP . ") AS " . ilDBStepExecutionDB::FIELD_STEP .
230  " FROM " . ilDBStepExecutionDB::TABLE_NAME .
231  " WHERE " . ilDBStepExecutionDB::FIELD_CLASS . " = CLASS"
232  )
233  ->willReturn($result);
234  $this->db->expects($this->once())
235  ->method("fetchAssoc")
236  ->willReturn([ilDBStepExecutionDB::FIELD_STEP => $STEP]);
237 
238  $this->assertEquals($STEP, $this->execution_db->getLastStartedStep(self::CLASS_NAME_200));
239  }

◆ testGetLastStartedStepStartsWithZero()

ilDBStepExecutionDBTest::testGetLastStartedStepStartsWithZero ( )

Definition at line 121 of file ilDBStepExecutionDBTest.php.

References ilDBStepExecutionDB\FIELD_STEP.

121  : void
122  {
123  $result = $this->getMockBuilder(ilDBStatement::class)->getMock();
124  $this->db
125  ->method("query")
126  ->willReturn($result);
127  $this->db
128  ->method("fetchAssoc")
129  ->willReturn([ilDBStepExecutionDB::FIELD_STEP => null]);
130 
131  $this->assertEquals(0, $this->execution_db->getLastStartedStep(self::CLASS_NAME_200));
132  }

◆ testGetLastStartedStepThrowsOnLongClassName()

ilDBStepExecutionDBTest::testGetLastStartedStepThrowsOnLongClassName ( )

Definition at line 44 of file ilDBStepExecutionDBTest.php.

44  : void
45  {
46  $this->expectException(\InvalidArgumentException::class);
47  $this->execution_db->getLastStartedStep(self::CLASS_NAME_201);
48  }

◆ testStartedThrowsOnLongClassName()

ilDBStepExecutionDBTest::testStartedThrowsOnLongClassName ( )

Definition at line 32 of file ilDBStepExecutionDBTest.php.

32  : void
33  {
34  $this->expectException(\InvalidArgumentException::class);
35  $this->execution_db->started(self::CLASS_NAME_201, 1);
36  }

◆ testStartedThrowsOnStartStepNotLargerThenLastFinishedStep()

ilDBStepExecutionDBTest::testStartedThrowsOnStartStepNotLargerThenLastFinishedStep ( )

Definition at line 56 of file ilDBStepExecutionDBTest.php.

56  : void
57  {
58  $STEP = 1;
59  $NOW = "2021-08-12 13:37:23.111111";
60 
61  $execution_db = $this->getMockBuilder(\ilDBStepExecutionDB::class)
62  ->onlyMethods(["getLastStartedStep", "getLastFinishedStep"])
63  ->setConstructorArgs([$this->db, fn () => new \DateTime($NOW)])
64  ->getMock();
65 
66  $execution_db->expects($this->once())
67  ->method("getLastFinishedStep")
68  ->with(self::CLASS_NAME_200)
69  ->willReturn(2);
70 
71  $this->expectException(\RuntimeException::class);
72 
73  $execution_db->started(self::CLASS_NAME_200, $STEP);
74  }

◆ testStartedThrowsWhenLastStepNotFinished()

ilDBStepExecutionDBTest::testStartedThrowsWhenLastStepNotFinished ( )

Definition at line 76 of file ilDBStepExecutionDBTest.php.

76  : void
77  {
78  $NOW = "2021-08-12 13:37:23.111111";
79 
80  $execution_db = $this->getMockBuilder(\ilDBStepExecutionDB::class)
81  ->onlyMethods(["getLastStartedStep", "getLastFinishedStep"])
82  ->setConstructorArgs([$this->db, fn () => new \DateTime($NOW)])
83  ->getMock();
84 
85  $execution_db->expects($this->once())
86  ->method("getLastFinishedStep")
87  ->with(self::CLASS_NAME_200)
88  ->willReturn(1);
89 
90 
91  $execution_db->expects($this->once())
92  ->method("getLastStartedStep")
93  ->with(self::CLASS_NAME_200)
94  ->willReturn(2);
95 
96  $this->expectException(\RuntimeException::class);
97 
98  $execution_db->started(self::CLASS_NAME_200, 3);
99  }

◆ testStartedWritesToDB()

ilDBStepExecutionDBTest::testStartedWritesToDB ( )

Definition at line 147 of file ilDBStepExecutionDBTest.php.

References ilDBStepExecutionDB\FIELD_CLASS, ilDBStepExecutionDB\FIELD_STARTED, ilDBStepExecutionDB\FIELD_STEP, and ilDBStepExecutionDB\TABLE_NAME.

147  : void
148  {
149  $STEP = 2;
150  $NOW = "2021-08-12 13:37:23.111111";
151 
152  $execution_db = $this->getMockBuilder(\ilDBStepExecutionDB::class)
153  ->onlyMethods(["getLastStartedStep", "getLastFinishedStep"])
154  ->setConstructorArgs([$this->db, fn () => new \DateTime($NOW)])
155  ->getMock();
156 
157  $execution_db->expects($this->once())
158  ->method("getLastStartedStep")
159  ->with(self::CLASS_NAME_200)
160  ->willReturn(1);
161 
162  $execution_db->expects($this->once())
163  ->method("getLastFinishedStep")
164  ->with(self::CLASS_NAME_200)
165  ->willReturn(1);
166 
167  $this->db->expects($this->once())
168  ->method("insert")
169  ->with(
170  ilDBStepExecutionDB::TABLE_NAME,
171  [
172  ilDBStepExecutionDB::FIELD_CLASS => ["text", self::CLASS_NAME_200],
173  ilDBStepExecutionDB::FIELD_STEP => ["integer", $STEP],
174  ilDBStepExecutionDB::FIELD_STARTED => ["text", $NOW]
175  ]
176  );
177 
178  $execution_db->started(self::CLASS_NAME_200, $STEP);
179  }

Field Documentation

◆ CLASS_NAME_200

const ilDBStepExecutionDBTest::CLASS_NAME_200 = "01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789"

Definition at line 23 of file ilDBStepExecutionDBTest.php.

◆ CLASS_NAME_201

const ilDBStepExecutionDBTest::CLASS_NAME_201 = "012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"

Definition at line 24 of file ilDBStepExecutionDBTest.php.

The documentation for this class was generated from the following file: