DbDatasource
Database based data source

 class Winter\Storm\Halcyon\Datasource\DbDatasource
extends Winter\Storm\Halcyon\Datasource\Datasource
implements 
    Winter\Storm\Halcyon\Datasource\DatasourceInterface

Table Structure:

id, unsigned integer
source, varchar
path, varchar
content, longText
file_size, unsigned integer // In bytes - NOTE: max file size of 4.29 GB represented with unsigned int in MySQL
updated_at, datetime
deleted_at, datetime, nullable

Extends

Class	Description
`Datasource`	Datasource base class.

Traits

Trait	Description
`Emitter`	Adds event related features to any class.

Properties

protected $source : string

The identifier for this datasource instance

protected $table : string

The table name of the datasource

inherited protected $emitterEventCollection : array = `[]`

Inherited from Datasource

Collection of registered events.

inherited protected $emitterEventSorted : array = `[]`

Inherited from Datasource

Sorted collection of events.

inherited protected $emitterSingleEventCollection : array = `[]`

Inherited from Datasource

Collection of registered events to be fired once only.

inherited protected $forceDeleting : bool = `false`

Inherited from Datasource

Indicates if the record is currently being force deleted.

inherited protected $postProcessor : Winter\Storm\Halcyon\Processors\Processor

Inherited from Datasource

The query post processor implementation.

Methods

public __construct (string $source, string $table)

Create a new database datasource instance.

Parameters

Property	Type	Description
$source	string	string The source identifier for this datasource instance
$table	string	string The table for this database datasource

Returns

mixed

public delete (string $dirName, string $fileName, string $extension) : bool

Runs a delete statement against the datasource.

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.

Returns

bool

If the delete operation completed successfully.

public getAvailablePaths () : array

Get all available paths within this datasource.

This method returns an array, with all available paths as the key, and a boolean that represents whether the path can be handled or modified.

Example:

[
    'path/to/file.md' => true, // (this path is available, and can be handled)
    'path/to/file2.md' => false // (this path is available, but cannot be handled)
]

Returns

array

An array of available paths alongside whether they can be handled.

public getBaseQuery () : Winter\Storm\Database\QueryBuilder

Get the base QueryBuilder object.

Returns

Winter\Storm\Database\QueryBuilder

public getPathsCacheKey () : string

Gets the prefix of the cache keys.

This is based off a prefix including the base path for the model.

Returns

string

The cache key prefix.

public getQuery (boolean $ignoreDeleted = `true`) : Winter\Storm\Database\QueryBuilder

Get the QueryBuilder object.

Parameters

Property	Type	Description
$ignoreDeleted	boolean	boolean Ignore deleted records. Defaults to `true`.

Returns

Winter\Storm\Database\QueryBuilder

public insert (string $dirName, string $fileName, string $extension, string $content) : integer

Creates a new Halcyon model (template).

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.
$content	string	string The content to store for the model.

Returns

integer

The filesize of the created model.

public lastModified (string $dirName, string $fileName, string $extension) : integer | null

Returns the last modified date of a model (template).

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.

Returns

integer | null

The last modified time as a timestamp, or null if the object doesn't exist.

public select (string $dirName, array $options = `[]`) : array

Returns all Halcyon models (templates) within a given directory.

You can provide multiple options with the $options property, in order to filter the retrieved records:

columns: Only retrieve certain columns. Must be an array with any combination of fileName, mtime and content.
extensions: Defines the accepted extensions as an array. Eg: ['htm', 'md', 'twig']
fileMatch: Defines a glob string to match filenames against. Eg: '*gr[ae]y'
orders: Not implemented
limit: Not implemented
offset: Not implemented

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$options	array	array Defines the options for this query.

Returns

array

An array of models found, with the columns defined as per the columns parameter for $options.

public selectOne (string $dirName, string $fileName, string $extension) : array | null

Returns a single Halcyon model (template).

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.

Returns

array | null

