3 use Wikimedia\Rdbms\LikeMatch
;
6 * Test the parts of the Database abstract class that deal
7 * with creating SQL text.
9 class DatabaseSQLTest
extends PHPUnit_Framework_TestCase
{
10 /** @var DatabaseTestHelper */
13 protected function setUp() {
15 $this->database
= new DatabaseTestHelper( __CLASS__
, [ 'cliMode' => true ] );
18 protected function assertLastSql( $sqlText ) {
21 $this->database
->getLastSqls()
25 protected function assertLastSqlDb( $sqlText, $db ) {
26 $this->assertEquals( $sqlText, $db->getLastSqls() );
30 * @dataProvider provideSelect
31 * @covers Wikimedia\Rdbms\Database::select
33 public function testSelect( $sql, $sqlText ) {
34 $this->database
->select(
37 isset( $sql['conds'] ) ?
$sql['conds'] : [],
39 isset( $sql['options'] ) ?
$sql['options'] : [],
40 isset( $sql['join_conds'] ) ?
$sql['join_conds'] : []
42 $this->assertLastSql( $sqlText );
45 public static function provideSelect() {
50 'fields' => [ 'field', 'alias' => 'field2' ],
51 'conds' => [ 'alias' => 'text' ],
53 "SELECT field,field2 AS alias " .
55 "WHERE alias = 'text'"
60 'fields' => [ 'field', 'alias' => 'field2' ],
61 'conds' => [ 'alias' => 'text' ],
62 'options' => [ 'LIMIT' => 1, 'ORDER BY' => 'field' ],
64 "SELECT field,field2 AS alias " .
66 "WHERE alias = 'text' " .
72 'tables' => [ 'table', 't2' => 'table2' ],
73 'fields' => [ 'tid', 'field', 'alias' => 'field2', 't2.id' ],
74 'conds' => [ 'alias' => 'text' ],
75 'options' => [ 'LIMIT' => 1, 'ORDER BY' => 'field' ],
76 'join_conds' => [ 't2' => [
77 'LEFT JOIN', 'tid = t2.id'
80 "SELECT tid,field,field2 AS alias,t2.id " .
81 "FROM table LEFT JOIN table2 t2 ON ((tid = t2.id)) " .
82 "WHERE alias = 'text' " .
88 'tables' => [ 'table', 't2' => 'table2' ],
89 'fields' => [ 'tid', 'field', 'alias' => 'field2', 't2.id' ],
90 'conds' => [ 'alias' => 'text' ],
91 'options' => [ 'LIMIT' => 1, 'GROUP BY' => 'field', 'HAVING' => 'COUNT(*) > 1' ],
92 'join_conds' => [ 't2' => [
93 'LEFT JOIN', 'tid = t2.id'
96 "SELECT tid,field,field2 AS alias,t2.id " .
97 "FROM table LEFT JOIN table2 t2 ON ((tid = t2.id)) " .
98 "WHERE alias = 'text' " .
99 "GROUP BY field HAVING COUNT(*) > 1 " .
104 'tables' => [ 'table', 't2' => 'table2' ],
105 'fields' => [ 'tid', 'field', 'alias' => 'field2', 't2.id' ],
106 'conds' => [ 'alias' => 'text' ],
109 'GROUP BY' => [ 'field', 'field2' ],
110 'HAVING' => [ 'COUNT(*) > 1', 'field' => 1 ]
112 'join_conds' => [ 't2' => [
113 'LEFT JOIN', 'tid = t2.id'
116 "SELECT tid,field,field2 AS alias,t2.id " .
117 "FROM table LEFT JOIN table2 t2 ON ((tid = t2.id)) " .
118 "WHERE alias = 'text' " .
119 "GROUP BY field,field2 HAVING (COUNT(*) > 1) AND field = '1' " .
124 'tables' => [ 'table' ],
125 'fields' => [ 'alias' => 'field' ],
126 'conds' => [ 'alias' => [ 1, 2, 3, 4 ] ],
128 "SELECT field AS alias " .
130 "WHERE alias IN ('1','2','3','4')"
136 * @dataProvider provideUpdate
137 * @covers Wikimedia\Rdbms\Database::update
139 public function testUpdate( $sql, $sqlText ) {
140 $this->database
->update(
145 isset( $sql['options'] ) ?
$sql['options'] : []
147 $this->assertLastSql( $sqlText );
150 public static function provideUpdate() {
155 'values' => [ 'field' => 'text', 'field2' => 'text2' ],
156 'conds' => [ 'alias' => 'text' ],
159 "SET field = 'text'" .
160 ",field2 = 'text2' " .
161 "WHERE alias = 'text'"
166 'values' => [ 'field = other', 'field2' => 'text2' ],
167 'conds' => [ 'id' => '1' ],
170 "SET field = other" .
171 ",field2 = 'text2' " .
177 'values' => [ 'field = other', 'field2' => 'text2' ],
181 "SET field = other" .
188 * @dataProvider provideDelete
189 * @covers Wikimedia\Rdbms\Database::delete
191 public function testDelete( $sql, $sqlText ) {
192 $this->database
->delete(
197 $this->assertLastSql( $sqlText );
200 public static function provideDelete() {
205 'conds' => [ 'alias' => 'text' ],
207 "DELETE FROM table " .
208 "WHERE alias = 'text'"
221 * @dataProvider provideUpsert
222 * @covers Wikimedia\Rdbms\Database::upsert
224 public function testUpsert( $sql, $sqlText ) {
225 $this->database
->upsert(
228 $sql['uniqueIndexes'],
232 $this->assertLastSql( $sqlText );
235 public static function provideUpsert() {
239 'table' => 'upsert_table',
240 'rows' => [ 'field' => 'text', 'field2' => 'text2' ],
241 'uniqueIndexes' => [ 'field' ],
242 'set' => [ 'field' => 'set' ],
245 "UPDATE upsert_table " .
246 "SET field = 'set' " .
247 "WHERE ((field = 'text')); " .
248 "INSERT IGNORE INTO upsert_table " .
250 "VALUES ('text','text2'); " .
257 * @dataProvider provideDeleteJoin
258 * @covers Wikimedia\Rdbms\Database::deleteJoin
260 public function testDeleteJoin( $sql, $sqlText ) {
261 $this->database
->deleteJoin(
269 $this->assertLastSql( $sqlText );
272 public static function provideDeleteJoin() {
276 'delTable' => 'table',
277 'joinTable' => 'table_join',
279 'joinVar' => 'field_join',
280 'conds' => [ 'alias' => 'text' ],
282 "DELETE FROM table " .
284 "SELECT field_join FROM table_join WHERE alias = 'text'" .
289 'delTable' => 'table',
290 'joinTable' => 'table_join',
292 'joinVar' => 'field_join',
295 "DELETE FROM table " .
297 "SELECT field_join FROM table_join " .
304 * @dataProvider provideInsert
305 * @covers Wikimedia\Rdbms\Database::insert
307 public function testInsert( $sql, $sqlText ) {
308 $this->database
->insert(
312 isset( $sql['options'] ) ?
$sql['options'] : []
314 $this->assertLastSql( $sqlText );
317 public static function provideInsert() {
322 'rows' => [ 'field' => 'text', 'field2' => 2 ],
324 "INSERT INTO table " .
326 "VALUES ('text','2')"
331 'rows' => [ 'field' => 'text', 'field2' => 2 ],
332 'options' => 'IGNORE',
334 "INSERT IGNORE INTO table " .
336 "VALUES ('text','2')"
342 [ 'field' => 'text', 'field2' => 2 ],
343 [ 'field' => 'multi', 'field2' => 3 ],
345 'options' => 'IGNORE',
347 "INSERT IGNORE INTO table " .
357 * @dataProvider provideInsertSelect
358 * @covers Wikimedia\Rdbms\Database::insertSelect
360 public function testInsertSelect( $sql, $sqlTextNative, $sqlSelect, $sqlInsert ) {
361 $this->database
->insertSelect(
367 isset( $sql['insertOptions'] ) ?
$sql['insertOptions'] : [],
368 isset( $sql['selectOptions'] ) ?
$sql['selectOptions'] : [],
369 isset( $sql['selectJoinConds'] ) ?
$sql['selectJoinConds'] : []
371 $this->assertLastSql( $sqlTextNative );
373 $dbWeb = new DatabaseTestHelper( __CLASS__
, [ 'cliMode' => false ] );
374 $dbWeb->forceNextResult( [
375 array_flip( array_keys( $sql['varMap'] ) )
377 $dbWeb->insertSelect(
383 isset( $sql['insertOptions'] ) ?
$sql['insertOptions'] : [],
384 isset( $sql['selectOptions'] ) ?
$sql['selectOptions'] : [],
385 isset( $sql['selectJoinConds'] ) ?
$sql['selectJoinConds'] : []
387 $this->assertLastSqlDb( implode( '; ', [ $sqlSelect, $sqlInsert ] ), $dbWeb );
390 public static function provideInsertSelect() {
394 'destTable' => 'insert_table',
395 'srcTable' => 'select_table',
396 'varMap' => [ 'field_insert' => 'field_select', 'field' => 'field2' ],
399 "INSERT INTO insert_table " .
400 "(field_insert,field) " .
401 "SELECT field_select,field2 " .
402 "FROM select_table WHERE *",
403 "SELECT field_select AS field_insert,field2 AS field " .
404 "FROM select_table WHERE * FOR UPDATE",
405 "INSERT INTO insert_table (field_insert,field) VALUES ('0','1')"
409 'destTable' => 'insert_table',
410 'srcTable' => 'select_table',
411 'varMap' => [ 'field_insert' => 'field_select', 'field' => 'field2' ],
412 'conds' => [ 'field' => 2 ],
414 "INSERT INTO insert_table " .
415 "(field_insert,field) " .
416 "SELECT field_select,field2 " .
417 "FROM select_table " .
419 "SELECT field_select AS field_insert,field2 AS field FROM " .
420 "select_table WHERE field = '2' FOR UPDATE",
421 "INSERT INTO insert_table (field_insert,field) VALUES ('0','1')"
425 'destTable' => 'insert_table',
426 'srcTable' => 'select_table',
427 'varMap' => [ 'field_insert' => 'field_select', 'field' => 'field2' ],
428 'conds' => [ 'field' => 2 ],
429 'insertOptions' => 'IGNORE',
430 'selectOptions' => [ 'ORDER BY' => 'field' ],
432 "INSERT IGNORE INTO insert_table " .
433 "(field_insert,field) " .
434 "SELECT field_select,field2 " .
435 "FROM select_table " .
436 "WHERE field = '2' " .
438 "SELECT field_select AS field_insert,field2 AS field " .
439 "FROM select_table WHERE field = '2' ORDER BY field FOR UPDATE",
440 "INSERT IGNORE INTO insert_table (field_insert,field) VALUES ('0','1')"
444 'destTable' => 'insert_table',
445 'srcTable' => [ 'select_table1', 'select_table2' ],
446 'varMap' => [ 'field_insert' => 'field_select', 'field' => 'field2' ],
447 'conds' => [ 'field' => 2 ],
448 'selectOptions' => [ 'ORDER BY' => 'field', 'FORCE INDEX' => [ 'select_table1' => 'index1' ] ],
449 'selectJoinConds' => [
450 'select_table2' => [ 'LEFT JOIN', [ 'select_table1.foo = select_table2.bar' ] ],
453 "INSERT INTO insert_table " .
454 "(field_insert,field) " .
455 "SELECT field_select,field2 " .
456 "FROM select_table1 LEFT JOIN select_table2 ON ((select_table1.foo = select_table2.bar)) " .
457 "WHERE field = '2' " .
459 "SELECT field_select AS field_insert,field2 AS field " .
460 "FROM select_table1 LEFT JOIN select_table2 ON ((select_table1.foo = select_table2.bar)) " .
461 "WHERE field = '2' ORDER BY field FOR UPDATE",
462 "INSERT INTO insert_table (field_insert,field) VALUES ('0','1')"
468 * @dataProvider provideReplace
469 * @covers Wikimedia\Rdbms\Database::replace
471 public function testReplace( $sql, $sqlText ) {
472 $this->database
->replace(
474 $sql['uniqueIndexes'],
478 $this->assertLastSql( $sqlText );
481 public static function provideReplace() {
485 'table' => 'replace_table',
486 'uniqueIndexes' => [ 'field' ],
487 'rows' => [ 'field' => 'text', 'field2' => 'text2' ],
489 "DELETE FROM replace_table " .
490 "WHERE ( field='text' ); " .
491 "INSERT INTO replace_table " .
493 "VALUES ('text','text2')"
497 'table' => 'module_deps',
498 'uniqueIndexes' => [ [ 'md_module', 'md_skin' ] ],
500 'md_module' => 'module',
505 "DELETE FROM module_deps " .
506 "WHERE ( md_module='module' AND md_skin='skin' ); " .
507 "INSERT INTO module_deps " .
508 "(md_module,md_skin,md_deps) " .
509 "VALUES ('module','skin','deps')"
513 'table' => 'module_deps',
514 'uniqueIndexes' => [ [ 'md_module', 'md_skin' ] ],
517 'md_module' => 'module',
521 'md_module' => 'module2',
522 'md_skin' => 'skin2',
523 'md_deps' => 'deps2',
527 "DELETE FROM module_deps " .
528 "WHERE ( md_module='module' AND md_skin='skin' ); " .
529 "INSERT INTO module_deps " .
530 "(md_module,md_skin,md_deps) " .
531 "VALUES ('module','skin','deps'); " .
532 "DELETE FROM module_deps " .
533 "WHERE ( md_module='module2' AND md_skin='skin2' ); " .
534 "INSERT INTO module_deps " .
535 "(md_module,md_skin,md_deps) " .
536 "VALUES ('module2','skin2','deps2')"
540 'table' => 'module_deps',
541 'uniqueIndexes' => [ 'md_module', 'md_skin' ],
544 'md_module' => 'module',
548 'md_module' => 'module2',
549 'md_skin' => 'skin2',
550 'md_deps' => 'deps2',
554 "DELETE FROM module_deps " .
555 "WHERE ( md_module='module' ) OR ( md_skin='skin' ); " .
556 "INSERT INTO module_deps " .
557 "(md_module,md_skin,md_deps) " .
558 "VALUES ('module','skin','deps'); " .
559 "DELETE FROM module_deps " .
560 "WHERE ( md_module='module2' ) OR ( md_skin='skin2' ); " .
561 "INSERT INTO module_deps " .
562 "(md_module,md_skin,md_deps) " .
563 "VALUES ('module2','skin2','deps2')"
567 'table' => 'module_deps',
568 'uniqueIndexes' => [],
570 'md_module' => 'module',
575 "INSERT INTO module_deps " .
576 "(md_module,md_skin,md_deps) " .
577 "VALUES ('module','skin','deps')"
583 * @dataProvider provideNativeReplace
584 * @covers Wikimedia\Rdbms\Database::nativeReplace
586 public function testNativeReplace( $sql, $sqlText ) {
587 $this->database
->nativeReplace(
592 $this->assertLastSql( $sqlText );
595 public static function provideNativeReplace() {
599 'table' => 'replace_table',
600 'rows' => [ 'field' => 'text', 'field2' => 'text2' ],
602 "REPLACE INTO replace_table " .
604 "VALUES ('text','text2')"
610 * @dataProvider provideConditional
611 * @covers Wikimedia\Rdbms\Database::conditional
613 public function testConditional( $sql, $sqlText ) {
614 $this->assertEquals( trim( $this->database
->conditional(
621 public static function provideConditional() {
625 'conds' => [ 'field' => 'text' ],
629 "(CASE WHEN field = 'text' THEN 1 ELSE NULL END)"
633 'conds' => [ 'field' => 'text', 'field2' => 'anothertext' ],
637 "(CASE WHEN field = 'text' AND field2 = 'anothertext' THEN 1 ELSE NULL END)"
641 'conds' => 'field=1',
645 "(CASE WHEN field=1 THEN 1 ELSE NULL END)"
651 * @dataProvider provideBuildConcat
652 * @covers Wikimedia\Rdbms\Database::buildConcat
654 public function testBuildConcat( $stringList, $sqlText ) {
655 $this->assertEquals( trim( $this->database
->buildConcat(
660 public static function provideBuildConcat() {
663 [ 'field', 'field2' ],
664 "CONCAT(field,field2)"
667 [ "'test'", 'field2' ],
668 "CONCAT('test',field2)"
674 * @dataProvider provideBuildLike
675 * @covers Wikimedia\Rdbms\Database::buildLike
677 public function testBuildLike( $array, $sqlText ) {
678 $this->assertEquals( trim( $this->database
->buildLike(
683 public static function provideBuildLike() {
687 "LIKE 'text' ESCAPE '`'"
690 [ 'text', new LikeMatch( '%' ) ],
691 "LIKE 'text%' ESCAPE '`'"
694 [ 'text', new LikeMatch( '%' ), 'text2' ],
695 "LIKE 'text%text2' ESCAPE '`'"
698 [ 'text', new LikeMatch( '_' ) ],
699 "LIKE 'text_' ESCAPE '`'"
703 "LIKE 'more`_text' ESCAPE '`'"
706 [ 'C:\\Windows\\', new LikeMatch( '%' ) ],
707 "LIKE 'C:\\Windows\\%' ESCAPE '`'"
710 [ 'accent`_test`', new LikeMatch( '%' ) ],
711 "LIKE 'accent```_test``%' ESCAPE '`'"
717 * @dataProvider provideUnionQueries
718 * @covers Wikimedia\Rdbms\Database::unionQueries
720 public function testUnionQueries( $sql, $sqlText ) {
721 $this->assertEquals( trim( $this->database
->unionQueries(
727 public static function provideUnionQueries() {
731 'sqls' => [ 'RAW SQL', 'RAW2SQL' ],
734 "(RAW SQL) UNION ALL (RAW2SQL)"
738 'sqls' => [ 'RAW SQL', 'RAW2SQL' ],
741 "(RAW SQL) UNION (RAW2SQL)"
745 'sqls' => [ 'RAW SQL', 'RAW2SQL', 'RAW3SQL' ],
748 "(RAW SQL) UNION (RAW2SQL) UNION (RAW3SQL)"
754 * @dataProvider provideUnionConditionPermutations
755 * @covers Wikimedia\Rdbms\Database::unionConditionPermutations
757 public function testUnionConditionPermutations( $params, $expect ) {
758 if ( isset( $params['unionSupportsOrderAndLimit'] ) ) {
759 $this->database
->setUnionSupportsOrderAndLimit( $params['unionSupportsOrderAndLimit'] );
762 $sql = trim( $this->database
->unionConditionPermutations(
765 $params['permute_conds'],
766 isset( $params['extra_conds'] ) ?
$params['extra_conds'] : '',
768 isset( $params['options'] ) ?
$params['options'] : [],
769 isset( $params['join_conds'] ) ?
$params['join_conds'] : []
771 $this->assertEquals( $expect, $sql );
774 public static function provideUnionConditionPermutations() {
776 // @codingStandardsIgnoreStart Generic.Files.LineLength.TooLong
779 'table' => [ 'table1', 'table2' ],
780 'vars' => [ 'field1', 'alias' => 'field2' ],
782 'field3' => [ 1, 2, 3 ],
783 'duplicates' => [ 4, 5, 4 ],
787 'extra_conds' => 'table2.bar > 23',
789 'ORDER BY' => [ 'field1', 'alias' ],
790 'INNER ORDER BY' => [ 'field1', 'field2' ],
794 'table2' => [ 'JOIN', 'table1.foo_id = table2.foo_id' ],
797 "(SELECT field1,field2 AS alias FROM table1 JOIN table2 ON ((table1.foo_id = table2.foo_id)) WHERE field3 = '1' AND duplicates = '4' AND single = '0' AND (table2.bar > 23) ORDER BY field1,field2 LIMIT 100 ) UNION ALL " .
798 "(SELECT field1,field2 AS alias FROM table1 JOIN table2 ON ((table1.foo_id = table2.foo_id)) WHERE field3 = '1' AND duplicates = '5' AND single = '0' AND (table2.bar > 23) ORDER BY field1,field2 LIMIT 100 ) UNION ALL " .
799 "(SELECT field1,field2 AS alias FROM table1 JOIN table2 ON ((table1.foo_id = table2.foo_id)) WHERE field3 = '2' AND duplicates = '4' AND single = '0' AND (table2.bar > 23) ORDER BY field1,field2 LIMIT 100 ) UNION ALL " .
800 "(SELECT field1,field2 AS alias FROM table1 JOIN table2 ON ((table1.foo_id = table2.foo_id)) WHERE field3 = '2' AND duplicates = '5' AND single = '0' AND (table2.bar > 23) ORDER BY field1,field2 LIMIT 100 ) UNION ALL " .
801 "(SELECT field1,field2 AS alias FROM table1 JOIN table2 ON ((table1.foo_id = table2.foo_id)) WHERE field3 = '3' AND duplicates = '4' AND single = '0' AND (table2.bar > 23) ORDER BY field1,field2 LIMIT 100 ) UNION ALL " .
802 "(SELECT field1,field2 AS alias FROM table1 JOIN table2 ON ((table1.foo_id = table2.foo_id)) WHERE field3 = '3' AND duplicates = '5' AND single = '0' AND (table2.bar > 23) ORDER BY field1,field2 LIMIT 100 ) " .
803 "ORDER BY field1,alias LIMIT 100"
808 'vars' => [ 'foo_id' ],
810 'bar' => [ 1, 2, 3 ],
812 'extra_conds' => [ 'baz' => null ],
815 'ORDER BY' => [ 'foo_id' ],
819 "(SELECT foo_id FROM foo WHERE bar = '1' AND baz IS NULL ORDER BY foo_id LIMIT 25 ) UNION " .
820 "(SELECT foo_id FROM foo WHERE bar = '2' AND baz IS NULL ORDER BY foo_id LIMIT 25 ) UNION " .
821 "(SELECT foo_id FROM foo WHERE bar = '3' AND baz IS NULL ORDER BY foo_id LIMIT 25 ) " .
822 "ORDER BY foo_id LIMIT 25"
827 'vars' => [ 'foo_id' ],
829 'bar' => [ 1, 2, 3 ],
831 'extra_conds' => [ 'baz' => null ],
834 'ORDER BY' => [ 'foo_id' ],
837 'unionSupportsOrderAndLimit' => false,
839 "(SELECT foo_id FROM foo WHERE bar = '1' AND baz IS NULL ) UNION " .
840 "(SELECT foo_id FROM foo WHERE bar = '2' AND baz IS NULL ) UNION " .
841 "(SELECT foo_id FROM foo WHERE bar = '3' AND baz IS NULL ) " .
842 "ORDER BY foo_id LIMIT 25"
847 'vars' => [ 'foo_id' ],
848 'permute_conds' => [],
849 'extra_conds' => [ 'baz' => null ],
851 'ORDER BY' => [ 'foo_id' ],
855 "SELECT foo_id FROM foo WHERE baz IS NULL ORDER BY foo_id LIMIT 25"
860 'vars' => [ 'foo_id' ],
864 'extra_conds' => [ 'baz' => null ],
866 'ORDER BY' => [ 'foo_id' ],
870 "SELECT foo_id FROM foo WHERE baz IS NULL ORDER BY foo_id LIMIT 25"
875 'vars' => [ 'foo_id' ],
880 'ORDER BY' => [ 'foo_id' ],
885 "SELECT foo_id FROM foo WHERE bar = '1' ORDER BY foo_id LIMIT 150,25"
890 'vars' => [ 'foo_id' ],
891 'permute_conds' => [],
892 'extra_conds' => [ 'baz' => null ],
894 'ORDER BY' => [ 'foo_id' ],
897 'INNER ORDER BY' => [ 'bar_id' ],
900 "(SELECT foo_id FROM foo WHERE baz IS NULL ORDER BY bar_id LIMIT 175 ) ORDER BY foo_id LIMIT 150,25"
905 'vars' => [ 'foo_id' ],
906 'permute_conds' => [],
907 'extra_conds' => [ 'baz' => null ],
909 'ORDER BY' => [ 'foo_id' ],
912 'INNER ORDER BY' => [ 'bar_id' ],
914 'unionSupportsOrderAndLimit' => false,
916 "SELECT foo_id FROM foo WHERE baz IS NULL ORDER BY foo_id LIMIT 150,25"
918 // @codingStandardsIgnoreEnd
923 * @covers Wikimedia\Rdbms\Database::commit
925 public function testTransactionCommit() {
926 $this->database
->begin( __METHOD__
);
927 $this->database
->commit( __METHOD__
);
928 $this->assertLastSql( 'BEGIN; COMMIT' );
932 * @covers Wikimedia\Rdbms\Database::rollback
934 public function testTransactionRollback() {
935 $this->database
->begin( __METHOD__
);
936 $this->database
->rollback( __METHOD__
);
937 $this->assertLastSql( 'BEGIN; ROLLBACK' );
941 * @covers Wikimedia\Rdbms\Database::dropTable
943 public function testDropTable() {
944 $this->database
->setExistingTables( [ 'table' ] );
945 $this->database
->dropTable( 'table', __METHOD__
);
946 $this->assertLastSql( 'DROP TABLE table CASCADE' );
950 * @covers Wikimedia\Rdbms\Database::dropTable
952 public function testDropNonExistingTable() {
954 $this->database
->dropTable( 'non_existing', __METHOD__
)
959 * @dataProvider provideMakeList
960 * @covers Wikimedia\Rdbms\Database::makeList
962 public function testMakeList( $list, $mode, $sqlText ) {
963 $this->assertEquals( trim( $this->database
->makeList(
968 public static function provideMakeList() {
971 [ 'value', 'value2' ],
976 [ 'field', 'field2' ],
981 [ 'field' => 'value', 'field2' => 'value2' ],
983 "field = 'value' AND field2 = 'value2'"
986 [ 'field' => null, "field2 != 'value2'" ],
988 "field IS NULL AND (field2 != 'value2')"
991 [ 'field' => [ 'value', null, 'value2' ], 'field2' => 'value2' ],
993 "(field IN ('value','value2') OR field IS NULL) AND field2 = 'value2'"
996 [ 'field' => [ null ], 'field2' => null ],
998 "field IS NULL AND field2 IS NULL"
1001 [ 'field' => 'value', 'field2' => 'value2' ],
1003 "field = 'value' OR field2 = 'value2'"
1006 [ 'field' => 'value', 'field2' => null ],
1008 "field = 'value' OR field2 IS NULL"
1011 [ 'field' => [ 'value', 'value2' ], 'field2' => [ 'value' ] ],
1013 "field IN ('value','value2') OR field2 = 'value'"
1016 [ 'field' => [ null, 'value', null, 'value2' ], "field2 != 'value2'" ],
1018 "(field IN ('value','value2') OR field IS NULL) OR (field2 != 'value2')"
1021 [ 'field' => 'value', 'field2' => 'value2' ],
1023 "field = 'value',field2 = 'value2'"
1026 [ 'field' => 'value', 'field2' => null ],
1028 "field = 'value',field2 = NULL"
1031 [ 'field' => 'value', "field2 != 'value2'" ],
1033 "field = 'value',field2 != 'value2'"
1038 public function testSessionTempTables() {
1039 $temp1 = $this->database
->tableName( 'tmp_table_1' );
1040 $temp2 = $this->database
->tableName( 'tmp_table_2' );
1041 $temp3 = $this->database
->tableName( 'tmp_table_3' );
1043 $this->database
->query( "CREATE TEMPORARY TABLE $temp1 LIKE orig_tbl", __METHOD__
);
1044 $this->database
->query( "CREATE TEMPORARY TABLE $temp2 LIKE orig_tbl", __METHOD__
);
1045 $this->database
->query( "CREATE TEMPORARY TABLE $temp3 LIKE orig_tbl", __METHOD__
);
1047 $this->assertTrue( $this->database
->tableExists( "tmp_table_1", __METHOD__
) );
1048 $this->assertTrue( $this->database
->tableExists( "tmp_table_2", __METHOD__
) );
1049 $this->assertTrue( $this->database
->tableExists( "tmp_table_3", __METHOD__
) );
1051 $this->database
->dropTable( 'tmp_table_1', __METHOD__
);
1052 $this->database
->dropTable( 'tmp_table_2', __METHOD__
);
1053 $this->database
->dropTable( 'tmp_table_3', __METHOD__
);
1055 $this->assertFalse( $this->database
->tableExists( "tmp_table_1", __METHOD__
) );
1056 $this->assertFalse( $this->database
->tableExists( "tmp_table_2", __METHOD__
) );
1057 $this->assertFalse( $this->database
->tableExists( "tmp_table_3", __METHOD__
) );
1059 $this->database
->query( "CREATE TEMPORARY TABLE tmp_table_1 LIKE orig_tbl", __METHOD__
);
1060 $this->database
->query( "CREATE TEMPORARY TABLE 'tmp_table_2' LIKE orig_tbl", __METHOD__
);
1061 $this->database
->query( "CREATE TEMPORARY TABLE `tmp_table_3` LIKE orig_tbl", __METHOD__
);
1063 $this->assertTrue( $this->database
->tableExists( "tmp_table_1", __METHOD__
) );
1064 $this->assertTrue( $this->database
->tableExists( "tmp_table_2", __METHOD__
) );
1065 $this->assertTrue( $this->database
->tableExists( "tmp_table_3", __METHOD__
) );
1067 $this->database
->query( "DROP TEMPORARY TABLE tmp_table_1 LIKE orig_tbl", __METHOD__
);
1068 $this->database
->query( "DROP TEMPORARY TABLE 'tmp_table_2' LIKE orig_tbl", __METHOD__
);
1069 $this->database
->query( "DROP TABLE `tmp_table_3` LIKE orig_tbl", __METHOD__
);
1071 $this->assertFalse( $this->database
->tableExists( "tmp_table_1", __METHOD__
) );
1072 $this->assertFalse( $this->database
->tableExists( "tmp_table_2", __METHOD__
) );
1073 $this->assertFalse( $this->database
->tableExists( "tmp_table_3", __METHOD__
) );