Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F5946949
SqlitePlatform.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
3 KB
Referenced Files
None
Subscribers
None
SqlitePlatform.php
View Options
<?php
/**
* @license GPL-2.0-or-later
* @file
*/
namespace
Wikimedia\Rdbms\Platform
;
use
Wikimedia\Rdbms\Query
;
/**
* @since 1.38
* @see ISQLPlatform
*/
class
SqlitePlatform
extends
SQLPlatform
{
/** @inheritDoc */
public
function
buildGreatest
(
$fields
,
$values
)
{
return
$this
->
buildSuperlative
(
'MAX'
,
$fields
,
$values
);
}
/** @inheritDoc */
public
function
buildLeast
(
$fields
,
$values
)
{
return
$this
->
buildSuperlative
(
'MIN'
,
$fields
,
$values
);
}
/**
* Build a concatenation list to feed into a SQL query
*
* @param string[] $stringList
* @return string
*/
public
function
buildConcat
(
$stringList
)
{
return
'('
.
implode
(
') || ('
,
$stringList
)
.
')'
;
}
/** @inheritDoc */
public
function
buildGroupConcat
(
$field
,
$delim
):
string
{
return
"group_concat($field,"
.
$this
->
quoter
->
addQuotes
(
$delim
)
.
')'
;
}
/**
* @param string[] $sqls
* @param bool $all Whether to "UNION ALL" or not
* @param array $options Query options, will be ignored in Sqlite
* @return string
*/
public
function
unionQueries
(
$sqls
,
$all
,
$options
=
[]
)
{
$glue
=
$all
?
' UNION ALL '
:
' UNION '
;
return
implode
(
$glue
,
$sqls
);
}
/**
* @return bool
*/
public
function
unionSupportsOrderAndLimit
()
{
return
false
;
}
/** @inheritDoc */
public
function
buildSubstring
(
$input
,
$startPosition
,
$length
=
null
)
{
$this
->
assertBuildSubstringParams
(
$startPosition
,
$length
);
$params
=
[
$input
,
$startPosition
];
if
(
$length
!==
null
)
{
$params
[]
=
$length
;
}
return
'SUBSTR('
.
implode
(
','
,
$params
)
.
')'
;
}
/**
* @param string $field Field or column to cast
* @return string
* @since 1.28
*/
public
function
buildStringCast
(
$field
)
{
return
'CAST ( '
.
$field
.
' AS TEXT )'
;
}
/** @inheritDoc */
public
function
tableName
(
string
$name
,
$format
=
'quoted'
)
{
if
(
preg_match
(
'/^sqlite_[a-z_]+$/'
,
$name
)
)
{
// Such names are reserved for internal SQLite tables
return
$name
;
}
return
parent
::
tableName
(
$name
,
$format
);
}
/** @inheritDoc */
protected
function
makeSelectOptions
(
array
$options
)
{
// Remove problematic options that the base implementation converts to SQL
foreach
(
$options
as
$k
=>
$v
)
{
if
(
is_numeric
(
$k
)
&&
(
$v
===
'FOR UPDATE'
||
$v
===
'LOCK IN SHARE MODE'
)
)
{
$options
[
$k
]
=
''
;
}
}
return
parent
::
makeSelectOptions
(
$options
);
}
/** @inheritDoc */
protected
function
makeInsertNonConflictingVerbAndOptions
()
{
return
[
'INSERT OR IGNORE INTO'
,
''
];
}
/**
* @param array $options
* @return array
*/
protected
function
makeUpdateOptionsArray
(
$options
)
{
$options
=
parent
::
makeUpdateOptionsArray
(
$options
);
$options
=
$this
->
rewriteIgnoreKeyword
(
$options
);
return
$options
;
}
/**
* @param array $options
* @return array
*/
private
function
rewriteIgnoreKeyword
(
$options
)
{
# SQLite uses OR IGNORE not just IGNORE
foreach
(
$options
as
$k
=>
$v
)
{
if
(
$v
==
'IGNORE'
)
{
$options
[
$k
]
=
'OR IGNORE'
;
}
}
return
$options
;
}
/** @inheritDoc */
public
function
dropTableSqlText
(
$table
)
{
// No CASCADE support; https://www.sqlite.org/lang_droptable.html
return
"DROP TABLE "
.
$this
->
tableName
(
$table
);
}
/** @inheritDoc */
public
function
isTransactableQuery
(
Query
$sql
)
{
return
parent
::
isTransactableQuery
(
$sql
)
&&
!
in_array
(
$sql
->
getVerb
(),
[
'ATTACH'
,
'PRAGMA'
],
true
);
}
}
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Oct 2 2026, 20:10 (6 w, 2 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
d4/6d/c98e215e747150260a294c1c6544
Default Alt Text
SqlitePlatform.php (3 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment