Documentation
Preparing search index...
@saltcorn/sqlite
sqlite
Module sqlite
SQLite3 data access layer
Variables
array_agg_sql_fn
coerce_numeric_aggregates_to_string
coerce_read_dates
discovery_columns_order_by
discovery_fk_sql
discovery_keys_uppercase
discovery_pk_sql
driverName
fk_deferrable_clause
fk_must_be_dropped_before_column
indexable_text_sql_type
inline_fk_in_column_type
json_read_returns_string
json_sql_type
json_write_needs_stringify
migration_sql_dialect
migration_translates_from_pg
millis_timestamp_sql_type
pools_connections
serial_pk_sql_type
sql_backend_display_name
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
timestamp_sql_type
uses_positional_placeholders
Functions
add_index
add_unique_constraint
addColumnWithDefault
alterColumnTypeSql
begin
castBindParamSql
castExprToTextSql
changeConnection
changePkColumnTypeStatements
close
commit
count
create_tenant_schema
deferForeignKeys
deleteSessionsForTenant
deleteSessionsForUser
deleteWhere
drop_index
drop_reset_schema
drop_tenant_schema
drop_unique_constraint
dropCheckConstraintIfExists
dropForeignKeyIfExists
dropPrimaryKey
dropTable
dropTables
epochToTimestampSql
get_db_filepath
get_session_filepath
get_sql_logging
getExpressSessionStore
getVersion
init
insert
isDistinctFromSql
isDuplicateForeignKeyError
jsonMergeExpr
listScTables
listTables
listUserDefinedTables
parseUniqueConstraintError
query
replaceForeignKey
rollback
select
selectMaybeOne
selectOne
set_sql_logging
setColumnNullabilitySql
sql_log
timeDiffWithinSql
translateMigrationsFromPostgresql
truncateMillisSql
uniqueConstraintFieldsKey
update
updateWhere
upsert_config
wrapDeleteSubselect
References
openOrUseTransaction
→
openOrUseTransaction
slugify
→
slugify
tryCatchInTransaction
→
tryCatchInTransaction
whenTransactionisFree
→
whenTransactionisFree
withTransaction
→
withTransaction
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Variables
array_
agg_
sql_
fn
coerce_
numeric_
aggregates_
to_
string
coerce_
read_
dates
discovery_
columns_
order_
by
discovery_
fk_
sql
discovery_
keys_
uppercase
discovery_
pk_
sql
driver
Name
fk_
deferrable_
clause
fk_
must_
be_
dropped_
before_
column
indexable_
text_
sql_
type
inline_
fk_
in_
column_
type
json_
read_
returns_
string
json_
sql_
type
json_
write_
needs_
stringify
migration_
sql_
dialect
migration_
translates_
from_
pg
millis_
timestamp_
sql_
type
pools_
connections
serial_
pk_
sql_
type
sql_
backend_
display_
name
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
timestamp_
sql_
type
uses_
positional_
placeholders
Functions
add_
index
add_
unique_
constraint
add
Column
With
Default
alter
Column
Type
Sql
begin
cast
Bind
Param
Sql
cast
Expr
To
Text
Sql
change
Connection
change
Pk
Column
Type
Statements
close
commit
count
create_
tenant_
schema
defer
Foreign
Keys
delete
Sessions
For
Tenant
delete
Sessions
For
User
delete
Where
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
get_
db_
filepath
get_
session_
filepath
get_
sql_
logging
get
Express
Session
Store
get
Version
init
insert
is
Distinct
From
Sql
is
Duplicate
Foreign
Key
Error
json
Merge
Expr
list
Sc
Tables
list
Tables
list
User
Defined
Tables
parse
Unique
Constraint
Error
query
replace
Foreign
Key
rollback
select
select
Maybe
One
select
One
set_
sql_
logging
set
Column
Nullability
Sql
sql_
log
time
Diff
Within
Sql
translate
Migrations
From
Postgresql
truncate
Millis
Sql
unique
Constraint
Fields
Key
update
update
Where
upsert_
config
wrap
Delete
Subselect
References
open
Or
Use
Transaction
slugify
try
Catch
In
Transaction
when
Transactionis
Free
with
Transaction
Documentation
Loading...
SQLite3 data access layer