JSONDB_{PHP Edition}

__construct(string $server, string  $username, string  $password, string  $database = NULL )

Database __constructor.

setDatabase(string  $database) : \JSONDB\Database

Changes the currently used database.

get(string  $table) : \JSONDB\Database

Change the currently used table.

queryString() : string

Returns the last query.

getServer() : string

Returns the name of the currently used server.

getDatabase() : string

Returns the name of the currently used database.

getTable() : string

Returns the name of the currently used table.

benchmark() : \JSONDB\Benchmark

Returns the current benchmark instance.

createDatabase(string  $name) : \JSONDB\Database

Creates a new database in the current server.

disconnect()

Disconnects from the database.

createTable(string  $name, array  $prototype) : \JSONDB\Database

Creates a new table in the current database.

query(string  $query) : mixed

Sends a JQL query to the current database.

prepare(string  $query) : \JSONDB\PreparedQueryStatement

Sends a prepared JQL query.

getTableData(string  $path = NULL) : array

Returns table's data.

queryIsPrepared() : boolean

Checks if the current query is a prepared query.

queryIsExecuted() : boolean

Checks if the current query is already executed.

_getDatabasePath(string  $database = NULL) : string

Gets the path to a database.

_getTablePath(string|null  $table = NULL) : array

Returns the path to a table.

_getTableContent(string|null  $table = NULL) : array

Returns a table's content.

_parseValue(mixed  $value, array  $properties) : string|float|integer|array|boolean|null

Parses a JQL query value.

_select(array $data) : \JSONDB\QueryResult

The JQL select() query.

_insert(array $data) : boolean

The JQL insert() query.

_replace(array $data) : boolean

The JQL replace() query.

_delete(array $data) : boolean

The JQL delete() query.

_update(array $data) : boolean

The JQL update() query.

_truncate(array $data) : boolean

The JQL truncate() query.

_count(array $data) : \JSONDB\QueryResult

The JQL count() query.

_filter(array $data, array  $filters) : array

Iterates over each values of $data and test them using conditions if $filters.
If a value in $data don't pass any conditions in $filters it will be removed.

_execute() : mixed

Executes a query and returns the result.

_getLastValidRowID(array  $data, boolean  $min = TRUE) : integer

Returns the last valid row ID of a table.