Documentation
Preparing search index...
@saltcorn/sqlite
Module
This is the sqlite package
Variables
openOrUseTransaction
slugify
tryCatchInTransaction
whenTransactionisFree
withTransaction
References
add_index
→
add_index
add_unique_constraint
→
add_unique_constraint
addColumnWithDefault
→
addColumnWithDefault
alterColumnTypeSql
→
alterColumnTypeSql
array_agg_sql_fn
→
array_agg_sql_fn
begin
→
begin
castBindParamSql
→
castBindParamSql
castExprToTextSql
→
castExprToTextSql
changeConnection
→
changeConnection
changePkColumnTypeStatements
→
changePkColumnTypeStatements
close
→
close
coerce_numeric_aggregates_to_string
→
coerce_numeric_aggregates_to_string
coerce_read_dates
→
coerce_read_dates
commit
→
commit
count
→
count
create_tenant_schema
→
create_tenant_schema
deferForeignKeys
→
deferForeignKeys
deleteSessionsForTenant
→
deleteSessionsForTenant
deleteSessionsForUser
→
deleteSessionsForUser
deleteWhere
→
deleteWhere
discovery_columns_order_by
→
discovery_columns_order_by
discovery_fk_sql
→
discovery_fk_sql
discovery_keys_uppercase
→
discovery_keys_uppercase
discovery_pk_sql
→
discovery_pk_sql
driverName
→
driverName
drop_index
→
drop_index
drop_reset_schema
→
drop_reset_schema
drop_tenant_schema
→
drop_tenant_schema
drop_unique_constraint
→
drop_unique_constraint
dropCheckConstraintIfExists
→
dropCheckConstraintIfExists
dropForeignKeyIfExists
→
dropForeignKeyIfExists
dropPrimaryKey
→
dropPrimaryKey
dropTable
→
dropTable
dropTables
→
dropTables
epochToTimestampSql
→
epochToTimestampSql
fk_deferrable_clause
→
fk_deferrable_clause
fk_must_be_dropped_before_column
→
fk_must_be_dropped_before_column
get_db_filepath
→
get_db_filepath
get_session_filepath
→
get_session_filepath
get_sql_logging
→
get_sql_logging
getExpressSessionStore
→
getExpressSessionStore
getVersion
→
getVersion
indexable_text_sql_type
→
indexable_text_sql_type
init
→
init
inline_fk_in_column_type
→
inline_fk_in_column_type
insert
→
insert
isDistinctFromSql
→
isDistinctFromSql
isDuplicateForeignKeyError
→
isDuplicateForeignKeyError
json_read_returns_string
→
json_read_returns_string
json_sql_type
→
json_sql_type
json_write_needs_stringify
→
json_write_needs_stringify
jsonMergeExpr
→
jsonMergeExpr
listScTables
→
listScTables
listTables
→
listTables
listUserDefinedTables
→
listUserDefinedTables
migration_sql_dialect
→
migration_sql_dialect
migration_translates_from_pg
→
migration_translates_from_pg
millis_timestamp_sql_type
→
millis_timestamp_sql_type
parseUniqueConstraintError
→
parseUniqueConstraintError
pools_connections
→
pools_connections
query
→
query
replaceForeignKey
→
replaceForeignKey
rollback
→
rollback
select
→
select
selectMaybeOne
→
selectMaybeOne
selectOne
→
selectOne
serial_pk_sql_type
→
serial_pk_sql_type
set_sql_logging
→
set_sql_logging
setColumnNullabilitySql
→
setColumnNullabilitySql
sql_backend_display_name
→
sql_backend_display_name
sql_log
→
sql_log
stores_dates_as_text
→
stores_dates_as_text
supports_agg_order_by
→
supports_agg_order_by
supports_alter_table
→
supports_alter_table
supports_array_param_in
→
supports_array_param_in
supports_database_views
→
supports_database_views
supports_for_update
→
supports_for_update
supports_large_bind_lists
→
supports_large_bind_lists
supports_multiple_schemas
→
supports_multiple_schemas
supports_non_integer_pk
→
supports_non_integer_pk
supports_row_level_security
→
supports_row_level_security
supports_search_path
→
supports_search_path
supports_session_pruning
→
supports_session_pruning
supports_table_discovery
→
supports_table_discovery
text_requires_length_for_index
→
text_requires_length_for_index
timeDiffWithinSql
→
timeDiffWithinSql
timestamp_sql_type
→
timestamp_sql_type
translateMigrationsFromPostgresql
→
translateMigrationsFromPostgresql
truncateMillisSql
→
truncateMillisSql
uniqueConstraintFieldsKey
→
uniqueConstraintFieldsKey
update
→
update
updateWhere
→
updateWhere
upsert_config
→
upsert_config
uses_positional_placeholders
→
uses_positional_placeholders
wrapDeleteSubselect
→
wrapDeleteSubselect
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Variables
open
Or
Use
Transaction
slugify
try
Catch
In
Transaction
when
Transactionis
Free
with
Transaction
References
add_
index
add_
unique_
constraint
add
Column
With
Default
alter
Column
Type
Sql
array_
agg_
sql_
fn
begin
cast
Bind
Param
Sql
cast
Expr
To
Text
Sql
change
Connection
change
Pk
Column
Type
Statements
close
coerce_
numeric_
aggregates_
to_
string
coerce_
read_
dates
commit
count
create_
tenant_
schema
defer
Foreign
Keys
delete
Sessions
For
Tenant
delete
Sessions
For
User
delete
Where
discovery_
columns_
order_
by
discovery_
fk_
sql
discovery_
keys_
uppercase
discovery_
pk_
sql
driver
Name
drop_
index
drop_
reset_
schema
drop_
tenant_
schema
drop_
unique_
constraint
drop
Check
Constraint
If
Exists
drop
Foreign
Key
If
Exists
drop
Primary
Key
drop
Table
drop
Tables
epoch
To
Timestamp
Sql
fk_
deferrable_
clause
fk_
must_
be_
dropped_
before_
column
get_
db_
filepath
get_
session_
filepath
get_
sql_
logging
get
Express
Session
Store
get
Version
indexable_
text_
sql_
type
init
inline_
fk_
in_
column_
type
insert
is
Distinct
From
Sql
is
Duplicate
Foreign
Key
Error
json_
read_
returns_
string
json_
sql_
type
json_
write_
needs_
stringify
json
Merge
Expr
list
Sc
Tables
list
Tables
list
User
Defined
Tables
migration_
sql_
dialect
migration_
translates_
from_
pg
millis_
timestamp_
sql_
type
parse
Unique
Constraint
Error
pools_
connections
query
replace
Foreign
Key
rollback
select
select
Maybe
One
select
One
serial_
pk_
sql_
type
set_
sql_
logging
set
Column
Nullability
Sql
sql_
backend_
display_
name
sql_
log
stores_
dates_
as_
text
supports_
agg_
order_
by
supports_
alter_
table
supports_
array_
param_
in
supports_
database_
views
supports_
for_
update
supports_
large_
bind_
lists
supports_
multiple_
schemas
supports_
non_
integer_
pk
supports_
row_
level_
security
supports_
search_
path
supports_
session_
pruning
supports_
table_
discovery
text_
requires_
length_
for_
index
time
Diff
Within
Sql
timestamp_
sql_
type
translate
Migrations
From
Postgresql
truncate
Millis
Sql
unique
Constraint
Fields
Key
update
update
Where
upsert_
config
uses_
positional_
placeholders
wrap
Delete
Subselect
Documentation
Loading...
This is the sqlite package