\ManaPHP\Data\DbModelInterface

getTable()

getTable() : string

Returns table name mapped in the model

Returns

getDb()

getDb() : string

Gets internal database connection

Returns

getAnyShard()

getAnyShard() : array

Returns

getUniqueShard()

getUniqueShard(array|\ManaPHP\Data\Model  $context) : array

Parameters

Returns

getMultipleShards()

getMultipleShards(array|\ManaPHP\Data\Model  $context) : array

Parameters

Returns

getAllShards()

getAllShards() : array

Returns

getPrimaryKey()

getPrimaryKey() : string

Returns

getForeignedKey()

getForeignedKey() : string

Returns

getFields()

getFields() : array

Returns

hasField()

hasField(string  $field) : boolean

Parameters

Returns

getDateFormat()

getDateFormat(string  $field) : string

Parameters

Returns

getSafeFields()

getSafeFields() : array

Returns

getJsonFields()

getJsonFields() : array

Returns

getIntFields()

getIntFields() : array|null

Returns

getAutoIncrementField()

getAutoIncrementField() : string|null

Returns

getNextAutoIncrementId()

getNextAutoIncrementId(integer  $step = 1) : integer

Parameters

Returns

rules()

rules() : array

Returns

labels()

labels() : array

Returns

sample()

sample() : static

Returns

query()

query(string  $alias = null) : \ManaPHP\Data\Db\Query

Parameters

Returns

all()

all(array  $filters = array(), array  $options = null, array  $fields = null) : array<mixed,static>

Allows to query a set of records that match the specified conditions

Parameters

Returns

paginate()

paginate(array  $filters = array(), array  $options = null, array  $fields = null) : \ManaPHP\Data\Paginator

Allows to query a set of records that match the specified conditions

Parameters

Returns

lists()

lists(string|array  $fields, array  $filters = null) : array

Parameters

Returns

get()

get(integer|string  $id, integer|array  $fieldsOrTtl = null) : static

Parameters

Returns

first()

first(integer|string|array  $filters, array  $fields = null) : static|null

Allows to query the first record that match the specified conditions

Parameters

Returns

firstOrFail()

firstOrFail(integer|string|array  $filters, array  $fields = null) : static

Parameters

Returns

rId()

rId() : integer|string

Returns

rGet()

rGet(array  $fields = null) : static

Parameters

Returns

last()

last(array  $filters = null, array  $fields = null) : static|null

Allows to query the last record that match the specified conditions

Parameters

Returns

value()

value(integer|string|array  $filters, string  $field, integer  $ttl = null) : integer|float|string|null

Parameters

Returns

valueOrFail()

valueOrFail(integer|string|array  $filters, string  $field, integer  $ttl = null) : integer|float|string

Parameters

Returns

valueOrDefault()

valueOrDefault(integer|string|array  $filters, string|float|integer  $field, mixed  $default) : float|integer|string

Parameters

Returns

values()

values(string  $field, array  $filters = null) : array

Parameters

Returns

exists()

exists(string|array  $filters) : boolean

Parameters

Returns

aggregate()

aggregate(array  $filters, array  $aggregation, string|array  $options = null) : array

Parameters

Returns

count()

count(array  $filters = null, string  $field = '*') : integer

Allows to count how many records match the specified conditions

Parameters

Returns

sum()

sum(string  $field, array  $filters = null) : integer|float|null

Allows to calculate a summary on a column that match the specified conditions

Parameters

Returns

max()

max(string  $field, array  $filters = null) : integer|float|null

Allows to get the max value of a column that match the specified conditions

Parameters

Returns

min()

min(string  $field, array  $filters = null) : integer|float|null

Allows to get the min value of a column that match the specified conditions

Parameters

Returns

avg()

avg(string  $field, array  $filters = null) : float|null

Allows to calculate the average value on a column matching the specified conditions

Parameters

Returns

load()

load(array  $fields = null) : static

