SQLQueryHelperjs - v1.2.6
Preparing search index...
index
PostgresInsertBuilder
Class PostgresInsertBuilder
Hierarchy (
View Summary
)
PostgresInsertBuilder
MySqlInsertBuilder
Index
Constructors
constructor
Methods
values
value
on
Conflict
do
Nothing
do
Update
From
Excluded
conflict
Where
returning
to
SQL
run
run
Async
all
Returning
first
Returning
all
Returning
Async
first
Returning
Async
Constructors
constructor
new
PostgresInsertBuilder
(
connection
:
PostgresQueryConnection
,
table
:
string
,
)
:
PostgresInsertBuilder
Parameters
connection
:
PostgresQueryConnection
table
:
string
Returns
PostgresInsertBuilder
Methods
values
values
(
value
:
QuerySetValues
|
QuerySetValues
[]
)
:
this
Parameters
value
:
QuerySetValues
|
QuerySetValues
[]
Returns
this
value
value
(
value
:
QuerySetValues
)
:
this
Parameters
value
:
QuerySetValues
Returns
this
on
Conflict
onConflict
(
columns
?:
string
|
string
[]
)
:
this
Parameters
Optional
columns
:
string
|
string
[]
Returns
this
do
Nothing
doNothing
()
:
this
Returns
this
do
Update
From
Excluded
doUpdateFromExcluded
(
columns
:
string
|
string
[]
)
:
this
Parameters
columns
:
string
|
string
[]
Returns
this
conflict
Where
conflictWhere
(
condition
:
string
,
...
params
:
QueryValue
[]
)
:
this
Parameters
condition
:
string
...
params
:
QueryValue
[]
Returns
this
returning
returning
(
columns
?:
SelectColumns
)
:
this
Parameters
columns
:
SelectColumns
= "*"
Returns
this
to
SQL
toSQL
()
:
QueryBuildResult
Returns
QueryBuildResult
run
run
()
:
Promise
<
{
rowCount
:
number
}
>
Returns
Promise
<
{
rowCount
:
number
}
>
run
Async
runAsync
()
:
Promise
<
{
rowCount
:
number
}
>
Returns
Promise
<
{
rowCount
:
number
}
>
all
Returning
allReturning
<
TRow
extends
QueryResultRow
=
QueryResultRow
>
()
:
Promise
<
TRow
[]
>
Type Parameters
TRow
extends
QueryResultRow
=
QueryResultRow
Returns
Promise
<
TRow
[]
>
first
Returning
firstReturning
<
TRow
extends
QueryResultRow
=
QueryResultRow
>
()
:
Promise
<
TRow
|
undefined
,
>
Type Parameters
TRow
extends
QueryResultRow
=
QueryResultRow
Returns
Promise
<
TRow
|
undefined
>
all
Returning
Async
allReturningAsync
<
TRow
extends
QueryResultRow
=
QueryResultRow
>
()
:
Promise
<
TRow
[]
,
>
Type Parameters
TRow
extends
QueryResultRow
=
QueryResultRow
Returns
Promise
<
TRow
[]
>
first
Returning
Async
firstReturningAsync
<
TRow
extends
QueryResultRow
=
QueryResultRow
>
()
:
Promise
<
TRow
|
undefined
,
>
Type Parameters
TRow
extends
QueryResultRow
=
QueryResultRow
Returns
Promise
<
TRow
|
undefined
>
Settings
Member Visibility
Inherited
External
Theme
OS
Light
Dark
On This Page
Constructors
constructor
Methods
values
value
on
Conflict
do
Nothing
do
Update
From
Excluded
conflict
Where
returning
to
SQL
run
run
Async
all
Returning
first
Returning
all
Returning
Async
first
Returning
Async
SQLQueryHelperjs - v1.2.6
Loading...