DatabaseRule
trait DatabaseRule (View source)
Properties
| protected string | $table | The table to run the query against. |
|
| protected string | $column | The column to check on. |
|
| protected array | $wheres | The extra where clauses for the query. |
|
| protected array | $using | The array of custom query callbacks. |
Methods
Create a new rule instance.
Resolves the name of the table from the given string.
Set a "where null" constraint on the query.
Set a "where not null" constraint on the query.
Set a "where not in" constraint on the query.
Ignore soft deleted models during the existence check.
Only include soft deleted models during the existence check.
Get the custom query callbacks for the rule.
Format the where clauses.
Details
void
__construct(string $table, string $column = 'NULL')
Create a new rule instance.
string
resolveTableName(string $table)
Resolves the name of the table from the given string.
$this
where(Closure|string $column, Arrayable|UnitEnum|Closure|array|string|int|bool|null $value = null)
Set a "where" constraint on the query.
$this
whereNot(string $column, Arrayable|UnitEnum|array|string $value)
Set a "where not" constraint on the query.
$this
whereNull(string $column)
Set a "where null" constraint on the query.
$this
whereNotNull(string $column)
Set a "where not null" constraint on the query.
$this
whereIn(string $column, Arrayable|BackedEnum|array $values)
Set a "where in" constraint on the query.
$this
whereNotIn(string $column, Arrayable|BackedEnum|array $values)
Set a "where not in" constraint on the query.
$this
withoutTrashed(string $deletedAtColumn = 'deleted_at')
Ignore soft deleted models during the existence check.
$this
onlyTrashed(string $deletedAtColumn = 'deleted_at')
Only include soft deleted models during the existence check.
$this
using(Closure $callback)
Register a custom query callback.
array
queryCallbacks()
Get the custom query callbacks for the rule.
protected string
formatWheres()
Format the where clauses.
Laravel Cloud is the best place to deploy Laravel, Nuxt, Express, Hono, Node.js, Bun, Go, Flask, Python, and more, with dedicated infrastructure available on AWS through Laravel Private Cloud.