An array of template data (fileName, mtime and content), or null if the model does not exist.

public update (string $dirName, string $fileName, string $extension, string $content, $oldFileName = `null`, $oldExtension = `null`) : integer

Updates an existing Halcyon model (template).

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.
$content	string	string The content to store for the model.
$oldFileName	mixed	mixed Used for renaming templates. If specified, this will delete the "old" path.
$oldExtension	mixed	mixed Used for renaming templates. If specified, this will delete the "old" path.

Returns

integer

The filesize of the updated model.

protected makeFilePath (string $dirName, string $fileName, string $extension) : string

Helper method to combine the provided directory, filename and extension into a single path.

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.

Returns

string

The combined path.

inherited public bindEvent (string | Closure | QueuedClosure $event, mixed $callback = `null`, integer $priority) : self

Inherited from Datasource

Create a new event binding.

Parameters

Property	Type	Description
$event	string \| Closure \| QueuedClosure	string \| Closure \| QueuedClosure
$callback	mixed	mixed when the third parameter is omitted and a Closure or QueuedClosure is provided this parameter is used as an integer this is used as priority variable
$priority	integer	integer

Returns

self

inherited public bindEventOnce (string | Closure | QueuedClosure $event, QueuedClosure | Closure | null $callback = `null`) : self

Inherited from Datasource

Create a new event binding that fires once only

Parameters

Property	Type	Description
$event	string \| Closure \| QueuedClosure	string \| Closure \| QueuedClosure
$callback	QueuedClosure \| Closure \| null	QueuedClosure \| Closure \| null When a Closure or QueuedClosure is provided as the first parameter this parameter can be omitted

Returns

self

inherited public fireEvent (string $event, array $params = `[]`, boolean $halt = `false`) : array | mixed | null

Inherited from Datasource

Fire an event and call the listeners.

Parameters

Property	Type	Description
$event	string	string Event name
$params	array	array Event parameters
$halt	boolean	boolean Halt after first non-null result

Returns

array | mixed | null

If halted, the first non-null result. If not halted, an array of event results. Returns null if no listeners returned a result.

inherited public forceDelete (string $dirName, string $fileName, string $extension) : bool

Inherited from Datasource

Runs a delete statement against the datasource, forcing the complete removal of the model (template).

Parameters

Property	Type	Description
$dirName	string	string The directory in which the model is stored.
$fileName	string	string The filename of the model.
$extension	string	string The file extension of the model.

Returns

bool

If the delete operation completed successfully.

inherited public getPostProcessor () : Winter\Storm\Halcyon\Processors\Processor

Inherited from Datasource

Get the query post processor used by the connection.

Returns

Winter\Storm\Halcyon\Processors\Processor

inherited public makeCacheKey (string $name = `""`) : string

Inherited from Datasource

Generate a cache key unique to this datasource.

Parameters

Property	Type	Description
$name	string	string The name of the key.

Returns

string

The hashed key.

inherited public unbindEvent (string | array | object $event = `null`) : self

Inherited from Datasource

Destroys an event binding.

Parameters

Property	Type	Description
$event	string \| array \| object	string \| array \| object Event to destroy

Returns

self

inherited protected emitterEventSortEvents (string $eventName) : void

Inherited from Datasource

Sort the listeners for a given event by priority.

Parameters

Property	Type	Description
$eventName	string	string

Returns

void

inherited protected parseEventAndPayload (mixed $event, mixed $payload = `null`) : array

Inherited from Datasource

Parse the given event and payload and prepare them for dispatching.

Parameters

Property	Type	Description
$event	mixed	mixed
$payload	mixed	mixed

Returns

array

← Previous page Winter\Storm\Halcyon\Datasource\DatasourceInterface Next page → Winter\Storm\Halcyon\Datasource\FileDatasource

DbDatasource Database based data source

# Extends

# Traits

# Properties

# protected $source : string

# protected $table : string

# inherited protected $emitterEventCollection : array = []

