1. class
  2. Windwalker
  3. Database
  4. Driver
  5. Mysql
  6. MysqlWriter

MysqlWriter

class MysqlWriter extends PdoWriter (View source)

Class MysqlWriter

Methods

__construct(AbstractDatabaseDriver $db)

Constructor.

from AbstractWriter
AbstractWriter
insertOne(string $table, array|object $data, string $key = null)

Inserts a row into a table based on an object's properties.

from AbstractWriter
boolean
updateOne(string $table, array|object $data, array $key, boolean $updateNulls = false)

Updates a row in a table based on an object's properties.

from AbstractWriter
bool|AbstractWriter
saveOne(string $table, array $data, string $key, boolean $updateNulls = false)

save

from AbstractWriter
mixed
insertMultiple(string $table, array $dataSet, array $key = null)

insertMultiple

from AbstractWriter
mixed
updateMultiple(string $table, array $dataSet, array $key, boolean $updateNulls = false)

updateMultiple

from AbstractWriter
mixed
saveMultiple(string $table, array $dataSet, array $key, boolean $updateNulls = false)

saveMultiple

from AbstractWriter
boolean
updateBatch(string $table, array $data, mixed $conditions = array())

Batch update some data.

from AbstractWriter
boolean
delete(string $table, array $conditions = array())

delete

from AbstractWriter
integer
countAffected()

Get the number of affected rows for the previous executed SQL statement.

from AbstractWriter
string
insertId()

Method to get the auto-incremented value from the last INSERT statement.

from AbstractWriter
AbstractWriter
execute(string|Query $query)

execute

from AbstractWriter
AbstractDatabaseDriver
getDriver()

Method to get property Db

from AbstractWriter
AbstractWriter
setDriver(AbstractDatabaseDriver $db)

Method to set property db

from AbstractWriter
resource
getCursor()

Method to get property Cursor

from AbstractWriter
AbstractWriter
setCursor(resource $cursor)

Method to set property cursor

from AbstractWriter

Details

in AbstractWriter at line line 41
__construct(AbstractDatabaseDriver $db)

Constructor.

Parameters

AbstractDatabaseDriver $db

in AbstractWriter at line line 58
AbstractWriter insertOne(string $table, array|object $data, string $key = null)

Inserts a row into a table based on an object's properties.

Parameters

string $table The name of the database table to insert into.
array|object $data &$data A reference to an object whose public properties match the table fields.
string $key The name of the primary key. If provided the object property is updated.

Return Value

AbstractWriter

Exceptions

InvalidArgumentException

in AbstractWriter at line line 150
boolean updateOne(string $table, array|object $data, array $key, boolean $updateNulls = false)

Updates a row in a table based on an object's properties.

Parameters

string $table The name of the database table to update.
array|object $data A reference to an object whose public properties match the table fields.
array $key The name of the primary key.
boolean $updateNulls True to update null fields or false to ignore them.

Return Value

boolean True on success.

Exceptions

InvalidArgumentException

in AbstractWriter at line line 242
bool|AbstractWriter saveOne(string $table, array $data, string $key, boolean $updateNulls = false)

save

Parameters

string $table The name of the database table to update.
array $data &$data A reference to an object whose public properties match the table fields.
string $key The name of the primary key.
boolean $updateNulls True to update null fields or false to ignore them.

Return Value

bool|AbstractWriter

Exceptions

InvalidArgumentException

in AbstractWriter at line line 276
mixed insertMultiple(string $table, array $dataSet, array $key = null)

insertMultiple

Parameters

string $table The name of the database table to update.
array $dataSet &$dataSet A reference to an object whose public properties match the table fields.
array $key The name of the primary key.

Return Value

mixed

Exceptions

InvalidArgumentException

in AbstractWriter at line line 302
mixed updateMultiple(string $table, array $dataSet, array $key, boolean $updateNulls = false)

updateMultiple

Parameters

string $table The name of the database table to update.
array $dataSet A reference to an object whose public properties match the table fields.
array $key The name of the primary key.
boolean $updateNulls True to update null fields or false to ignore them.

Return Value

mixed

Exceptions

InvalidArgumentException

in AbstractWriter at line line 328
mixed saveMultiple(string $table, array $dataSet, array $key, boolean $updateNulls = false)

saveMultiple

Parameters

string $table The name of the database table to update.
array $dataSet A reference to an object whose public properties match the table fields.
array $key The name of the primary key.
boolean $updateNulls True to update null fields or false to ignore them.

Return Value

mixed

Exceptions

InvalidArgumentException

in AbstractWriter at line line 356
boolean updateBatch(string $table, array $data, mixed $conditions = array())

Batch update some data.

Parameters

string $table Table name.
array $data Data you want to update.
mixed $conditions Where conditions, you can use array or Compare object. Example: - array('id' => 5) => id = 5 - new GteCompare('id', 20) => 'id >= 20' - new Compare('id', '%Flower%', 'LIKE') => 'id LIKE "%Flower%"'

Return Value

boolean True if update success.

in AbstractWriter at line line 400
boolean delete(string $table, array $conditions = array())

delete

Parameters

string $table
array $conditions

Return Value

boolean

in AbstractWriter at line line 422
integer countAffected()

Get the number of affected rows for the previous executed SQL statement.

Only applicable for DELETE, INSERT, or UPDATE statements.

Return Value

integer The number of affected rows.

in AbstractWriter at line line 435
string insertId()

Method to get the auto-incremented value from the last INSERT statement.

Return Value

string The value of the auto-increment field from the last inserted row.

in AbstractWriter at line line 447
AbstractWriter execute(string|Query $query)

execute

Parameters

string|Query $query

Return Value

AbstractWriter

in AbstractWriter at line line 461
AbstractDatabaseDriver getDriver()

Method to get property Db

Return Value

AbstractDatabaseDriver

in AbstractWriter at line line 473
AbstractWriter setDriver(AbstractDatabaseDriver $db)

Method to set property db

Parameters

AbstractDatabaseDriver $db

Return Value

AbstractWriter Return self to support chaining.

in AbstractWriter at line line 485
resource getCursor()

Method to get property Cursor

Return Value

resource

in AbstractWriter at line line 497
AbstractWriter setCursor(resource $cursor)

Method to set property cursor

Parameters

resource $cursor

Return Value

AbstractWriter Return self to support chaining.