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 );
72 * Feeds testAddIdentifierQuotes
74 * Named per bug 20281 convention.
76 function provideDiapers() {
78 // Format: expected, input
81 // Yeah I really hate loosely typed PHP idiocies nowadays
84 // Dear codereviewer, guess what addIdentifierQuotes()
85 // will return with thoses:
89 // We never know what could happen
93 // Whatchout! Should probably use something more meaningful
94 array( "`'`", "'" ), # single quote
95 array( '`"`', '"' ), # double quote
96 array( '````', '`' ), # backtick
97 array( '`’`', '’' ), # apostrophe (look at your encyclopedia)
99 // sneaky NUL bytes are lurking everywhere
101 array( '`xyzzy`', "\0x\0y\0z\0z\0y\0" ),
105 self
::createUnicodeString( '`\u0001a\uFFFFb`' ),
106 self
::createUnicodeString( '\u0001a\uFFFFb' )
109 self
::createUnicodeString( '`\u0001\uFFFF`' ),
110 self
::createUnicodeString( '\u0001\u0000\uFFFF\u0000' )
113 array( '`メインページ`', 'メインページ' ),
114 array( '`Басты_бет`', 'Басты_бет' ),
117 array( '`Alix`', 'Alix' ), # while( ! $recovered ) { sleep(); }
118 array( '`Backtick: ```', 'Backtick: `' ),
119 array( '`This is a test`', 'This is a test' ),
123 private static function createUnicodeString( $str ) {
124 return json_decode( '"' . $str . '"' );
127 function getMockForViews() {
128 $db = $this->getMockBuilder( 'DatabaseMysql' )
129 ->disableOriginalConstructor()
130 ->setMethods( array( 'fetchRow', 'query' ) )
133 $db->expects( $this->any() )
135 ->with( $this->anything() )
137 $this->returnValue( null )
140 $db->expects( $this->any() )
141 ->method( 'fetchRow' )
142 ->with( $this->anything() )
143 ->will( $this->onConsecutiveCalls(
144 array( 'Tables_in_' => 'view1' ),
145 array( 'Tables_in_' => 'view2' ),
146 array( 'Tables_in_' => 'myview' ),
152 * @covers DatabaseMysqlBase::listViews
154 function testListviews() {
155 $db = $this->getMockForViews();
157 // The first call populate an internal cache of views
158 $this->assertEquals( array( 'view1', 'view2', 'myview' ),
160 $this->assertEquals( array( 'view1', 'view2', 'myview' ),
164 $this->assertEquals( array( 'view1', 'view2' ),
165 $db->listViews( 'view' ) );
166 $this->assertEquals( array( 'myview' ),
167 $db->listViews( 'my' ) );
168 $this->assertEquals( array(),
169 $db->listViews( 'UNUSED_PREFIX' ) );
170 $this->assertEquals( array( 'view1', 'view2', 'myview' ),
171 $db->listViews( '' ) );
175 * @covers DatabaseMysqlBase::isView
176 * @dataProvider provideViewExistanceChecks
178 function testIsView( $isView, $viewName ) {
179 $db = $this->getMockForViews();
183 $this->assertTrue( $db->isView( $viewName ),
184 "$viewName should be considered a view" );
188 $this->assertFalse( $db->isView( $viewName ),
189 "$viewName has not been defined as a view" );
195 function provideViewExistanceChecks() {
197 // format: whether it is a view, view name
198 array( true, 'view1' ),
199 array( true, 'view2' ),
200 array( true, 'myview' ),
202 array( false, 'user' ),
204 array( false, 'view10' ),
205 array( false, 'my' ),
206 array( false, 'OH_MY_GOD' ), # they killed kenny!