MediaWiki  1.23.2
DatabaseSQLTest.php
Go to the documentation of this file.
1 <?php
2 
7 class DatabaseSQLTest extends MediaWikiTestCase {
8 
12  private $database;
13 
14  protected function setUp() {
15  parent::setUp();
16  $this->database = new DatabaseTestHelper( __CLASS__ );
17  }
18 
19  protected function assertLastSql( $sqlText ) {
20  $this->assertEquals(
21  $this->database->getLastSqls(),
22  $sqlText
23  );
24  }
25 
30  public function testSelect( $sql, $sqlText ) {
31  $this->database->select(
32  $sql['tables'],
33  $sql['fields'],
34  isset( $sql['conds'] ) ? $sql['conds'] : array(),
35  __METHOD__,
36  isset( $sql['options'] ) ? $sql['options'] : array(),
37  isset( $sql['join_conds'] ) ? $sql['join_conds'] : array()
38  );
39  $this->assertLastSql( $sqlText );
40  }
41 
42  public static function provideSelect() {
43  return array(
44  array(
45  array(
46  'tables' => 'table',
47  'fields' => array( 'field', 'alias' => 'field2' ),
48  'conds' => array( 'alias' => 'text' ),
49  ),
50  "SELECT field,field2 AS alias " .
51  "FROM table " .
52  "WHERE alias = 'text'"
53  ),
54  array(
55  array(
56  'tables' => 'table',
57  'fields' => array( 'field', 'alias' => 'field2' ),
58  'conds' => array( 'alias' => 'text' ),
59  'options' => array( 'LIMIT' => 1, 'ORDER BY' => 'field' ),
60  ),
61  "SELECT field,field2 AS alias " .
62  "FROM table " .
63  "WHERE alias = 'text' " .
64  "ORDER BY field " .
65  "LIMIT 1"
66  ),
67  array(
68  array(
69  'tables' => array( 'table', 't2' => 'table2' ),
70  'fields' => array( 'tid', 'field', 'alias' => 'field2', 't2.id' ),
71  'conds' => array( 'alias' => 'text' ),
72  'options' => array( 'LIMIT' => 1, 'ORDER BY' => 'field' ),
73  'join_conds' => array( 't2' => array(
74  'LEFT JOIN', 'tid = t2.id'
75  ) ),
76  ),
77  "SELECT tid,field,field2 AS alias,t2.id " .
78  "FROM table LEFT JOIN table2 t2 ON ((tid = t2.id)) " .
79  "WHERE alias = 'text' " .
80  "ORDER BY field " .
81  "LIMIT 1"
82  ),
83  array(
84  array(
85  'tables' => array( 'table', 't2' => 'table2' ),
86  'fields' => array( 'tid', 'field', 'alias' => 'field2', 't2.id' ),
87  'conds' => array( 'alias' => 'text' ),
88  'options' => array( 'LIMIT' => 1, 'GROUP BY' => 'field', 'HAVING' => 'COUNT(*) > 1' ),
89  'join_conds' => array( 't2' => array(
90  'LEFT JOIN', 'tid = t2.id'
91  ) ),
92  ),
93  "SELECT tid,field,field2 AS alias,t2.id " .
94  "FROM table LEFT JOIN table2 t2 ON ((tid = t2.id)) " .
95  "WHERE alias = 'text' " .
96  "GROUP BY field HAVING COUNT(*) > 1 " .
97  "LIMIT 1"
98  ),
99  array(
100  array(
101  'tables' => array( 'table', 't2' => 'table2' ),
102  'fields' => array( 'tid', 'field', 'alias' => 'field2', 't2.id' ),
103  'conds' => array( 'alias' => 'text' ),
104  'options' => array( 'LIMIT' => 1, 'GROUP BY' => array( 'field', 'field2' ), 'HAVING' => array( 'COUNT(*) > 1', 'field' => 1 ) ),
105  'join_conds' => array( 't2' => array(
106  'LEFT JOIN', 'tid = t2.id'
107  ) ),
108  ),
109  "SELECT tid,field,field2 AS alias,t2.id " .
110  "FROM table LEFT JOIN table2 t2 ON ((tid = t2.id)) " .
111  "WHERE alias = 'text' " .
112  "GROUP BY field,field2 HAVING (COUNT(*) > 1) AND field = '1' " .
113  "LIMIT 1"
114  ),
115  array(
116  array(
117  'tables' => array( 'table' ),
118  'fields' => array( 'alias' => 'field' ),
119  'conds' => array( 'alias' => array( 1, 2, 3, 4 ) ),
120  ),
121  "SELECT field AS alias " .
122  "FROM table " .
123  "WHERE alias IN ('1','2','3','4')"
124  ),
125  );
126  }
127 
132  public function testUpdate( $sql, $sqlText ) {
133  $this->database->update(
134  $sql['table'],
135  $sql['values'],
136  $sql['conds'],
137  __METHOD__,
138  isset( $sql['options'] ) ? $sql['options'] : array()
139  );
140  $this->assertLastSql( $sqlText );
141  }
142 
143  public static function provideUpdate() {
144  return array(
145  array(
146  array(
147  'table' => 'table',
148  'values' => array( 'field' => 'text', 'field2' => 'text2' ),
149  'conds' => array( 'alias' => 'text' ),
150  ),
151  "UPDATE table " .
152  "SET field = 'text'" .
153  ",field2 = 'text2' " .
154  "WHERE alias = 'text'"
155  ),
156  array(
157  array(
158  'table' => 'table',
159  'values' => array( 'field = other', 'field2' => 'text2' ),
160  'conds' => array( 'id' => '1' ),
161  ),
162  "UPDATE table " .
163  "SET field = other" .
164  ",field2 = 'text2' " .
165  "WHERE id = '1'"
166  ),
167  array(
168  array(
169  'table' => 'table',
170  'values' => array( 'field = other', 'field2' => 'text2' ),
171  'conds' => '*',
172  ),
173  "UPDATE table " .
174  "SET field = other" .
175  ",field2 = 'text2'"
176  ),
177  );
178  }
179 
184  public function testDelete( $sql, $sqlText ) {
185  $this->database->delete(
186  $sql['table'],
187  $sql['conds'],
188  __METHOD__
189  );
190  $this->assertLastSql( $sqlText );
191  }
192 
193  public static function provideDelete() {
194  return array(
195  array(
196  array(
197  'table' => 'table',
198  'conds' => array( 'alias' => 'text' ),
199  ),
200  "DELETE FROM table " .
201  "WHERE alias = 'text'"
202  ),
203  array(
204  array(
205  'table' => 'table',
206  'conds' => '*',
207  ),
208  "DELETE FROM table"
209  ),
210  );
211  }
212 
217  public function testUpsert( $sql, $sqlText ) {
218  $this->database->upsert(
219  $sql['table'],
220  $sql['rows'],
221  $sql['uniqueIndexes'],
222  $sql['set'],
223  __METHOD__
224  );
225  $this->assertLastSql( $sqlText );
226  }
227 
228  public static function provideUpsert() {
229  return array(
230  array(
231  array(
232  'table' => 'upsert_table',
233  'rows' => array( 'field' => 'text', 'field2' => 'text2' ),
234  'uniqueIndexes' => array( 'field' ),
235  'set' => array( 'field' => 'set' ),
236  ),
237  "BEGIN; " .
238  "UPDATE upsert_table " .
239  "SET field = 'set' " .
240  "WHERE ((field = 'text')); " .
241  "INSERT IGNORE INTO upsert_table " .
242  "(field,field2) " .
243  "VALUES ('text','text2'); " .
244  "COMMIT"
245  ),
246  );
247  }
248 
253  public function testDeleteJoin( $sql, $sqlText ) {
254  $this->database->deleteJoin(
255  $sql['delTable'],
256  $sql['joinTable'],
257  $sql['delVar'],
258  $sql['joinVar'],
259  $sql['conds'],
260  __METHOD__
261  );
262  $this->assertLastSql( $sqlText );
263  }
264 
265  public static function provideDeleteJoin() {
266  return array(
267  array(
268  array(
269  'delTable' => 'table',
270  'joinTable' => 'table_join',
271  'delVar' => 'field',
272  'joinVar' => 'field_join',
273  'conds' => array( 'alias' => 'text' ),
274  ),
275  "DELETE FROM table " .
276  "WHERE field IN (" .
277  "SELECT field_join FROM table_join WHERE alias = 'text'" .
278  ")"
279  ),
280  array(
281  array(
282  'delTable' => 'table',
283  'joinTable' => 'table_join',
284  'delVar' => 'field',
285  'joinVar' => 'field_join',
286  'conds' => '*',
287  ),
288  "DELETE FROM table " .
289  "WHERE field IN (" .
290  "SELECT field_join FROM table_join " .
291  ")"
292  ),
293  );
294  }
295 
300  public function testInsert( $sql, $sqlText ) {
301  $this->database->insert(
302  $sql['table'],
303  $sql['rows'],
304  __METHOD__,
305  isset( $sql['options'] ) ? $sql['options'] : array()
306  );
307  $this->assertLastSql( $sqlText );
308  }
309 
310  public static function provideInsert() {
311  return array(
312  array(
313  array(
314  'table' => 'table',
315  'rows' => array( 'field' => 'text', 'field2' => 2 ),
316  ),
317  "INSERT INTO table " .
318  "(field,field2) " .
319  "VALUES ('text','2')"
320  ),
321  array(
322  array(
323  'table' => 'table',
324  'rows' => array( 'field' => 'text', 'field2' => 2 ),
325  'options' => 'IGNORE',
326  ),
327  "INSERT IGNORE INTO table " .
328  "(field,field2) " .
329  "VALUES ('text','2')"
330  ),
331  array(
332  array(
333  'table' => 'table',
334  'rows' => array(
335  array( 'field' => 'text', 'field2' => 2 ),
336  array( 'field' => 'multi', 'field2' => 3 ),
337  ),
338  'options' => 'IGNORE',
339  ),
340  "INSERT IGNORE INTO table " .
341  "(field,field2) " .
342  "VALUES " .
343  "('text','2')," .
344  "('multi','3')"
345  ),
346  );
347  }
348 
353  public function testInsertSelect( $sql, $sqlText ) {
354  $this->database->insertSelect(
355  $sql['destTable'],
356  $sql['srcTable'],
357  $sql['varMap'],
358  $sql['conds'],
359  __METHOD__,
360  isset( $sql['insertOptions'] ) ? $sql['insertOptions'] : array(),
361  isset( $sql['selectOptions'] ) ? $sql['selectOptions'] : array()
362  );
363  $this->assertLastSql( $sqlText );
364  }
365 
366  public static function provideInsertSelect() {
367  return array(
368  array(
369  array(
370  'destTable' => 'insert_table',
371  'srcTable' => 'select_table',
372  'varMap' => array( 'field_insert' => 'field_select', 'field' => 'field2' ),
373  'conds' => '*',
374  ),
375  "INSERT INTO insert_table " .
376  "(field_insert,field) " .
377  "SELECT field_select,field2 " .
378  "FROM select_table"
379  ),
380  array(
381  array(
382  'destTable' => 'insert_table',
383  'srcTable' => 'select_table',
384  'varMap' => array( 'field_insert' => 'field_select', 'field' => 'field2' ),
385  'conds' => array( 'field' => 2 ),
386  ),
387  "INSERT INTO insert_table " .
388  "(field_insert,field) " .
389  "SELECT field_select,field2 " .
390  "FROM select_table " .
391  "WHERE field = '2'"
392  ),
393  array(
394  array(
395  'destTable' => 'insert_table',
396  'srcTable' => 'select_table',
397  'varMap' => array( 'field_insert' => 'field_select', 'field' => 'field2' ),
398  'conds' => array( 'field' => 2 ),
399  'insertOptions' => 'IGNORE',
400  'selectOptions' => array( 'ORDER BY' => 'field' ),
401  ),
402  "INSERT IGNORE INTO insert_table " .
403  "(field_insert,field) " .
404  "SELECT field_select,field2 " .
405  "FROM select_table " .
406  "WHERE field = '2' " .
407  "ORDER BY field"
408  ),
409  );
410  }
411 
416  public function testReplace( $sql, $sqlText ) {
417  $this->database->replace(
418  $sql['table'],
419  $sql['uniqueIndexes'],
420  $sql['rows'],
421  __METHOD__
422  );
423  $this->assertLastSql( $sqlText );
424  }
425 
426  public static function provideReplace() {
427  return array(
428  array(
429  array(
430  'table' => 'replace_table',
431  'uniqueIndexes' => array( 'field' ),
432  'rows' => array( 'field' => 'text', 'field2' => 'text2' ),
433  ),
434  "DELETE FROM replace_table " .
435  "WHERE ( field='text' ); " .
436  "INSERT INTO replace_table " .
437  "(field,field2) " .
438  "VALUES ('text','text2')"
439  ),
440  array(
441  array(
442  'table' => 'module_deps',
443  'uniqueIndexes' => array( array( 'md_module', 'md_skin' ) ),
444  'rows' => array(
445  'md_module' => 'module',
446  'md_skin' => 'skin',
447  'md_deps' => 'deps',
448  ),
449  ),
450  "DELETE FROM module_deps " .
451  "WHERE ( md_module='module' AND md_skin='skin' ); " .
452  "INSERT INTO module_deps " .
453  "(md_module,md_skin,md_deps) " .
454  "VALUES ('module','skin','deps')"
455  ),
456  array(
457  array(
458  'table' => 'module_deps',
459  'uniqueIndexes' => array( array( 'md_module', 'md_skin' ) ),
460  'rows' => array(
461  array(
462  'md_module' => 'module',
463  'md_skin' => 'skin',
464  'md_deps' => 'deps',
465  ), array(
466  'md_module' => 'module2',
467  'md_skin' => 'skin2',
468  'md_deps' => 'deps2',
469  ),
470  ),
471  ),
472  "DELETE FROM module_deps " .
473  "WHERE ( md_module='module' AND md_skin='skin' ); " .
474  "INSERT INTO module_deps " .
475  "(md_module,md_skin,md_deps) " .
476  "VALUES ('module','skin','deps'); " .
477  "DELETE FROM module_deps " .
478  "WHERE ( md_module='module2' AND md_skin='skin2' ); " .
479  "INSERT INTO module_deps " .
480  "(md_module,md_skin,md_deps) " .
481  "VALUES ('module2','skin2','deps2')"
482  ),
483  array(
484  array(
485  'table' => 'module_deps',
486  'uniqueIndexes' => array( 'md_module', 'md_skin' ),
487  'rows' => array(
488  array(
489  'md_module' => 'module',
490  'md_skin' => 'skin',
491  'md_deps' => 'deps',
492  ), array(
493  'md_module' => 'module2',
494  'md_skin' => 'skin2',
495  'md_deps' => 'deps2',
496  ),
497  ),
498  ),
499  "DELETE FROM module_deps " .
500  "WHERE ( md_module='module' ) OR ( md_skin='skin' ); " .
501  "INSERT INTO module_deps " .
502  "(md_module,md_skin,md_deps) " .
503  "VALUES ('module','skin','deps'); " .
504  "DELETE FROM module_deps " .
505  "WHERE ( md_module='module2' ) OR ( md_skin='skin2' ); " .
506  "INSERT INTO module_deps " .
507  "(md_module,md_skin,md_deps) " .
508  "VALUES ('module2','skin2','deps2')"
509  ),
510  array(
511  array(
512  'table' => 'module_deps',
513  'uniqueIndexes' => array(),
514  'rows' => array(
515  'md_module' => 'module',
516  'md_skin' => 'skin',
517  'md_deps' => 'deps',
518  ),
519  ),
520  "INSERT INTO module_deps " .
521  "(md_module,md_skin,md_deps) " .
522  "VALUES ('module','skin','deps')"
523  ),
524  );
525  }
526 
531  public function testNativeReplace( $sql, $sqlText ) {
532  $this->database->nativeReplace(
533  $sql['table'],
534  $sql['rows'],
535  __METHOD__
536  );
537  $this->assertLastSql( $sqlText );
538  }
539 
540  public static function provideNativeReplace() {
541  return array(
542  array(
543  array(
544  'table' => 'replace_table',
545  'rows' => array( 'field' => 'text', 'field2' => 'text2' ),
546  ),
547  "REPLACE INTO replace_table " .
548  "(field,field2) " .
549  "VALUES ('text','text2')"
550  ),
551  );
552  }
553 
558  public function testConditional( $sql, $sqlText ) {
559  $this->assertEquals( trim( $this->database->conditional(
560  $sql['conds'],
561  $sql['true'],
562  $sql['false']
563  ) ), $sqlText );
564  }
565 
566  public static function provideConditional() {
567  return array(
568  array(
569  array(
570  'conds' => array( 'field' => 'text' ),
571  'true' => 1,
572  'false' => 'NULL',
573  ),
574  "(CASE WHEN field = 'text' THEN 1 ELSE NULL END)"
575  ),
576  array(
577  array(
578  'conds' => array( 'field' => 'text', 'field2' => 'anothertext' ),
579  'true' => 1,
580  'false' => 'NULL',
581  ),
582  "(CASE WHEN field = 'text' AND field2 = 'anothertext' THEN 1 ELSE NULL END)"
583  ),
584  array(
585  array(
586  'conds' => 'field=1',
587  'true' => 1,
588  'false' => 'NULL',
589  ),
590  "(CASE WHEN field=1 THEN 1 ELSE NULL END)"
591  ),
592  );
593  }
594 
599  public function testBuildConcat( $stringList, $sqlText ) {
600  $this->assertEquals( trim( $this->database->buildConcat(
601  $stringList
602  ) ), $sqlText );
603  }
604 
605  public static function provideBuildConcat() {
606  return array(
607  array(
608  array( 'field', 'field2' ),
609  "CONCAT(field,field2)"
610  ),
611  array(
612  array( "'test'", 'field2' ),
613  "CONCAT('test',field2)"
614  ),
615  );
616  }
617 
622  public function testBuildLike( $array, $sqlText ) {
623  $this->assertEquals( trim( $this->database->buildLike(
624  $array
625  ) ), $sqlText );
626  }
627 
628  public static function provideBuildLike() {
629  return array(
630  array(
631  'text',
632  "LIKE 'text'"
633  ),
634  array(
635  array( 'text', new LikeMatch( '%' ) ),
636  "LIKE 'text%'"
637  ),
638  array(
639  array( 'text', new LikeMatch( '%' ), 'text2' ),
640  "LIKE 'text%text2'"
641  ),
642  array(
643  array( 'text', new LikeMatch( '_' ) ),
644  "LIKE 'text_'"
645  ),
646  );
647  }
648 
653  public function testUnionQueries( $sql, $sqlText ) {
654  $this->assertEquals( trim( $this->database->unionQueries(
655  $sql['sqls'],
656  $sql['all']
657  ) ), $sqlText );
658  }
659 
660  public static function provideUnionQueries() {
661  return array(
662  array(
663  array(
664  'sqls' => array( 'RAW SQL', 'RAW2SQL' ),
665  'all' => true,
666  ),
667  "(RAW SQL) UNION ALL (RAW2SQL)"
668  ),
669  array(
670  array(
671  'sqls' => array( 'RAW SQL', 'RAW2SQL' ),
672  'all' => false,
673  ),
674  "(RAW SQL) UNION (RAW2SQL)"
675  ),
676  array(
677  array(
678  'sqls' => array( 'RAW SQL', 'RAW2SQL', 'RAW3SQL' ),
679  'all' => false,
680  ),
681  "(RAW SQL) UNION (RAW2SQL) UNION (RAW3SQL)"
682  ),
683  );
684  }
685 
689  public function testTransactionCommit() {
690  $this->database->begin( __METHOD__ );
691  $this->database->commit( __METHOD__ );
692  $this->assertLastSql( 'BEGIN; COMMIT' );
693  }
694 
698  public function testTransactionRollback() {
699  $this->database->begin( __METHOD__ );
700  $this->database->rollback( __METHOD__ );
701  $this->assertLastSql( 'BEGIN; ROLLBACK' );
702  }
703 
707  public function testDropTable() {
708  $this->database->setExistingTables( array( 'table' ) );
709  $this->database->dropTable( 'table', __METHOD__ );
710  $this->assertLastSql( 'DROP TABLE table' );
711  }
712 
716  public function testDropNonExistingTable() {
717  $this->assertFalse(
718  $this->database->dropTable( 'non_existing', __METHOD__ )
719  );
720  }
721 }
DatabaseSQLTest\provideUnionQueries
static provideUnionQueries()
Definition: DatabaseSQLTest.php:659
DatabaseSQLTest\provideNativeReplace
static provideNativeReplace()
Definition: DatabaseSQLTest.php:539
DatabaseSQLTest\testBuildConcat
testBuildConcat( $stringList, $sqlText)
@dataProvider provideBuildConcat @covers DatabaseBase::buildConcat
Definition: DatabaseSQLTest.php:598
php
skin txt MediaWiki includes four core it has been set as the default in MediaWiki since the replacing Monobook it had been been the default skin since before being replaced by Vector largely rewritten in while keeping its appearance Several legacy skins were removed in the as the burden of supporting them became too heavy to bear Those in etc for skin dependent CSS etc for skin dependent JavaScript These can also be customised on a per user by etc This feature has led to a wide variety of user styles becoming that gallery is a good place to ending in php
Definition: skin.txt:62
DatabaseSQLTest\$database
DatabaseTestHelper $database
Definition: DatabaseSQLTest.php:11
DatabaseSQLTest\provideDeleteJoin
static provideDeleteJoin()
Definition: DatabaseSQLTest.php:264
DatabaseSQLTest\testDropTable
testDropTable()
@covers DatabaseBase::dropTable
Definition: DatabaseSQLTest.php:706
DatabaseSQLTest\assertLastSql
assertLastSql( $sqlText)
Definition: DatabaseSQLTest.php:18
DatabaseSQLTest\testInsertSelect
testInsertSelect( $sql, $sqlText)
@dataProvider provideInsertSelect @covers DatabaseBase::insertSelect
Definition: DatabaseSQLTest.php:352
LikeMatch
Used by DatabaseBase::buildLike() to represent characters that have special meaning in SQL LIKE claus...
Definition: DatabaseUtility.php:296
DatabaseSQLTest\provideInsert
static provideInsert()
Definition: DatabaseSQLTest.php:309
DatabaseSQLTest\provideBuildConcat
static provideBuildConcat()
Definition: DatabaseSQLTest.php:604
DatabaseSQLTest\provideSelect
static provideSelect()
Definition: DatabaseSQLTest.php:41
DatabaseSQLTest\testUnionQueries
testUnionQueries( $sql, $sqlText)
@dataProvider provideUnionQueries @covers DatabaseBase::unionQueries
Definition: DatabaseSQLTest.php:652
DatabaseSQLTest\testTransactionCommit
testTransactionCommit()
@covers DatabaseBase::commit
Definition: DatabaseSQLTest.php:688
MediaWikiTestCase
Definition: MediaWikiTestCase.php:6
DatabaseSQLTest\testDeleteJoin
testDeleteJoin( $sql, $sqlText)
@dataProvider provideDeleteJoin @covers DatabaseBase::deleteJoin
Definition: DatabaseSQLTest.php:252
DatabaseSQLTest\testUpsert
testUpsert( $sql, $sqlText)
@dataProvider provideUpsert @covers DatabaseBase::upsert
Definition: DatabaseSQLTest.php:216
array
the array() calling protocol came about after MediaWiki 1.4rc1.
List of Api Query prop modules.
DatabaseSQLTest\provideUpdate
static provideUpdate()
Definition: DatabaseSQLTest.php:142
DatabaseSQLTest\testConditional
testConditional( $sql, $sqlText)
@dataProvider provideConditional @covers DatabaseBase::conditional
Definition: DatabaseSQLTest.php:557
DatabaseSQLTest\testDropNonExistingTable
testDropNonExistingTable()
@covers DatabaseBase::dropTable
Definition: DatabaseSQLTest.php:715
database
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the database
Definition: design.txt:12
DatabaseSQLTest\testInsert
testInsert( $sql, $sqlText)
@dataProvider provideInsert @covers DatabaseBase::insert
Definition: DatabaseSQLTest.php:299
DatabaseSQLTest\provideReplace
static provideReplace()
Definition: DatabaseSQLTest.php:425
DatabaseSQLTest\testUpdate
testUpdate( $sql, $sqlText)
@dataProvider provideUpdate @covers DatabaseBase::update
Definition: DatabaseSQLTest.php:131
DatabaseSQLTest\provideUpsert
static provideUpsert()
Definition: DatabaseSQLTest.php:227
DatabaseSQLTest\testDelete
testDelete( $sql, $sqlText)
@dataProvider provideDelete @covers DatabaseBase::delete
Definition: DatabaseSQLTest.php:183
DatabaseSQLTest\testTransactionRollback
testTransactionRollback()
@covers DatabaseBase::rollback
Definition: DatabaseSQLTest.php:697
DatabaseSQLTest\provideDelete
static provideDelete()
Definition: DatabaseSQLTest.php:192
DatabaseSQLTest\setUp
setUp()
Definition: DatabaseSQLTest.php:13
DatabaseTestHelper
Helper for testing the methods from the DatabaseBase class.
Definition: DatabaseTestHelper.php:7
DatabaseSQLTest\testReplace
testReplace( $sql, $sqlText)
@dataProvider provideReplace @covers DatabaseBase::replace
Definition: DatabaseSQLTest.php:415
DatabaseSQLTest\testNativeReplace
testNativeReplace( $sql, $sqlText)
@dataProvider provideNativeReplace @covers DatabaseBase::nativeReplace
Definition: DatabaseSQLTest.php:530
DatabaseSQLTest
Test the abstract database layer This is a non DBMS depending test.
Definition: DatabaseSQLTest.php:7
DatabaseSQLTest\provideConditional
static provideConditional()
Definition: DatabaseSQLTest.php:565
DatabaseSQLTest\testBuildLike
testBuildLike( $array, $sqlText)
@dataProvider provideBuildLike @covers DatabaseBase::buildLike
Definition: DatabaseSQLTest.php:621
DatabaseSQLTest\testSelect
testSelect( $sql, $sqlText)
@dataProvider provideSelect @covers DatabaseBase::select
Definition: DatabaseSQLTest.php:29
DatabaseSQLTest\provideInsertSelect
static provideInsertSelect()
Definition: DatabaseSQLTest.php:365
DatabaseSQLTest\provideBuildLike
static provideBuildLike()
Definition: DatabaseSQLTest.php:627