Search
Preparing search index...
The search index is not available
sakura-node-3
Options
All
Public
Public/Protected
All
Inherited
Externals
Only exported
Menu
Globals
"sqlquery/selectquery"
SelectQuery
Class SelectQuery
Hierarchy
Query
SelectQuery
Index
Properties
cls_
group
By_
join
On_
join
Usings_
limit_
offset_
order
Bys_
select
Fields_
table_
where_
Methods
from
from
Class
from
Table
group
By
inner
Join
join
join
Using
left
Join
on
order
By
right
Join
select
set
Limit
set
Offset
type
where
where
With
Param
Properties
cls_
cls_
:
Function
|
undefined
group
By_
group
By_
:
string
[]
= []
join
On_
join
On_
:
Array
<
object
>
= []
join
Usings_
join
Usings_
:
string
[]
= []
limit_
limit_
:
number
offset_
offset_
:
number
order
Bys_
order
Bys_
:
object
[]
= []
select
Fields_
select
Fields_
:
string
[]
= []
table_
table_
:
string
where_
where_
:
string
Methods
from
from
(
table
:
string
)
:
this
Parameters
table:
string
Returns
this
from
Class
from
Class
(
cls
:
Function
)
:
this
Parameters
cls:
Function
Returns
this
from
Table
from
Table
(
table
:
string
)
:
this
Parameters
table:
string
Returns
this
group
By
group
By
(
...
fields
:
string
[]
)
:
this
Parameters
Rest
...
fields:
string
[]
Returns
this
inner
Join
inner
Join
(
tableName
:
string
)
:
this
Parameters
tableName:
string
Returns
this
join
join
(
tableName
:
string
)
:
this
Parameters
tableName:
string
Returns
this
join
Using
join
Using
(
joninStr
:
string
)
:
this
Parameters
joninStr:
string
Returns
this
left
Join
left
Join
(
tableName
:
string
)
:
this
Parameters
tableName:
string
Returns
this
on
on
(
onStr
:
string
)
:
this
Parameters
onStr:
string
Returns
this
order
By
order
By
(
sort
:
string
, order
?:
"ASC"
|
"DESC"
)
:
this
Parameters
sort:
string
Default value
order:
"ASC"
|
"DESC"
= "ASC"
Returns
this
right
Join
right
Join
(
tableName
:
string
)
:
this
Parameters
tableName:
string
Returns
this
select
select
(
fields
?:
string
[]
)
:
this
Parameters
Default value
fields:
string
[]
= []
Returns
this
set
Limit
set
Limit
(
limit
:
number
)
:
this
Parameters
limit:
number
Returns
this
set
Offset
set
Offset
(
offset
:
number
)
:
this
Parameters
offset:
number
Returns
this
type
type
(
)
:
QueryType
Returns
QueryType
where
where
(
...
args
:
any
[]
)
:
this
Parameters
Rest
...
args:
any
[]
Returns
this
where
With
Param
where
With
Param
(
sql
:
string
, sqlValues
:
any
)
:
this
Parameters
sql:
string
sqlValues:
any
Returns
this
Globals
"sqlquery/selectquery"
Join
Type
Select
Query
cls_
group
By_
join
On_
join
Usings_
limit_
offset_
order
Bys_
select
Fields_
table_
where_
from
from
Class
from
Table
group
By
inner
Join
join
join
Using
left
Join
on
order
By
right
Join
select
set
Limit
set
Offset
type
where
where
With
Param