Class LibSQL

Hierarchy (View Summary)

Database
- LibSQL

Constructors

constructor

new LibSQL(config?: Partial<LibSQL.Config>): LibSQL
Parameters
- config: Partial<LibSQL.Config> = {}
Returns LibSQL
Overrides Database.constructor

Properties

tableOptions

tableOptions: string = ''

`Readonly`type

type: Database.Type

Accessors

transactionsEnabled

get transactionsEnabled(): boolean
Returns if transactions are enabled

Returns boolean

typeName

get typeName(): string
Returns string
Inherited from Database.typeName

`Static`type

get type(): Database.Type
Returns Database.Type

Methods

`Protected`_executeMulti

_executeMulti(
queries: Database.Query[],
useTransaction: boolean,
): Promise<Database.Query.Result<any>>
Protected
Executes multiple statements and returns their results in a single Database.Query.Result
Parameters
- queries: Database.Query[]
- useTransaction: boolean
Returns Promise<Database.Query.Result<any>>
Inherited from Database._executeMulti

`Protected`_prepareColumns

_prepareColumns(fields: Column[]): [string[], any[]]
Protected
Prepares the columns for a CREATE statement
Parameters
- fields: Column[]
Returns [string[], any[]]
Inherited from Database._prepareColumns

`Protected`_prepareConstraints

_prepareConstraints(table: string, fields: Column[]): string[]
Protected
Prepares any foreign key constraints based upon the field supplied
Parameters
- table: string
- fields: Column[]
Returns string[]
Inherited from Database._prepareConstraints

`Protected`_prepareCreateIndex

_prepareCreateIndex(
    databaseType: Database.Type,
    table: string,
    fields: string[],
    type?: IndexType,
): Database.Query
Protected
Prepares the creation of an index on a table
Parameters
- databaseType: Database.Type
- table: string
- fields: string[]
- type: IndexType = Database.Table.IndexType.NONE
Returns Database.Query
Inherited from Database._prepareCreateIndex

`Protected`_prepareCreateIndexes

_prepareCreateIndexes(
    databaseType: Database.Type,
    table: string,
    fields: Column[],
    type?: IndexType,
): Database.Query[]
Protected
Prepares statements to create indexes during a CREATE table statement
Parameters
- databaseType: Database.Type
- table: string
- fields: Column[]
- type: IndexType = Database.Table.IndexType.NONE
Returns Database.Query[]
Inherited from Database._prepareCreateIndexes

`Protected`_prepareCreateTable

_prepareCreateTable(
    databaseType: Database.Type,
    table: string,
    columns: Column[],
    primaryKey?: string[],
    tableOptions?: string,
): Database.Query[]
Prepares the creation of a table including the relevant indexes and constraints
Parameters
- databaseType: Database.Type
- table: string
- columns: Column[]
- primaryKey: string[] = []
- tableOptions: string = ''
Returns Database.Query[]
Inherited from Database._prepareCreateTable

`Protected`_prepareMultiInsert

_prepareMultiInsert(
    databaseType: Database.Type,
    table: string,
    columns?: string[],
    values: any[][],
): Database.Query[]
Prepares a query to perform a multi-insert statement which is far faster than a bunch of individual insert statements
Parameters
- databaseType: Database.Type
- table: string
- columns: string[] = []
- values: any[][]
Returns Database.Query[]
Inherited from Database._prepareMultiInsert

`Protected`_prepareMultiUpdate

_prepareMultiUpdate(
    databaseType: Database.Type,
    table: string,
    primaryKey: string[],
    columns: string[],
    values: any[][],
): Database.Query[]
Prepares a query to perform a multi-update statement which is based upon a multi-insert statement that performs an UPSERT and this is a lot faster than a bunch of individual update statements
Parameters
- databaseType: Database.Type
- table: string
- primaryKey: string[]
- columns: string[]
- values: any[][]
Returns Database.Query[]
Inherited from Database._prepareMultiUpdate

`Protected`beginTransaction

beginTransaction(): Promise<Transaction>
Protected
Starts a new transaction

Returns Promise<Transaction>
Overrides Database.beginTransaction

close

close(): Promise<void>
Closes the database

Returns Promise<void>
Overrides Database.close

`Protected`commitTransaction

commitTransaction(connection: Transaction): Promise<void>
Protected
Commits the open transaction
Parameters
- connection: Transaction
Returns Promise<void>
Overrides Database.commitTransaction

`Protected`connection

connection(): Promise<void>
Protected
This is not required for this database type

Returns Promise<void>
Overrides Database.connection

createIndex

createIndex(
    table: string,
    fields: string[],
    type?: IndexType,
    useTransaction?: boolean,
): Promise<void>
Prepares and executes the creation of an index on the table specified
Parameters
- table: string
- fields: string[]
- type: IndexType = Database.Table.IndexType.NONE
- useTransaction: boolean = true
Returns Promise<void>
Inherited from Database.createIndex

createTable

createTable(
    name: string,
    fields: Column[],
    primaryKey?: string[],
    tableOptions?: string,
    useTransaction?: boolean,
): Promise<void>
Prepares and executes the creation of a table including the relevant indexes and constraints
Parameters
- name: string
- fields: Column[]
- primaryKey: string[] = []
- tableOptions: string = ...
- useTransaction: boolean = true
Returns Promise<void>
Inherited from Database.createTable

dropTable

dropTable(tables: string | string[]): Promise<Database.Query.Result<any>[]>
Drop the tables from the database
Parameters
- tables: string | string[]
Returns Promise<Database.Query.Result<any>[]>
Inherited from Database.dropTable

escape

escape(value: string): string
Escapes the value for SQL
Parameters
- value: string
Returns string
Inherited from Database.escape

escapeId

escapeId(id: string): string
Escapes the ID for sql
Parameters
- id: string
Returns string
Inherited from Database.escapeId

listTables

listTables(path?: string): Promise<string[]>
Lists the tables in the specified database
Parameters
- Optionalpath: string
Returns Promise<string[]>
Overrides Database.listTables

multiInsert

multiInsert(
    table: string,
    columns?: string[],
    values: any[][],
    useTransaction?: boolean,
): Promise<Database.Query.Result<any>>
Prepares and performs a query that performs a multi-insert statement which is far faster than a bunch of individual insert statements
Parameters
- table: string
- columns: string[] = []
- values: any[][]
- useTransaction: boolean = true
Returns Promise<Database.Query.Result<any>>
Inherited from Database.multiInsert

multiUpdate

multiUpdate(
    table: string,
    primaryKey: string[],
    columns: string[],
    values: any[][],
    useTransaction?: boolean,
): Promise<Database.Query.Result<any>>
Prepares and executes a query to that performs a multi-update statement which is based upon a multi-insert statement that performs an UPSERT which is a lot faster than a bunch of update statements
Parameters
- table: string
- primaryKey: string[]
- columns: string[]
- values: any[][]
- useTransaction: boolean = true
Returns Promise<Database.Query.Result<any>>
Inherited from Database.multiUpdate

prepareCreateIndex

prepareCreateIndex(
    table: string,
    fields: string[],
    type?: IndexType,
): Database.Query[]
Prepares the creation of an index on the specified table
Parameters
- table: string
- fields: string[]
- type: IndexType = Database.Table.IndexType.NONE
Returns Database.Query[]
Inherited from Database.prepareCreateIndex

prepareCreateTable

prepareCreateTable(
    name: string,
    fields: Column[],
    primaryKey?: string[],
    tableOptions?: string,
): Database.Query[]
Prepares the creation of a table including the relevant indexes and constraints
Parameters
- name: string
- fields: Column[]
- primaryKey: string[] = []
- tableOptions: string = ...
Returns Database.Query[]
Inherited from Database.prepareCreateTable

prepareMultiInsert

prepareMultiInsert(
    table: string,
    columns?: string[],
    values: any[][],
): Database.Query[]
Prepares a query to perform a multi-insert statement which is far faster than a bunch of individual insert statements
Parameters
- table: string
- columns: string[] = []
- values: any[][]
Returns Database.Query[]
Inherited from Database.prepareMultiInsert

prepareMultiUpdate

prepareMultiUpdate(
    table: string,
    primaryKey: string[],
    columns: string[],
    values: any[][],
): Database.Query[]
Prepares a query to perform a multi-update statement which is based upon a multi-insert statement that performs an UPSERT and this is a lot faster than a bunch of individual update statements
Parameters
- table: string
- primaryKey: string[]
- columns: string[]
- values: any[][]
Returns Database.Query[]
Inherited from Database.prepareMultiUpdate

query

query<RecordType = any>(
query: string | Database.Query,
...values: any[],
): Promise<LibSQL.Query.Result<RecordType>>
Performs an individual query and returns the result
Type Parameters
- RecordType = any
Parameters
- query: string | Database.Query
- ...values: any[]
Returns Promise<LibSQL.Query.Result<RecordType>>
Overrides Database.query

`Protected`rollbackTransaction

rollbackTransaction(connection: Transaction): Promise<void>
Protected
Rolls back the open transaction
Parameters
- connection: Transaction
Returns Promise<void>
Overrides Database.rollbackTransaction

`Protected`transaction

transaction<RecordType = any>(
queries: Database.Query[],
): Promise<LibSQL.Query.Result<RecordType>[]>
Protected
Executes a low-level transaction call against the SQLite database connection

Note: if connected to the database over HTTP/s, transactions will be batched instead
Type Parameters
- RecordType = any
Parameters
- queries: Database.Query[]
Returns Promise<LibSQL.Query.Result<RecordType>[]>
Overrides Database.transaction

truncate

truncate(table: string | string[], useTransaction?: boolean): Promise<boolean>
Truncates the specified table(s)
Parameters
- table: string | string[]
- useTransaction: boolean = true
Returns Promise<boolean>
Inherited from Database.truncate

use

use(path: string): Promise<LibSQL>
Creates a new instance connected to the specified database using the same configuration options
Parameters
- path: string
Returns Promise<LibSQL>
Overrides Database.use

Class LibSQL

Hierarchy (View Summary)

Index

Constructors

Properties

Accessors

Methods

Constructors

constructor

Parameters

Returns LibSQL

Properties

tableOptions

Readonlytype

Accessors

transactionsEnabled

Returns boolean

typeName

Returns string

Statictype

Returns Database.Type

Methods

Protected_executeMulti

Parameters

Returns Promise<Database.Query.Result<any>>

Protected_prepareColumns

Parameters

Returns [string[], any[]]

Protected_prepareConstraints

Parameters

Returns string[]

Protected_prepareCreateIndex

Parameters

Returns Database.Query

Protected_prepareCreateIndexes

Parameters

Returns Database.Query[]

Protected_prepareCreateTable

Parameters

Returns Database.Query[]

Protected_prepareMultiInsert

Parameters

Returns Database.Query[]

Protected_prepareMultiUpdate

Parameters

Returns Database.Query[]

ProtectedbeginTransaction

Returns Promise<Transaction>

close

Returns Promise<void>

ProtectedcommitTransaction

Parameters

Returns Promise<void>

Protectedconnection

Returns Promise<void>

createIndex

Parameters

Returns Promise<void>

createTable

Parameters

Returns Promise<void>

dropTable

Parameters

Returns Promise<Database.Query.Result<any>[]>

escape

Parameters

Returns string

escapeId

Parameters

Returns string

listTables

Parameters

Returns Promise<string[]>

multiInsert

Parameters

Returns Promise<Database.Query.Result<any>>

multiUpdate

Parameters

Returns Promise<Database.Query.Result<any>>

prepareCreateIndex

`Readonly`type

`Static`type

`Protected`_executeMulti

`Protected`_prepareColumns

`Protected`_prepareConstraints

`Protected`_prepareCreateIndex

`Protected`_prepareCreateIndexes

`Protected`_prepareCreateTable

`Protected`_prepareMultiInsert

`Protected`_prepareMultiUpdate

`Protected`beginTransaction

`Protected`commitTransaction

`Protected`connection

`Protected`rollbackTransaction

`Protected`transaction