# inherited protected $emitterEventSorted : array = []

# inherited protected $emitterSingleEventCollection : array = []

# inherited protected $forceDeleting : bool = false

# inherited protected $postProcessor : Winter\Storm\Halcyon\Processors\Processor

# Methods

# public __construct (string $source, string $table)

# public delete (string $dirName, string $fileName, string $extension) : bool

# public getAvailablePaths () : array

# public getBaseQuery () : Winter\Storm\Database\QueryBuilder

# public getPathsCacheKey () : string

# public getQuery (boolean $ignoreDeleted = true) : Winter\Storm\Database\QueryBuilder

# public insert (string $dirName, string $fileName, string $extension, string $content) : integer

# public lastModified (string $dirName, string $fileName, string $extension) : integer | null

# public select (string $dirName, array $options = []) : array

# public selectOne (string $dirName, string $fileName, string $extension) : array | null

# public update (string $dirName, string $fileName, string $extension, string $content, $oldFileName = null, $oldExtension = null) : integer

# protected makeFilePath (string $dirName, string $fileName, string $extension) : string

# inherited public bindEvent (string | Closure | QueuedClosure $event, mixed $callback = null, integer $priority) : self

# inherited public bindEventOnce (string | Closure | QueuedClosure $event, QueuedClosure | Closure | null $callback = null) : self

# inherited public fireEvent (string $event, array $params = [], boolean $halt = false) : array | mixed | null

# inherited public forceDelete (string $dirName, string $fileName, string $extension) : bool

# inherited public getPostProcessor () : Winter\Storm\Halcyon\Processors\Processor

# inherited public makeCacheKey (string $name = "") : string

# inherited public unbindEvent (string | array | object $event = null) : self

# inherited protected emitterEventSortEvents (string $eventName) : void

# inherited protected parseEventAndPayload (mixed $event, mixed $payload = null) : array

DbDatasource
Database based data source

Extends

Traits

Properties

protected $source : string

protected $table : string

inherited protected $emitterEventCollection : array = `[]`

inherited protected $emitterEventSorted : array = `[]`

inherited protected $emitterSingleEventCollection : array = `[]`

inherited protected $forceDeleting : bool = `false`

inherited protected $postProcessor : Winter\Storm\Halcyon\Processors\Processor

Methods

public __construct (string $source, string $table)

public delete (string $dirName, string $fileName, string $extension) : bool

public getAvailablePaths () : array

public getBaseQuery () : Winter\Storm\Database\QueryBuilder

public getPathsCacheKey () : string

public getQuery (boolean $ignoreDeleted = `true`) : Winter\Storm\Database\QueryBuilder

public insert (string $dirName, string $fileName, string $extension, string $content) : integer

public lastModified (string $dirName, string $fileName, string $extension) : integer | null

public select (string $dirName, array $options = `[]`) : array

public selectOne (string $dirName, string $fileName, string $extension) : array | null

public update (string $dirName, string $fileName, string $extension, string $content, $oldFileName = `null`, $oldExtension = `null`) : integer

protected makeFilePath (string $dirName, string $fileName, string $extension) : string

inherited public bindEvent (string | Closure | QueuedClosure $event, mixed $callback = `null`, integer $priority) : self

inherited public bindEventOnce (string | Closure | QueuedClosure $event, QueuedClosure | Closure | null $callback = `null`) : self

inherited public fireEvent (string $event, array $params = `[]`, boolean $halt = `false`) : array | mixed | null

inherited public forceDelete (string $dirName, string $fileName, string $extension) : bool

inherited public getPostProcessor () : Winter\Storm\Halcyon\Processors\Processor

inherited public makeCacheKey (string $name = `""`) : string

inherited public unbindEvent (string | array | object $event = `null`) : self

inherited protected emitterEventSortEvents (string $eventName) : void

inherited protected parseEventAndPayload (mixed $event, mixed $payload = `null`) : array