3 * Holds tests for DatabaseMysqlBase MediaWiki class.
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 2 of the License, or
9 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License along
17 * with this program; if not, write to the Free Software Foundation, Inc.,
18 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
19 * http://www.gnu.org/copyleft/gpl.html
22 * @author Antoine Musso
24 * @copyright © 2013 Antoine Musso
25 * @copyright © 2013 Bryan Davis
26 * @copyright © 2013 Wikimedia Foundation Inc.
30 * Fake class around abstract class so we can call concrete methods.
32 class FakeDatabaseMysqlBase
extends DatabaseMysqlBase
{
34 function __construct() {}
35 protected function closeConnection() {}
36 protected function doQuery( $sql ) {}
39 protected function mysqlConnect( $realServer ) {}
40 protected function mysqlSetCharset( $charset ) {}
41 protected function mysqlFreeResult( $res ) {}
42 protected function mysqlFetchObject( $res ) {}
43 protected function mysqlFetchArray( $res ) {}
44 protected function mysqlNumRows( $res ) {}
45 protected function mysqlNumFields( $res ) {}
46 protected function mysqlFieldName( $res, $n ) {}
47 protected function mysqlDataSeek( $res, $row ) {}
48 protected function mysqlError( $conn = null ) {}
49 protected function mysqlFetchField( $res, $n ) {}
50 protected function mysqlPing() {}
52 // From interface DatabaseType
53 function insertId() {}
54 function lastErrno() {}
55 function affectedRows() {}
56 function getServerVersion() {}
59 class DatabaseMysqlBaseTest
extends MediaWikiTestCase
{
62 * @dataProvider provideDiapers
63 * @covers DatabaseMysqlBase::addIdentifierQuotes
65 public function testAddIdentifierQuotes( $expected, $in ) {
66 $db = new FakeDatabaseMysqlBase();
67 $quoted = $db->addIdentifierQuotes( $in );
68 $this->assertEquals( $expected, $quoted );
73 * Feeds testAddIdentifierQuotes
75 * Named per bug 20281 convention.
77 function provideDiapers() {
79 // Format: expected, input
82 // Yeah I really hate loosely typed PHP idiocies nowadays
85 // Dear codereviewer, guess what addIdentifierQuotes()
86 // will return with thoses:
90 // We never know what could happen
94 // Whatchout! Should probably use something more meaningful
95 array( "`'`", "'" ), # single quote
96 array( '`"`', '"' ), # double quote
97 array( '````', '`' ), # backtick
98 array( '`’`', '’' ), # apostrophe (look at your encyclopedia)
100 // sneaky NUL bytes are lurking everywhere
102 array( '`xyzzy`', "\0x\0y\0z\0z\0y\0" ),
106 self
::createUnicodeString( '`\u0001a\uFFFFb`' ),
107 self
::createUnicodeString( '\u0001a\uFFFFb' )
110 self
::createUnicodeString( '`\u0001\uFFFF`' ),
111 self
::createUnicodeString( '\u0001\u0000\uFFFF\u0000' )
114 array( '`メインページ`', 'メインページ' ),
115 array( '`Басты_бет`', 'Басты_бет' ),
118 array( '`Alix`', 'Alix' ), # while( ! $recovered ) { sleep(); }
119 array( '`Backtick: ```', 'Backtick: `' ),
120 array( '`This is a test`', 'This is a test' ),
124 private static function createUnicodeString( $str ) {
125 return json_decode( '"' . $str . '"' );
128 function getMockForViews() {
129 $db = $this->getMockBuilder( 'DatabaseMysql' )
130 ->disableOriginalConstructor()
131 ->setMethods( array( 'fetchRow', 'query' ) )
134 $db->expects( $this->any() )
136 ->with( $this->anything() )
138 $this->returnValue( null )
141 $db->expects( $this->any() )
142 ->method( 'fetchRow' )
143 ->with( $this->anything() )
144 ->will( $this->onConsecutiveCalls(
145 array( 'Tables_in_' => 'view1' ),
146 array( 'Tables_in_' => 'view2' ),
147 array( 'Tables_in_' => 'myview' ),
153 * @covers DatabaseMysqlBase::listViews
155 function testListviews() {
156 $db = $this->getMockForViews();
158 // The first call populate an internal cache of views
159 $this->assertEquals( array( 'view1', 'view2', 'myview' ),
161 $this->assertEquals( array( 'view1', 'view2', 'myview' ),
165 $this->assertEquals( array( 'view1', 'view2' ),
166 $db->listViews( 'view' ) );
167 $this->assertEquals( array( 'myview' ),
168 $db->listViews( 'my' ) );
169 $this->assertEquals( array(),
170 $db->listViews( 'UNUSED_PREFIX' ) );
171 $this->assertEquals( array( 'view1', 'view2', 'myview' ),
172 $db->listViews( '' ) );
176 * @covers DatabaseMysqlBase::isView
177 * @dataProvider provideViewExistanceChecks
179 function testIsView( $isView, $viewName ) {
180 $db = $this->getMockForViews();
184 $this->assertTrue( $db->isView( $viewName ),
185 "$viewName should be considered a view" );
189 $this->assertFalse( $db->isView( $viewName ),
190 "$viewName has not been defined as a view" );
196 function provideViewExistanceChecks() {
198 // format: whether it is a view, view name
199 array( true, 'view1' ),
200 array( true, 'view2' ),
201 array( true, 'myview' ),
203 array( false, 'user' ),
205 array( false, 'view10' ),
206 array( false, 'my' ),
207 array( false, 'OH_MY_GOD' ), # they killed kenny!