default

Defined in: index.ts:27

Database

The Database class serves as the primary interface for communicating with the rust side of the sql plugin.

Constructors

Constructor

new default(path): Database

Defined in: index.ts:29

Parameters

path

string

Returns

Database

Properties

path

path: string

Defined in: index.ts:28

Methods

close()

close(db?): Promise<boolean>

Defined in: index.ts:162

close

Closes the database connection pool.

Parameters

db?

string

Optionally state the name of a database if you are managing more than one. Otherwise, all database pools will be in scope.

Returns

Promise<boolean>

Example

const success = await db.close()

---

execute()

execute(query, bindValues?): Promise<QueryResult>

Defined in: index.ts:108

execute

Passes a SQL expression to the database for execution.

Parameters

query

string

bindValues?

unknown[]

Returns

Promise<QueryResult>

Example

// for sqlite & postgres
// INSERT example
const result = await db.execute(
   "INSERT into todos (id, title, status) VALUES ($1, $2, $3)",
   [ todos.id, todos.title, todos.status ]
);
// UPDATE example
const result = await db.execute(
   "UPDATE todos SET title = $1, completed = $2 WHERE id = $3",
   [ todos.title, todos.status, todos.id ]
);

// for mysql
// INSERT example
const result = await db.execute(
   "INSERT into todos (id, title, status) VALUES (?, ?, ?)",
   [ todos.id, todos.title, todos.status ]
);
// UPDATE example
const result = await db.execute(
   "UPDATE todos SET title = ?, completed = ? WHERE id = ?",
   [ todos.title, todos.status, todos.id ]
);

---

select()

select<T>(query, bindValues?): Promise<T>

Defined in: index.ts:141

select

Passes in a SELECT query to the database for execution.

Type Parameters

T

T

Parameters

query

string

bindValues?

unknown[]

Returns

Promise<T>

Example

// for sqlite & postgres
const result = await db.select(
   "SELECT * from todos WHERE id = $1", [ id ]
);

// for mysql
const result = await db.select(
   "SELECT * from todos WHERE id = ?", [ id ]
);

---

get()

static get(path): Database

Defined in: index.ts:72

get

A static initializer which synchronously returns an instance of the Database class while deferring the actual database connection until the first invocation or selection on the database.

Sqlite

The path is relative to tauri::path::BaseDirectory::App and must start with sqlite:.

Parameters

path

string

Returns

Database

Example

const db = Database.get("sqlite:test.db");

---

load()

static load(path): Promise<Database>

Defined in: index.ts:48

load

A static initializer which connects to the underlying database and returns a Database instance once a connection to the database is established.

Sqlite

The path is relative to tauri::path::BaseDirectory::App and must start with sqlite:.

Parameters

path

string

Returns

Promise<Database>

Example

const db = await Database.load("sqlite:test.db");