SQLQueryHelperjs - v1.2.6
Preparing search index...
index
SqliteReflector
Class SqliteReflector
Index
Constructors
constructor
Methods
reflect
plan
Reflect
close
get
Db
inspect
Schema
generate
Entity
Classes
get
Schema
Change
History
clear
Schema
Change
History
select
select
From
Entity
select
From
Entity
Strict
Select
insert
Into
insert
Entity
Insert
Into
update
update
Entity
Update
delete
From
delete
Entity
Delete
From
transaction
transaction
Async
create
Trigger
drop
Trigger
create
View
drop
View
Constructors
constructor
new
SqliteReflector
(
config
:
Database
|
SqliteReflectorConfig
,
options
?:
SqliteReflectorOptions
,
)
:
SqliteReflector
Parameters
config
:
Database
|
SqliteReflectorConfig
options
:
SqliteReflectorOptions
= {}
Returns
SqliteReflector
Methods
reflect
reflect
(
...
entities
:
EntityClass
[]
)
:
void
Parameters
...
entities
:
EntityClass
[]
Returns
void
plan
Reflect
planReflect
(
...
entities
:
EntityClass
[]
)
:
SqliteSchemaSyncPreview
Parameters
...
entities
:
EntityClass
[]
Returns
SqliteSchemaSyncPreview
close
close
()
:
void
Returns
void
get
Db
getDb
()
:
Database
Returns
Database
inspect
Schema
inspectSchema
(
options
?:
SqliteInspectorOptions
)
:
SqliteInspectedSchema
Parameters
options
:
SqliteInspectorOptions
= {}
Returns
SqliteInspectedSchema
generate
Entity
Classes
generateEntityClasses
(
options
?:
SqliteSchemaGenerationOptions
)
:
string
Parameters
options
:
SqliteSchemaGenerationOptions
= {}
Returns
string
get
Schema
Change
History
getSchemaChangeHistory
(
limit
?:
number
)
:
SqliteSchemaChangeHistoryEntry
[]
Parameters
limit
:
number
= 100
Returns
SqliteSchemaChangeHistoryEntry
[]
clear
Schema
Change
History
clearSchemaChangeHistory
()
:
number
Returns
number
select
select
(
columns
?:
SelectColumns
)
:
SqliteQueryBuilder
Parameters
columns
:
SelectColumns
= "*"
Returns
SqliteQueryBuilder
select
From
Entity
selectFromEntity
<
TInstance
extends
object
>
(
entityClass
:
EntityClass
<
TInstance
>
,
columns
?:
"*"
|
Extract
<
keyof
TInstance
,
string
>
[]
,
alias
?:
string
,
)
:
SqliteQueryBuilder
Type Parameters
TInstance
extends
object
Parameters
entityClass
:
EntityClass
<
TInstance
>
columns
:
"*"
|
Extract
<
keyof
TInstance
,
string
>
[]
= "*"
Optional
alias
:
string
Returns
SqliteQueryBuilder
select
From
Entity
Strict
selectFromEntityStrict
<
TInstance
extends
object
>
(
entityClass
:
EntityClass
<
TInstance
>
,
columns
?:
"*"
|
Extract
<
keyof
TInstance
,
string
>
[]
,
alias
?:
string
,
)
:
SqliteStrictEntityQueryBuilder
<
TInstance
>
Type Parameters
TInstance
extends
object
Parameters
entityClass
:
EntityClass
<
TInstance
>
columns
:
"*"
|
Extract
<
keyof
TInstance
,
string
>
[]
= "*"
Optional
alias
:
string
Returns
SqliteStrictEntityQueryBuilder
<
TInstance
>
Select
Select
(
columns
?:
SelectColumns
)
:
SqliteQueryBuilder
Parameters
columns
:
SelectColumns
= "*"
Returns
SqliteQueryBuilder
insert
Into
insertInto
(
table
:
string
)
:
SqliteInsertBuilder
Parameters
table
:
string
Returns
SqliteInsertBuilder
insert
Entity
insertEntity
<
TInstance
extends
object
>
(
entityClass
:
EntityClass
<
TInstance
>
,
)
:
SqliteInsertBuilder
Type Parameters
TInstance
extends
object
Parameters
entityClass
:
EntityClass
<
TInstance
>
Returns
SqliteInsertBuilder
Insert
Into
InsertInto
(
table
:
string
)
:
SqliteInsertBuilder
Parameters
table
:
string
Returns
SqliteInsertBuilder
update
update
(
table
:
string
)
:
SqliteUpdateBuilder
Parameters
table
:
string
Returns
SqliteUpdateBuilder
update
Entity
updateEntity
<
TInstance
extends
object
>
(
entityClass
:
EntityClass
<
TInstance
>
,
)
:
SqliteUpdateBuilder
Type Parameters
TInstance
extends
object
Parameters
entityClass
:
EntityClass
<
TInstance
>
Returns
SqliteUpdateBuilder
Update
Update
(
table
:
string
)
:
SqliteUpdateBuilder
Parameters
table
:
string
Returns
SqliteUpdateBuilder
delete
From
deleteFrom
(
table
:
string
)
:
SqliteDeleteBuilder
Parameters
table
:
string
Returns
SqliteDeleteBuilder
delete
Entity
deleteEntity
<
TInstance
extends
object
>
(
entityClass
:
EntityClass
<
TInstance
>
,
)
:
SqliteDeleteBuilder
Type Parameters
TInstance
extends
object
Parameters
entityClass
:
EntityClass
<
TInstance
>
Returns
SqliteDeleteBuilder
Delete
From
DeleteFrom
(
table
:
string
)
:
SqliteDeleteBuilder
Parameters
table
:
string
Returns
SqliteDeleteBuilder
transaction
transaction
<
T
>
(
handler
:
(
db
:
SqliteReflector
)
=>
T
,
options
?:
SqliteTransactionOptions
,
)
:
T
Type Parameters
T
Parameters
handler
:
(
db
:
SqliteReflector
)
=>
T
options
:
SqliteTransactionOptions
= {}
Returns
T
transaction
Async
transactionAsync
<
T
>
(
handler
:
(
db
:
SqliteReflector
)
=>
T
|
Promise
<
T
>
,
options
?:
SqliteTransactionOptions
,
)
:
Promise
<
T
>
Type Parameters
T
Parameters
handler
:
(
db
:
SqliteReflector
)
=>
T
|
Promise
<
T
>
options
:
SqliteTransactionOptions
= {}
Returns
Promise
<
T
>
create
Trigger
createTrigger
(
definition
:
SqliteTriggerDefinition
)
:
void
Parameters
definition
:
SqliteTriggerDefinition
Returns
void
drop
Trigger
dropTrigger
(
name
:
string
,
ifExists
?:
boolean
)
:
void
Parameters
name
:
string
ifExists
:
boolean
= true
Returns
void
create
View
createView
(
definition
:
SqliteViewDefinition
)
:
void
Parameters
definition
:
SqliteViewDefinition
Returns
void
drop
View
dropView
(
name
:
string
,
ifExists
?:
boolean
)
:
void
Parameters
name
:
string
ifExists
:
boolean
= true
Returns
void
Settings
Member Visibility
Inherited
External
Theme
OS
Light
Dark
On This Page
Constructors
constructor
Methods
reflect
plan
Reflect
close
get
Db
inspect
Schema
generate
Entity
Classes
get
Schema
Change
History
clear
Schema
Change
History
select
select
From
Entity
select
From
Entity
Strict
Select
insert
Into
insert
Entity
Insert
Into
update
update
Entity
Update
delete
From
delete
Entity
Delete
From
transaction
transaction
Async
create
Trigger
drop
Trigger
create
View
drop
View
SQLQueryHelperjs - v1.2.6
Loading...