Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F7412595
UnionQueryBuilderTest.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
2 KB
Referenced Files
None
Subscribers
None
UnionQueryBuilderTest.php
View Options
<?php
namespace
Wikimedia\Tests\Rdbms
;
use
DatabaseTestHelper
;
use
Wikimedia\Rdbms\IResultWrapper
;
use
Wikimedia\Rdbms\UnionQueryBuilder
;
/**
* @covers \Wikimedia\Rdbms\UnionQueryBuilder
*/
class
UnionQueryBuilderTest
extends
\MediaWikiUnitTestCase
{
private
DatabaseTestHelper
$db
;
private
UnionQueryBuilder
$uqb
;
protected
function
setUp
():
void
{
$this
->
db
=
new
DatabaseTestHelper
(
__CLASS__
.
'::'
.
$this
->
getName
()
);
$this
->
uqb
=
$this
->
db
->
newUnionQueryBuilder
();
}
private
function
assertSql
(
$expected
)
{
$actual
=
$this
->
uqb
->
getSQL
();
$actual
=
preg_replace
(
'/ +/'
,
' '
,
$actual
);
$actual
=
rtrim
(
$actual
,
" "
);
$this
->
assertEquals
(
$expected
,
$actual
);
}
private
function
assertLastSql
(
$expected
)
{
$actual
=
$this
->
db
->
getLastSqls
();
$actual
=
preg_replace
(
'/ +/'
,
' '
,
$actual
);
$actual
=
rtrim
(
$actual
,
" "
);
$this
->
assertEquals
(
$expected
,
$actual
);
}
public
function
testGetSql
()
{
$this
->
uqb
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't1'
)
)
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't2'
)
)
->
orderBy
(
'f'
,
UnionQueryBuilder
::
SORT_DESC
)
->
limit
(
10
)
->
offset
(
20
)
->
caller
(
__METHOD__
);
$this
->
assertSql
(
'(SELECT f FROM t1 ) UNION (SELECT f FROM t2 ) '
.
'ORDER BY f DESC LIMIT 20,10'
);
}
public
function
testFetchResultSet
()
{
$this
->
uqb
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't1'
)
)
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't2'
)
)
->
caller
(
__METHOD__
);
$res
=
$this
->
uqb
->
fetchResultSet
();
$this
->
assertInstanceOf
(
IResultWrapper
::
class
,
$res
);
$this
->
assertLastSql
(
'(SELECT f FROM t1 ) UNION (SELECT f FROM t2 )'
);
}
public
function
testFetchField
()
{
$this
->
uqb
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't1'
)
)
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't2'
)
)
->
caller
(
__METHOD__
);
$f
=
$this
->
uqb
->
fetchField
();
$this
->
assertFalse
(
$f
);
$this
->
assertLastSql
(
'(SELECT f FROM t1 ) UNION (SELECT f FROM t2 ) LIMIT 1'
);
}
public
function
testFetchRow
()
{
$this
->
uqb
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't1'
)
)
->
add
(
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'f'
)
->
from
(
't2'
)
)
->
caller
(
__METHOD__
);
$row
=
$this
->
uqb
->
fetchRow
();
$this
->
assertFalse
(
$row
);
$this
->
assertLastSql
(
'(SELECT f FROM t1 ) UNION (SELECT f FROM t2 ) LIMIT 1'
);
}
}
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Sun, Nov 22, 00:31 (1 d, 20 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
85/8d/e2815da8abcaefcac73f538e53ae
Default Alt Text
UnionQueryBuilderTest.php (2 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment