Skip to content

DatabaseSyncOptions

[<Interface>]
type DatabaseSyncOptions =
    abstract member allowBareNamedParameters: bool option with get, set
    abstract member allowExtension: bool option with get, set
    abstract member allowUnknownNamedParameters: bool option with get, set
    abstract member enableDoubleQuotedStringLiterals: bool option with get, set
    abstract member enableForeignKeyConstraints: bool option with get, set
    abstract member open: bool option with get, set
    abstract member readBigInts: bool option with get, set
    abstract member readOnly: bool option with get, set
    abstract member returnArrays: bool option with get, set
    abstract member timeout: float option with get, set
    static member Create (?open: bool, ?enableForeignKeyConstraints: bool, ?enableDoubleQuotedStringLiterals: bool, ?readOnly: bool, ?allowExtension: bool, ?timeout: float, ?readBigInts: bool, ?returnArrays: bool, ?allowBareNamedParameters: bool, ?allowUnknownNamedParameters: bool) : DatabaseSyncOptions
AssemblyXantham.Fable.Node
Attributes[<Interface>]

Properties

abstract member allowBareNamedParameters: bool option with get, set

If true, allows binding named parameters without the prefix character (e.g., foo instead of :foo).

@since v22.18.0

abstract member allowExtension: bool option with get, set

If true, the loadExtension SQL function and the loadExtension() method are enabled. You can call enableLoadExtension(false) later to disable this feature.

@since v22.13.0

abstract member allowUnknownNamedParameters: bool option with get, set

If true, unknown named parameters are ignored when binding. If false, an exception is thrown for unknown named parameters.

@since v22.18.0

abstract member enableDoubleQuotedStringLiterals: bool option with get, set

If true, SQLite will accept double-quoted string literals. This is not recommended but can be enabled for compatibility with legacy database schemas.

@since v22.10.0

abstract member enableForeignKeyConstraints: bool option with get, set

If true, foreign key constraints are enabled. This is recommended but can be disabled for compatibility with legacy database schemas. The enforcement of foreign key constraints can be enabled and disabled after opening the database using PRAGMA foreign_keys.

@since v22.10.0

abstract member open: bool option with get, set

If true, the database is opened by the constructor. When this value is false, the database must be opened via the open() method.

@since v22.5.0

abstract member readBigInts: bool option with get, set

If true, integer fields are read as JavaScript BigInt values. If false, integer fields are read as JavaScript numbers.

@since v22.18.0

abstract member readOnly: bool option with get, set

If true, the database is opened in read-only mode. If the database does not exist, opening it will fail.

@since v22.12.0

abstract member returnArrays: bool option with get, set

If true, query results are returned as arrays instead of objects.

@since v22.18.0

abstract member timeout: float option with get, set

The busy timeout in milliseconds. This is the maximum amount of time that SQLite will wait for a database lock to be released before returning an error.

@since v22.16.0

Methods

static member Create (?open: bool, ?enableForeignKeyConstraints: bool, ?enableDoubleQuotedStringLiterals: bool, ?readOnly: bool, ?allowExtension: bool, ?timeout: float, ?readBigInts: bool, ?returnArrays: bool, ?allowBareNamedParameters: bool, ?allowUnknownNamedParameters: bool) : DatabaseSyncOptions