SqliteHandler

MMO\pdo · 1 symbol · generated 27 Oct 2026

class

SqliteHandler

class MMO\pdo\SqliteHandler extends MMO\pdo\classes\aHandler

Namespace: MMO\pdo
Extends: aHandler

Index

	MEMORY	SQLite's in-memory database: a fresh, empty database per connection, discarded when it closes.
	filename
	password
	user
	addRegexp($handle)	SQLite parses `x REGEXP y` but has no function behind it: give it preg_match(), so a `$regex` filter matches here exactly what `FilterOperator::test` matches (`PDOPrinter::…`
	configureStatement($statement)
	connect()
	getFilename($resolve)
	getHref()
	getPassword()
	getUser()
	table($name)
	tableExists($name, $usePrefix)
	tables()
	__construct($filename, $user, $password)

Constants1

MEMORY

SQLite's in-memory database: a fresh, empty database per connection, discarded when it closes.

const MEMORY = ':memory:'

Properties3

filename

protected string $filename

Type: string

password

protected string $password = ''

Type: string

user

protected string $user = ''

Type: string

Methods11

addRegexp($handle)

SqliteHandler.php:54

SQLite parses x REGEXP y but has no function behind it: give it preg_match(), so a $regex filter matches here exactly what FilterOperator::test matches (PDOPrinter::regex).

protected function addRegexp(PDO $handle): void

$handle	PDO
returns	void

$handler->statement("SELECT 'Marc' REGEXP '/^ma/i'")->fetchValue(); // 1

configureStatement($statement)

SqliteHandler.php:25

function configureStatement(MMO\pdo\statements\Statement $statement): MMO\pdo\statements\Statement

$statement	Statement
returns	Statement

connect()

SqliteHandler.php:35

function connect(): void

returns

void

getFilename($resolve)

SqliteHandler.php:123

function getFilename(bool $resolve = true): string

NOTE: `:memory:` and a `file:` URI are DSNs, not paths. Resolving them produced `/path/to/project/:memory:`, and SQLite answered `unable to open database file` -- so an in-memory database, the obvious choice for a test or a demo, could not be opened at all.

$resolve = true	bool	if true, resolve a relative path against the project root (`filename`)
returns	string

getHref()

SqliteHandler.php:30

function getHref(): string

returns

string

getPassword()

SqliteHandler.php:134

function getPassword(): string

returns

string

getUser()

SqliteHandler.php:130

function getUser(): string

returns

string

table($name)

SqliteHandler.php:77

function table(string $name): MMO\pdo\helpers\Table

$name	string
returns	Table

tableExists($name, $usePrefix)

SqliteHandler.php:61

function tableExists(string $name, bool $usePrefix = true): bool

$name	string
$usePrefix = true	bool
returns	bool

tables()

SqliteHandler.php:68

function tables(): array

returns

array

__construct($filename, $user, $password)

SqliteHandler.php:19

function __construct(string $filename, string $user = '', string $password = '')

$filename	string
$user = ''	string
$password = ''	string

Inherited members (62)

Constants	Declared by	Description
`ALERT`	iLogLevel	Alert: Action must be taken immediately.
`ALL`	iLogLevel	Mask for all
`ALL_PLUS`	iLogLevel	debug everything
`BACKTRACE`	iLogLevel
`CRITICAL`	iLogLevel	Critical: Critical conditions.
`DEBUG`	iLogLevel	Debug: Detailed debug information.
`DEEP`	iLogLevel	debug everything with arguments
`EMERGENCY`	iLogLevel	Emergency: System is unusable.
`ERROR`	iLogLevel	Error: Runtime errors that do not require immediate action but should typically be logged and monitored.
`ERROR_PLUS`	iLogLevel	Mask for all error
`FATAL`	iLogLevel	Mask for all fatal error
`INFO`	iLogLevel	Info: Interesting events.
`INFO_PLUS`	iLogLevel	Mask for all errors/warning/notices/info
`NOTICE`	iLogLevel	Notice: Normal but significant events.
`NOTICE_PLUS`	iLogLevel	Mask for all errors/warning/notices/info
`TRACE`	iLogLevel	include backtrace as origins
`WARNING`	iLogLevel	Warning: Exceptional occurrences that are not errors.
`WARNING_PLUS`	iLogLevel	Mask for all errors and warnings

Properties	Declared by	Description
`handle`	aHandler	Handle to sql object
`tablePrefix`	aHandler
`tables`	aHandler
`transCount`	aHandler
`verbosity`	aHandler

Methods	Declared by	Description
`addTable($table, $name)`	aHandler
`addTableClass($class, $name)`	aHandler
`alert($message, $context)`	aHandler	Action must be taken immediately.
`backtraces($message, $context)`	aHandler	Force-log a message at INFO level together with a full stack trace/memory snapshot (`iLogLevel::BACKTRACE`), bypassing the verbosity mask entirely (any non-zero verbosity is enough to trigger it).
`commit()`	aHandler	Alias to \PDO::commit().
`createStatement($table, $fields, $primary, $index)`	aHandler
`critical($message, $context)`	aHandler	Critical conditions. No-op if CRITICAL is currently filtered out by the verbosity mask.
`debug($message, $context)`	aHandler	Detailed debug information.
`debugName()`	aHandler	Human-readable identifier used as the default `{origin}` in this instance's log messages.
`deleteStatement($table, $filter)`	aHandler
`disconnect()`	aHandler
`do($fn)`	aHandler	do a safe transaction on the database if an exception is thrown, it rollbacks the database
`dropStatement($table, $ifExists)`	aHandler
`emergency($message, $context)`	aHandler	System is unusable. No-op if EMERGENCY is currently filtered out by the verbosity mask.
`endTransaction()`	aHandler	Unwind one level of `startTransaction`, without committing or rolling anything back.
`error($message, $context)`	aHandler	Runtime errors that do not require immediate action but should typically be logged and monitored.
`getHandle()`	aHandler
`getTables()`	aHandler
`getVerbosity()`	aHandler
`hasTable($table)`	aHandler
`info($message, $context)`	aHandler	Interesting events. No-op if INFO is currently filtered out by the verbosity mask.
`insertStatement($table, $values)`	aHandler
`inTransaction()`	aHandler
`isConnected()`	aHandler
`lastId()`	aHandler	Return last id in insert.
`log($level, $message, $context)`	aHandler	Logs with an arbitrary level.
`notice($message, $context)`	aHandler	Normal but significant events.
`prepare($query)`	aHandler	Prepare a pdo statement
`removeTable($table)`	aHandler
`rollBack()`	aHandler	Abort the whole transaction, whatever the nesting depth: SQL has no partial rollback without savepoints, so one rollback discards every level at once and resets `$transCount` to zero.
`selectStatement($table, $fields, $filter)`	aHandler
`setVerbosity($verb)`	aHandler	Set the current verbosity mask, replacing whatever it was before.
`startTransaction()`	aHandler	Safe Alias to \PDO::beginTranscation() if inside another transaction, doesn't throw an exception and ignore call.
`statement($template, $content, $opts)`	aHandler
`testVerbosity($level)`	aHandler	Test whether a given level (or set of levels) is currently enabled by this instance's verbosity mask.
`updateStatement($table, $values, $filter)`	aHandler
`warning($message, $context)`	aHandler	Exceptional occurrences that are not errors.
`__destruct()`	aHandler
`__wakeup()`	aHandler