\PrivateBin\DataDatabase

getInstance()

getInstance(array  $options): \PrivateBin\Data\Database

get instance of singleton

Parameters

Throws

\Exception

Returns

create()

create(string  $pasteid,array  $paste): boolean

Create a paste.

Parameters

Returns

read()

read(string  $pasteid): array|false

Read a paste.

Parameters

Returns

delete()

delete(string  $pasteid)

Delete a paste and its discussion.

Parameters

exists()

exists(string  $pasteid): boolean

Test if a paste exists.

Parameters

Returns

createComment()

createComment(string  $pasteid,string  $parentid,string  $commentid,array  $comment): boolean

Create a comment in a paste.

Parameters

Returns

readComments()

readComments(string  $pasteid): array

Read all comments of paste.

Parameters

Returns

existsComment()

existsComment(string  $pasteid,string  $parentid,string  $commentid): boolean

Test if a comment exists.

Parameters

Returns

purgeValues()

purgeValues(string  $namespace,integer  $time): void

Purge outdated entries.

Parameters

setValue()

setValue(string  $value,string  $namespace,string  $key = ''): boolean

Save a value.

Parameters

Returns

getValue()

getValue(string  $namespace,string  $key = ''): string

Load a value.

Parameters

Returns

purge()

purge(integer  $batchsize)

Perform a purge of old pastes, at most the given batchsize is deleted.

Parameters

_sanitizeClob()

_sanitizeClob(integer|string|resource  $value): integer|string

sanitizes CLOB values used with OCI

From: https://stackoverflow.com/questions/36200534/pdo-oci-into-a-clob-field

Parameters

Returns

__construct()

__construct()

Enforce singleton, disable constructor

Instantiate using \getInstance(), this object implements the singleton pattern.

_getExpiredPastes()

_getExpiredPastes(integer  $batchsize): array

Returns up to batch size number of paste ids that have expired

Parameters

Returns

getOpenSlot()

getOpenSlot(array  $comments,integer|string  $postdate): integer|string

Get next free slot for comment from postdate.

Parameters

Returns

upgradePreV1Format()

upgradePreV1Format(array  $paste): array

Upgrade pre-version 1 pastes with attachment to version 1 format.

Parameters

Returns

__clone()

__clone()

Enforce singleton, disable cloning

Instantiate using \getInstance(), this object implements the singleton pattern.

_exec()

_exec(string  $sql,array  $params): boolean

execute a statement

Parameters

Throws

\PDOException

Returns

_select()

_select(string  $sql,array  $params,boolean  $firstOnly = false): array|false

run a select statement

Parameters

Throws

\PDOException

Returns

_getVersionedKeys()

_getVersionedKeys(integer  $version): array

get version dependent key names

Parameters

Returns

_getTableQuery()

_getTableQuery(string  $type): string

get table list query, depending on the database type

Parameters

Throws

\Exception

Returns

_getConfig()

_getConfig(string  $key): string

get a value by key from the config table

Parameters

Returns

_getPrimaryKeyClauses()

_getPrimaryKeyClauses(string  $key = 'dataid'): array

get the primary key clauses, depending on the database driver

Parameters

Returns

_getDataType()

_getDataType(): string

get the data type, depending on the database driver

PostgreSQL and OCI uses a different API for BLOBs then SQL, hence we use TEXT and CLOB

Returns

_getAttachmentType()

_getAttachmentType(): string

get the attachment type, depending on the database driver

PostgreSQL and OCI use different APIs for BLOBs then SQL, hence we use TEXT and CLOB

Returns

_getMetaType()

_getMetaType(): string

get the meta type, depending on the database driver

OCI doesn't accept TEXT so it has to be VARCHAR2(4000)

Returns

_createPasteTable()

_createPasteTable()

create the paste table

_createCommentTable()

_createCommentTable()

create the paste table

_createConfigTable()

_createConfigTable()

create the paste table

_sanitizeIdentifier()

_sanitizeIdentifier(string  $identifier): string

sanitizes identifiers

Parameters

Returns

_upgradeDatabase()

_upgradeDatabase(string  $oldversion)

upgrade the database schema from an old version

Parameters