Dongle
Database driver dongle

 class Winter\Storm\Database\Dongle

This class uses regex to convert MySQL to various other drivers.

Properties

protected $db : Illuminate\Database\DatabaseManager

Database helper object

protected $driver : string

Driver to convert to: mysql, sqlite, pgsql, sqlsrv, postgis.

protected $strictModeDisabled : bool

Used to determine whether strict mode has been disabled.

Methods

public __construct (string $driver = `"mysql"`, Illuminate\Database\DatabaseManager $db = `null`)

Constructor.

Parameters

Property	Type	Description
$driver	string	string
$db	Illuminate\Database\DatabaseManager	Illuminate\Database\DatabaseManager

Returns

mixed

public cast (string $sql, string $asType = `"INTEGER"`) : string

Some drivers require same-type comparisons.

Parameters

Property	Type	Description
$sql	string	string
$asType	string	string

Returns

string

public convertTimestamps (string $table, string | array $columns = `null`)

Alters a table's TIMESTAMP field(s) to be nullable and converts existing values.

This is needed to transition from older Laravel code that set DEFAULT 0, which is an invalid date in newer MySQL versions where NO_ZERO_DATE is included in strict mode.

Parameters

Property	Type	Description
$table	string	string
$columns	string \| array	string \| array Column name(s). Defaults to ['created_at', 'updated_at']

Returns

mixed

public disableStrictMode ()

Used to disable strict mode during migrations

Returns

mixed

public getDriver () : string

Returns the driver name as a string, eg: pgsql

Returns

string

public getTablePrefix () : string

Get the table prefix.

Returns

string

public parse (string $sql) : string

Transforms an SQL statement to match the active driver.

Parameters

Property	Type	Description
$sql	string	string

Returns

string

public parseBooleanExpression (string $sql) : string

Transforms true|false expressions in a statement.

Parameters

Property	Type	Description
$sql	string	string

Returns

string

public parseConcat (string $sql) : string

Transforms CONCAT statement.

Parameters

Property	Type	Description
$sql	string	string

Returns

string

public parseGroupConcat (string $sql) : string

Transforms GROUP_CONCAT statement.

Parameters

Property	Type	Description
$sql	string	string

Returns

string

public parseIfNull (string $sql) : string

Transforms IFNULL statement.

Parameters

Property	Type	Description
$sql	string	string

Returns

string

public raw (string $sql) : mixed

Transforms and executes a raw SQL statement

Parameters

Property	Type	Description
$sql	string	string

Returns

mixed

← Winter\Storm\Database\DatabaseServiceProvider Winter\Storm\Database\MemoryCache →

Dongle Database driver dongle

# Properties

# protected $db : Illuminate\Database\DatabaseManager

# protected $driver : string

# protected $strictModeDisabled : bool

# Methods

# public __construct (string $driver = "mysql", Illuminate\Database\DatabaseManager $db = null)

# public cast (string $sql, string $asType = "INTEGER") : string

# public convertTimestamps (string $table, string | array $columns = null)

# public disableStrictMode ()

# public getDriver () : string

# public getTablePrefix () : string

# public parse (string $sql) : string

# public parseBooleanExpression (string $sql) : string

# public parseConcat (string $sql) : string

# public parseGroupConcat (string $sql) : string

# public parseIfNull (string $sql) : string

# public raw (string $sql) : mixed

Dongle
Database driver dongle

Properties

protected $db : Illuminate\Database\DatabaseManager

protected $driver : string

protected $strictModeDisabled : bool

Methods

public __construct (string $driver = `"mysql"`, Illuminate\Database\DatabaseManager $db = `null`)

public cast (string $sql, string $asType = `"INTEGER"`) : string

public convertTimestamps (string $table, string | array $columns = `null`)

public disableStrictMode ()

public getDriver () : string

public getTablePrefix () : string

public parse (string $sql) : string

public parseBooleanExpression (string $sql) : string

public parseConcat (string $sql) : string

public parseGroupConcat (string $sql) : string

public parseIfNull (string $sql) : string

public raw (string $sql) : mixed