Parameters

Returns

assign()

assign(array|\ManaPHP\Data\Model  $data, array  $fields) : static

Assigns values to a model from an array

Parameters

Returns

validate()

validate(array  $fields = null) : void

Parameters

validateField()

validateField(string  $field, array  $rules = null) : void

Parameters

save()

save(array  $fields = null) : static

Inserts or updates a model instance. Returning true on success or false otherwise.

Parameters

Returns

create()

create() : static

Inserts a model instance. If the instance already exists in the persistence it will throw an exception Returning true on success or false otherwise.

Returns

rCreate()

rCreate(array  $fields = null) : static

Parameters

Returns

update()

update() : static

Updates a model instance. If the instance does n't exist in the persistence it will throw an exception Returning true on success or false otherwise.

Returns

rUpdate()

rUpdate(array  $fields = null) : static

Parameters

Returns

updateAll()

updateAll(array  $fieldValues, array  $filters) : integer

Parameters

Returns

delete()

delete() : static

Deletes a model instance. Returning true on success or false otherwise.

Returns

rDelete()

rDelete() : static|null

Returns

deleteAll()

deleteAll(array  $filters) : integer

Parameters

Returns

insert()

insert(array  $record) : integer

Parameters

Returns

with()

with(string|array  $withs) : static

Parameters

Returns

toArray()

toArray() : array

Returns the instance as an array representation

Returns

only()

only(array  $fields) : static

Parameters

Returns

except()

except(array  $fields) : static

Parameters

Returns

getSnapshotData()

getSnapshotData() : array

Returns the internal snapshot data

Returns

getChangedFields()

getChangedFields() : array

Returns a list of changed values

Returns

hasChanged()

hasChanged(string|array  $fields) : boolean

Check if a specific attribute has changed This only works if the model is keeping data snapshots

Parameters

Returns

refresh()

refresh(float  $interval, array  $fields = null) : static

Parameters

Returns

constants()

constants(string  $name, boolean  $comment = false) : array

Parameters

Throws

\ReflectionException

Returns

increment()

increment(string  $field, integer|float  $step = 1) : static

Parameters

Returns

decrement()

decrement(string  $field, integer|float  $step = 1) : static

Parameters

Returns

select()

select(array|string  $fields = array(), string  $alias = null) : \ManaPHP\Data\QueryInterface

Parameters

Returns

where()

where(integer|string|array  $filters) : \ManaPHP\Data\QueryInterface

Parameters

Returns

search()

search(array  $filters) : \ManaPHP\Data\QueryInterface

Parameters

Returns

newQuery()

newQuery() : \ManaPHP\Data\QueryInterface

Returns

belongsTo()

belongsTo(string  $thatModel, string  $thisField = null) : \ManaPHP\Data\Relation\BelongsTo

Parameters

Returns

hasOne()

hasOne(string  $thatModel, string  $thatField = null) : \ManaPHP\Data\Relation\HasOne

Parameters

Returns

hasMany()

hasMany(string  $thatModel, string  $thatField = null) : \ManaPHP\Data\Relation\HasMany

Parameters

Returns

hasManyToMany()

hasManyToMany(string  $thatModel, string  $pivotModel) : \ManaPHP\Data\Relation\HasManyToMany

Parameters

Returns

hasManyOthers()

hasManyOthers(string  $thatModel, string  $thisFilter = null) : \ManaPHP\Data\Relation\HasManyOthers

Parameters

Returns

belongsToMany()

belongsToMany(string  $thatModel, string  $pivotModel) : \ManaPHP\Data\Relation\HasManyToMany

alias of hasManyToMany

Parameters

Returns

insertBySql()

insertBySql(array|string  $sql) : integer

Parameters

Returns

deleteBySql()

deleteBySql(array|string  $sql) : integer

Parameters

Returns

updateBySql()

updateBySql(string|array  $sql) : integer

Parameters

Returns