SQLQueryHelperjs - v1.2.6
Preparing search index...
index
SqliteStrictEntityQueryBuilder
Class SqliteStrictEntityQueryBuilder<TInstance>
Type Parameters
TInstance
extends
object
Index
Constructors
constructor
Methods
where
Column
and
Where
Column
or
Where
Column
group
By
Columns
order
By
Column
limit
offset
page
page
Size
to
SQL
all
first
all
Async
first
Async
to
Query
Builder
Constructors
constructor
new
SqliteStrictEntityQueryBuilder
<
TInstance
extends
object
>
(
builder
:
SqliteQueryBuilder
,
table
:
string
,
availableColumns
:
Set
<
string
>
,
alias
:
string
|
undefined
,
)
:
SqliteStrictEntityQueryBuilder
<
TInstance
>
Type Parameters
TInstance
extends
object
Parameters
builder
:
SqliteQueryBuilder
table
:
string
availableColumns
:
Set
<
string
>
alias
:
string
|
undefined
Returns
SqliteStrictEntityQueryBuilder
<
TInstance
>
Methods
where
Column
whereColumn
(
column
:
Extract
<
keyof
TInstance
,
string
>
,
operator
?:
"="
|
"!="
|
"<>"
|
"<"
|
"<="
|
">"
|
">="
|
"LIKE"
,
value
:
QueryValue
,
)
:
this
Parameters
column
:
Extract
<
keyof
TInstance
,
string
>
operator
:
"="
|
"!="
|
"<>"
|
"<"
|
"<="
|
">"
|
">="
|
"LIKE"
= "="
value
:
QueryValue
Returns
this
and
Where
Column
andWhereColumn
(
column
:
Extract
<
keyof
TInstance
,
string
>
,
operator
?:
"="
|
"!="
|
"<>"
|
"<"
|
"<="
|
">"
|
">="
|
"LIKE"
,
value
:
QueryValue
,
)
:
this
Parameters
column
:
Extract
<
keyof
TInstance
,
string
>
operator
:
"="
|
"!="
|
"<>"
|
"<"
|
"<="
|
">"
|
">="
|
"LIKE"
= "="
value
:
QueryValue
Returns
this
or
Where
Column
orWhereColumn
(
column
:
Extract
<
keyof
TInstance
,
string
>
,
operator
?:
"="
|
"!="
|
"<>"
|
"<"
|
"<="
|
">"
|
">="
|
"LIKE"
,
value
:
QueryValue
,
)
:
this
Parameters
column
:
Extract
<
keyof
TInstance
,
string
>
operator
:
"="
|
"!="
|
"<>"
|
"<"
|
"<="
|
">"
|
">="
|
"LIKE"
= "="
value
:
QueryValue
Returns
this
group
By
Columns
groupByColumns
(
columns
:
Extract
<
keyof
TInstance
,
string
>
[]
)
:
this
Parameters
columns
:
Extract
<
keyof
TInstance
,
string
>
[]
Returns
this
order
By
Column
orderByColumn
(
column
:
Extract
<
keyof
TInstance
,
string
>
,
direction
?:
QueryOrderDirection
,
)
:
this
Parameters
column
:
Extract
<
keyof
TInstance
,
string
>
direction
:
QueryOrderDirection
= "ASC"
Returns
this
limit
limit
(
value
:
number
)
:
this
Parameters
value
:
number
Returns
this
offset
offset
(
value
:
number
)
:
this
Parameters
value
:
number
Returns
this
page
page
(
value
:
number
)
:
this
Parameters
value
:
number
Returns
this
page
Size
pageSize
(
value
:
number
)
:
this
Parameters
value
:
number
Returns
this
to
SQL
toSQL
()
:
QueryBuildResult
Returns
QueryBuildResult
all
all
<
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
>
()
:
TRow
[]
Type Parameters
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
Returns
TRow
[]
first
first
<
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
>
()
:
|
TRow
|
undefined
Type Parameters
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
Returns
TRow
|
undefined
all
Async
allAsync
<
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
>
()
:
Promise
<
TRow
[]
,
>
Type Parameters
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
Returns
Promise
<
TRow
[]
>
first
Async
firstAsync
<
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
>
()
:
Promise
<
TRow
|
undefined
,
>
Type Parameters
TRow
extends
Record
<
string
,
unknown
>
=
Record
<
string
,
unknown
>
Returns
Promise
<
TRow
|
undefined
>
to
Query
Builder
toQueryBuilder
()
:
SqliteQueryBuilder
Returns
SqliteQueryBuilder
Settings
Member Visibility
Inherited
External
Theme
OS
Light
Dark
On This Page
Constructors
constructor
Methods
where
Column
and
Where
Column
or
Where
Column
group
By
Columns
order
By
Column
limit
offset
page
page
Size
to
SQL
all
first
all
Async
first
Async
to
Query
Builder
SQLQueryHelperjs - v1.2.6
Loading...