Documentation
Preparing search index...
@saltcorn/sqlite
index
Module index
This is the sqlite package
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
openOrUseTransaction
→
openOrUseTransaction
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
slugify
→
slugify
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
tryCatchInTransaction
→
tryCatchInTransaction
uniqueConstraintFieldsKey
→
uniqueConstraintFieldsKey
update
→
update
updateWhere
→
updateWhere
upsert_config
→
upsert_config
uses_positional_placeholders
→
uses_positional_placeholders
whenTransactionisFree
→
whenTransactionisFree
withTransaction
→
withTransaction
wrapDeleteSubselect
→
wrapDeleteSubselect
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
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
open
Or
Use
Transaction
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
slugify
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
try
Catch
In
Transaction
unique
Constraint
Fields
Key
update
update
Where
upsert_
config
uses_
positional_
placeholders
when
Transactionis
Free
with
Transaction
wrap
Delete
Subselect
Documentation
Loading...
This is the sqlite package