Connection

import { Connection } from "https://raw.githubusercontent.com/crabmusket/deno_sqlite_plugin/master/src/mod.ts";

Represents an open database.

class Connection {

constructor(

sqlite: Sqlite,

path: string,

id: number,

);

_connection_id: number;

_original_path: string;

_sqlite: Sqlite;

async execute(statement: string, params?: Values): Promise<number>;

async query(statement: string, params?: Values): Promise<Values[]>;

}

§Constructors

new Connection(sqlite: Sqlite, path: string, id: number)

_connection_id: number

_original_path: string

_sqlite: Sqlite

execute(statement: string, params?: Values): Promise<number>

Run a sqlite statement. Use ? in the statement string as a placeholder and pass the values in the second argument.

@return

The number of rows affected by the statement.

query(statement: string, params?: Values): Promise<Values[]>

Perform a query to get data out.

@return

List of resulting rows that mathed the query. Note this is an array of arrays.