dbdts.db - npm Package Compare versions

Comparing version 1.0.0 to 2.0.1

dist/index.d.ts

@@ -6,4 +6,4 @@ import { Column } from "./structures/Column";
 import { Util } from "./util/Util";
-import { SqliteChanges, SqliteDataTypes, SqliteTableColumn, SqliteQueryOptions, DataResolvable, DataTypes, DatabaseEvents, DatabaseOptions, ColumnOptions, ColumnResolvable, WhereColumnOptions, TableResolvable, SortOptions } from "./typings/index";
-export { Database, Column, Table, Util, DatabaseError, SqliteChanges, SqliteDataTypes, SqliteTableColumn, SqliteQueryOptions, DataResolvable, DataTypes, DatabaseEvents, DatabaseOptions, ColumnOptions, ColumnResolvable, WhereColumnOptions, TableResolvable, SortOptions };
+import { SqliteChanges, SqliteDataTypes, SqliteTableColumn, SqliteQueryOptions, DataResolvable, DataTypes, DatabaseEvents, DatabaseOptions, ColumnOptions, ColumnResolvable, WhereColumnOptions, TableResolvable, SortOptions, InnerJoinOptions } from "./typings/index";
+export { InnerJoinOptions, Database, Column, Table, Util, DatabaseError, SqliteChanges, SqliteDataTypes, SqliteTableColumn, SqliteQueryOptions, DataResolvable, DataTypes, DatabaseEvents, DatabaseOptions, ColumnOptions, ColumnResolvable, WhereColumnOptions, TableResolvable, SortOptions };
 //# sourceMappingURL=index.d.ts.map

dist/index.js

@@ -0,0 +0,0 @@ "use strict";

dist/structures/Column.d.ts

@@ -0,0 +0,0 @@ import { ColumnOptions, ColumnResolvable, DataTypes, SqliteDataTypes } from "../typings";

dist/structures/Column.js

@@ -0,0 +0,0 @@ "use strict";

dist/structures/Database.d.ts

 import { TypedEmitter } from "tiny-typed-emitter";
 import sql from "better-sqlite3";
-import { DatabaseEvents, DatabaseOptions, DataResolvable, SqliteQueryOptions, TableResolvable } from "../typings";
+import { DatabaseEvents, DatabaseOptions, DataResolvable, SortOptions, SqliteQueryOptions, TableResolvable } from "../typings";
 import { Table } from "./Table";
@@ -14,2 +14,6 @@ /**
     /**
+     * Date at which the database started.
+     */
+    readyAt?: Date;
+    /**
      * The options for this database.
@@ -47,2 +51,8 @@ */
     /**
+     * Adds a table to this database.
+     * @param table The table to add.
+     * @returns The database this table was added to.
+     */
+    addTable(table: Table): this;
+    /**
      * Returns the corresponding array from given map.
@@ -53,2 +63,3 @@ * @param map The map to convert.
     arrayFromMap(map: any): Table[];
+    get readyTimestamp(): number | undefined;
     /**
@@ -73,2 +84,32 @@ * Gets data from a table.
     /**
+     * Gets the position of a row in a table.
+     * @param table The table to get row position from.
+     * @param sortOptions Options for sorting this query.
+     * @param whereOptions Options to filter this query.
+     * @returns The position or positions of rows (and possibly their data if multiple).
+     * @example
+     * const posOf = db.get("mytable", {
+     *      columns: ["bank"]
+     * }, {
+     *      where: {
+     *          column: "id",
+     *          equals: "123456"
+     *      }
+     * })
+     *
+     * console.log(posOf.position)
+     */
+    getRowPosition(table: TableResolvable, sortOptions: SortOptions, whereOptions?: SqliteQueryOptions): {
+        position: number;
+    } | DataResolvable[];
+    /**
+     * Get total row count in a table.
+     * @param table The table to get row count from.
+     * @param options The options for this query.
+     * @returns An object with the count property.
+     */
+    getRowCount(table: TableResolvable, options?: SqliteQueryOptions): {
+        count: number;
+    };
+    /**
      * Sets a row into the database (or updates existing one).
@@ -115,4 +156,9 @@ * @param table The table to perform this action on.
     connect(): Promise<this>;
+    /**
+     * Closes this database connection.
+     * @returns
+     */
+    close(): true;
 }
 export default Database;
 //# sourceMappingURL=Database.d.ts.map

dist/structures/Database.js

@@ -67,2 +67,11 @@ "use strict";
     /**
+     * Adds a table to this database.
+     * @param table The table to add.
+     * @returns The database this table was added to.
+     */
+    addTable(table) {
+        this.tables.set(table.name, table);
+        return this;
+    }
+    /**
      * Returns the corresponding array from given map.
@@ -75,2 +84,5 @@ * @param map The map to convert.
     }
+    get readyTimestamp() {
+        return this.readyAt ? this.readyAt.getTime() : undefined;
+    }
     /**
@@ -118,2 +130,32 @@ * Gets data from a table.
     /**
+     * Gets the position of a row in a table.
+     * @param table The table to get row position from.
+     * @param sortOptions Options for sorting this query.
+     * @param whereOptions Options to filter this query.
+     * @returns The position or positions of rows (and possibly their data if multiple).
+     * @example
+     * const posOf = db.get("mytable", {
+     *      columns: ["bank"]
+     * }, {
+     *      where: {
+     *          column: "id",
+     *          equals: "123456"
+     *      }
+     * })
+     *
+     * console.log(posOf.position)
+     */
+    getRowPosition(table, sortOptions, whereOptions) {
+        return this.resolveTable(table).getRowPosition(sortOptions, whereOptions);
+    }
+    /**
+     * Get total row count in a table.
+     * @param table The table to get row count from.
+     * @param options The options for this query.
+     * @returns An object with the count property.
+     */
+    getRowCount(table, options) {
+        return this.resolveTable(table).getRowCount(options);
+    }
+    /**
      * Sets a row into the database (or updates existing one).
@@ -173,2 +215,3 @@ * @param table The table to perform this action on.
             }
+            this.readyAt = new Date();
             this.emit("ready");
@@ -178,4 +221,14 @@ resolve(this);
     }
+    /**
+     * Closes this database connection.
+     * @returns
+     */
+    close() {
+        var _a;
+        (_a = this.db) === null || _a === void 0 ? void 0 : _a.close();
+        this.readyAt = undefined;
+        return true;
+    }
 }
 exports.default = Database;
 //# sourceMappingURL=Database.js.map

dist/structures/DatabaseError.d.ts

@@ -0,0 +0,0 @@ declare class DatabaseError extends TypeError {

dist/structures/DatabaseError.js

@@ -0,0 +0,0 @@ "use strict";

dist/structures/Table.d.ts

@@ -1,12 +0,46 @@
-import { ColumnResolvable, DataResolvable, DataTypes, SqliteChanges, SqliteQueryOptions, SqliteTableColumn } from "../typings";
+import { ColumnResolvable, DataResolvable, DataTypes, SortOptions, SqliteChanges, SqliteQueryOptions, SqliteTableColumn } from "../typings";
 import { Column } from "./Column";
 import Database from "./Database";
+/**
+ * Manages sqlite methods for a table.
+ */
 declare class Table {
+    /**
+     * The database for this table.
+     */
     db: Database;
+    /**
+     * The name of this table.
+     */
     name: string;
+    /**
+     * The raw unresolved columns for this table.
+     */
     _columns: ColumnResolvable[];
+    /**
+     * The columns that were instantiated once connecting to database.
+     */
     columns: Column[];
+    /**
+     * Whether the table is ready.
+     */
     ready: boolean;
+    /**
+     *
+     * @param name The name of the table.
+     * @param db The database this table belongs to.
+     * @param columns The columns to pre-define for this table
+     */
     constructor(name: string, db: Database, columns?: ColumnResolvable[]);
+    /**
+     * Sets the database for this table.
+     * @param db The database to attach this table to.
+     * @returns The table in case.
+     */
     setDatabase(db: Database): this;
+    /**
+     * Sets the name to this table.
+     * @param str The new table name.
+     * @returns The table in case.
+     */
     setName(str: string): this;
@@ -19,2 +53,5 @@ transformColumns(): Column[];
     get columnCreator(): string;
+    getRowCount(options?: SqliteQueryOptions): {
+        count: number;
+    };
     getTableColumns(): SqliteTableColumn[];
@@ -24,6 +61,30 @@ create(): boolean;
     addColumn(column: ColumnResolvable, force?: boolean): this;
+    getRowPosition<K extends SqliteQueryOptions | undefined = undefined>(sortOptions: SortOptions, filterOptions: K): DataResolvable[] | {
+        position: number;
+    };
     get(options: SqliteQueryOptions): DataResolvable | undefined;
+    /**
+     * Retrieves all or multiple results from this table.
+     * @param options The options to use for filtering this query.
+     * @returns The results from this table.
+     */
     all(options?: SqliteQueryOptions): DataResolvable[];
+    /**
+     * Inserts one or multiple rows into this table, if there is a primary key for this table and it already exists, this will throw an error.
+     * @param data The row or rows to set into the table.
+     * @returns Sqlite change report.
+     */
     insert(data: DataResolvable[] | DataResolvable): SqliteChanges;
+    /**
+     * Deletes a row or rows from this table, leave empty to clean the entire table.
+     * @param options The options to filter this query.
+     * @returns The sqlite changes report.
+     */
     delete(options?: SqliteQueryOptions): SqliteChanges;
+    /**
+     * Sets a row into this table, or updates it if it already exists.
+     * @param data The data for this row.
+     * @param options Options to insert or update this row.
+     * @returns Sqlite changes report, if any.
+     */
     set(data: DataResolvable, options?: SqliteQueryOptions): (SqliteChanges | undefined)[];
@@ -30,0 +91,0 @@ }

dist/structures/Table.js

@@ -6,6 +6,25 @@ "use strict";
 const Column_1 = require("./Column");
+const DatabaseError_1 = require("./DatabaseError");
+/**
+ * Manages sqlite methods for a table.
+ */
 class Table {
+    /**
+     *
+     * @param name The name of the table.
+     * @param db The database this table belongs to.
+     * @param columns The columns to pre-define for this table
+     */
     constructor(name, db, columns) {
+        /**
+         * The raw unresolved columns for this table.
+         */
         this._columns = new Array();
+        /**
+         * The columns that were instantiated once connecting to database.
+         */
         this.columns = new Array();
+        /**
+         * Whether the table is ready.
+         */
         this.ready = false;
@@ -18,2 +37,7 @@ this.db = db;
     }
+    /**
+     * Sets the database for this table.
+     * @param db The database to attach this table to.
+     * @returns The table in case.
+     */
     setDatabase(db) {
@@ -23,2 +47,7 @@ this.db = db;
     }
+    /**
+     * Sets the name to this table.
+     * @param str The new table name.
+     * @returns The table in case.
+     */
     setName(str) {
@@ -46,2 +75,10 @@ this.name = str;
     }
+    getRowCount(options) {
+        var _a;
+        const opts = Util_1.Util.makeWhereOptions(options);
+        const data = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`SELECT COUNT() as count FROM ${this.name} ${opts}`).get();
+        return {
+            count: data.count
+        };
+    }
     getTableColumns() {
@@ -63,2 +100,3 @@ var _a;
             }
+            this.ready = true;
             return false;
@@ -68,2 +106,3 @@ }
         const e = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`CREATE TABLE ${this.name}(${this.columnCreator})`).run();
+        this.ready = true;
         return true;
@@ -84,15 +123,47 @@ }
     }
+    getRowPosition(sortOptions, filterOptions) {
+        var _a, _b;
+        const opts = Util_1.Util.makeSortOptions(sortOptions);
+        const where = Util_1.Util.makeWhereOptions(filterOptions);
+        const data = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`
+            SELECT * FROM ( 
+                SELECT
+                ROW_NUMBER () OVER ( 
+                ${opts} 
+                ) 
+                    RowNum,
+                    ${(_b = filterOptions === null || filterOptions === void 0 ? void 0 : filterOptions.columns) !== null && _b !== void 0 ? _b : "*"}
+                FROM
+                    ${this.name}
+                )
+            ${where}
+        `).all();
+        if (!data) {
+            throw new DatabaseError_1.DatabaseError(`Unknown data.`);
+        }
+        if (data.length !== 1) {
+            return data;
+        }
+        return {
+            position: data[0].RowNum
+        };
+    }
     get(options) {
-        var _a, _b;
+        var _a;
         const opts = Util_1.Util.makeWhereOptions(options);
-        const data = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`SELECT ${(_b = options.columns) !== null && _b !== void 0 ? _b : "*"} FROM ${this.name} ${opts}`).get();
+        const select = Util_1.Util.makeSelectOptions(options === null || options === void 0 ? void 0 : options.columns);
+        const inner = Util_1.Util.makeInnerJoinOptions(options.innerJoin);
+        console.log(`SELECT ${select.query} FROM ${this.name} ${inner} ${opts}`);
+        const data = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`SELECT ${select.query} FROM ${this.name} ${inner} ${opts}`).get();
         if (this.db.options.sanitize) {
             for (const column of this.getTypeColumns("JSON")) {
-                if (data[column.name] !== null) {
-                    data[column.name] = JSON.parse(data[column.name]);
+                const name = select.renamedColumns[column.name] ? select.renamedColumns[column.name] : column.name;
+                if (data[name] !== null && data[name] !== undefined) {
+                    data[name] = JSON.parse(data[name]);
                 }
             }
             for (const column of this.getTypeColumns("BOOLEAN")) {
-                if (data[column.name] !== null) {
-                    data[column.name] = data[column.name] === 1;
+                const name = select.renamedColumns[column.name] ? select.renamedColumns[column.name] : column.name;
+                if (data[name] !== null && data[name] !== undefined) {
+                    data[name] = data[name] === 1;
                 }
@@ -103,6 +174,13 @@ }
     }
+    /**
+     * Retrieves all or multiple results from this table.
+     * @param options The options to use for filtering this query.
+     * @returns The results from this table.
+     */
     all(options) {
-        var _a, _b;
+        var _a;
         const opts = Util_1.Util.makeWhereOptions(options);
-        const data = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`SELECT ${(_b = options === null || options === void 0 ? void 0 : options.columns) !== null && _b !== void 0 ? _b : "*"} FROM ${this.name} ${opts}`).all();
+        const inner = Util_1.Util.makeInnerJoinOptions(options === null || options === void 0 ? void 0 : options.innerJoin);
+        const select = Util_1.Util.makeSelectOptions(options === null || options === void 0 ? void 0 : options.columns);
+        const data = (_a = this.db.db) === null || _a === void 0 ? void 0 : _a.prepare(`SELECT ${select.query} FROM ${this.name} ${inner} ${opts}`).all();
         if (this.db.options.sanitize && this.db.options.length !== undefined) {
@@ -113,9 +191,11 @@ if (this.db.options.length > 0 && data.length <= this.db.options.length) {
                     for (const column of this.getTypeColumns("JSON")) {
-                        if (d[column.name] !== null) {
-                            d[column.name] = JSON.parse(d[column.name]);
+                        const name = select.renamedColumns[column.name] ? select.renamedColumns[column.name] : column.name;
+                        if (d[name] !== null && d[name] !== undefined) {
+                            d[name] = JSON.parse(d[name]);
                         }
                     }
                     for (const column of this.getTypeColumns("BOOLEAN")) {
-                        if (d[column.name] !== null) {
-                            d[column.name] = d[column.name] === 1;
+                        const name = select.renamedColumns[column.name] ? select.renamedColumns[column.name] : column.name;
+                        if (d[name] !== null && d[name] !== undefined) {
+                            d[name] = d[name] === 1;
                         }
@@ -128,2 +208,7 @@ }
     }
+    /**
+     * Inserts one or multiple rows into this table, if there is a primary key for this table and it already exists, this will throw an error.
+     * @param data The row or rows to set into the table.
+     * @returns Sqlite change report.
+     */
     insert(data) {
@@ -136,2 +221,7 @@ var _a;
     }
+    /**
+     * Deletes a row or rows from this table, leave empty to clean the entire table.
+     * @param options The options to filter this query.
+     * @returns The sqlite changes report.
+     */
     delete(options) {
@@ -142,2 +232,8 @@ var _a;
     }
+    /**
+     * Sets a row into this table, or updates it if it already exists.
+     * @param data The data for this row.
+     * @param options Options to insert or update this row.
+     * @returns Sqlite changes report, if any.
+     */
     set(data, options) {
@@ -144,0 +240,0 @@ var _a, _b;

dist/typings/index.d.ts

 import { Column } from "../structures/Column";
 import { Table } from "../structures/Table";
+export declare type If<A extends boolean, K, R = null> = A extends true ? K : A extends false ? R : R;
 /**
@@ -137,3 +138,24 @@ * Available options for the database.
 }
+export interface ColumnSelectOptions {
+    name: string;
+    as?: string;
+}
 /**
+ * Options to join a query with another table.
+ */
+export interface InnerJoinOptions {
+    /**
+     * Table to join with.
+     */
+    table: string;
+    /**
+     * Table we are joining from.
+     */
+    from: string;
+    /**
+     * Column to use to join these results.
+     */
+    column: string;
+}
+/**
  * The options for a sqlite query.
@@ -146,4 +168,8 @@ */
      */
-    columns: string[] | "*";
+    columns: string[] | "*" | ColumnSelectOptions[];
     /**
+     * Options to retrieve data from other tables.
+     */
+    innerJoin?: InnerJoinOptions[];
+    /**
      * Options to filter the query by.
@@ -150,0 +176,0 @@ */

dist/typings/index.js

 "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
 //# sourceMappingURL=index.js.map

dist/util/constants.d.ts

 import { DatabaseOptions } from "../typings";
 export declare const DefaultDatabaseOptions: DatabaseOptions;
 //# sourceMappingURL=constants.d.ts.map

dist/util/constants.js

@@ -0,0 +0,0 @@ "use strict";

dist/util/Util.d.ts

 import { Column } from "../structures/Column";
-import { SqliteQueryOptions } from "../typings";
+import { ColumnSelectOptions, InnerJoinOptions, SortOptions, SqliteQueryOptions } from "../typings";
+/**
+ * Contains utility functions to make interacting with the database easier.
+ */
 declare class Util extends null {
     constructor();
     static mergeDefault(target: any, source: any): any;
+    /**
+     * Creates inner join options for a query.
+     * @param options The options for joining tables.
+     * @returns The created inner join query.
+     */
+    static makeInnerJoinOptions(options?: InnerJoinOptions[]): string;
+    /**
+     * Creates select options for a query.
+     * @param options The options for this query selector.
+     * @returns The created selector.
+     */
+    static makeSelectOptions(options?: string[] | "*" | ColumnSelectOptions[]): {
+        query: string;
+        renamedColumns: Record<string, string>;
+    };
+    /**
+     * Makes filters for a query.
+     * @param options The options for this filter.
+     * @returns The returned filter for a query.
+     */
     static makeWhereOptions(options?: SqliteQueryOptions): string;
+    /**
+     * Creates columns for a table.
+     * @param data The object for columns.
+     * @returns The columns that were created from the object.
+     */
     static makeColumnsFrom(data: Record<string, any>): string;
+    /**
+     * Creates a string of sort options for this query.
+     * @param options The options for sorting the query.
+     * @returns The string to sort this query.
+     */
+    static makeSortOptions(options?: SortOptions): string;
+    /**
+     * Makes a string that is valid to insert values into sqlite.
+     * @param data The object containing data.
+     * @param columns The columns of the table.
+     * @returns The string to use against sqlite.
+     */
     static makeInsertValues(data: Record<string, any>, columns: Column[]): string;
+    /**
+     * Creates a set of values to update a row.
+     * @param data The object data to update with.
+     * @param columns The columns of the table.
+     * @returns The string that can be used to update this row.
+     */
     static makeSetValues(data: Record<string, any>, columns: Column[]): string;
+    /**
+     * Checks whether a number is valid for sqlite.
+     * @param n The number to check.
+     * @returns Whether the number is valid.
+     */
     static isNumber(n: any): boolean;
@@ -11,0 +62,0 @@ }

dist/util/Util.js

@@ -6,2 +6,5 @@ "use strict";
 const DatabaseError_1 = require("../structures/DatabaseError");
+/**
+ * Contains utility functions to make interacting with the database easier.
+ */
 class Util extends null {
@@ -22,2 +25,49 @@ constructor() { }
     }
+    /**
+     * Creates inner join options for a query.
+     * @param options The options for joining tables.
+     * @returns The created inner join query.
+     */
+    static makeInnerJoinOptions(options) {
+        if (!options)
+            return "";
+        const opts = [];
+        for (const opt of options) {
+            opts.push(`INNER JOIN ${opt.table} ON ${opt.table}.${opt.column} = ${opt.from}.${opt.column}`);
+        }
+        return opts.join(" \n");
+    }
+    /**
+     * Creates select options for a query.
+     * @param options The options for this query selector.
+     * @returns The created selector.
+     */
+    static makeSelectOptions(options) {
+        const renamedColumns = {};
+        if (!options || options === "*")
+            return {
+                renamedColumns,
+                query: "*"
+            };
+        const opts = [];
+        for (const opt of options) {
+            if (typeof opt === "object" && opt.as) {
+                renamedColumns[opt.name] = opt.as;
+            }
+            opts.push(typeof opt === "string" ?
+                opt :
+                opt.as ?
+                    `${opt.name} AS ${opt.as}` :
+                    opt.name);
+        }
+        return {
+            query: opts.join(", \n"),
+            renamedColumns
+        };
+    }
+    /**
+     * Makes filters for a query.
+     * @param options The options for this filter.
+     * @returns The returned filter for a query.
+     */
     static makeWhereOptions(options) {
@@ -85,5 +135,30 @@ var _a, _b;
     }
+    /**
+     * Creates columns for a table.
+     * @param data The object for columns.
+     * @returns The columns that were created from the object.
+     */
     static makeColumnsFrom(data) {
         return Object.keys(data).join(", ");
     }
+    /**
+     * Creates a string of sort options for this query.
+     * @param options The options for sorting the query.
+     * @returns The string to sort this query.
+     */
+    static makeSortOptions(options) {
+        var _a, _b;
+        if (!options)
+            return "";
+        const total = [];
+        const columns = Array.isArray(options.column) ? options.column : [options.column];
+        total.push(`ORDER BY (${columns.join((_a = options.operator) !== null && _a !== void 0 ? _a : "+")}) ${(_b = options.order) !== null && _b !== void 0 ? _b : "DESC"}`);
+        return total.join(" \n");
+    }
+    /**
+     * Makes a string that is valid to insert values into sqlite.
+     * @param data The object containing data.
+     * @param columns The columns of the table.
+     * @returns The string to use against sqlite.
+     */
     static makeInsertValues(data, columns) {
@@ -99,2 +174,8 @@ const got = [];
     }
+    /**
+     * Creates a set of values to update a row.
+     * @param data The object data to update with.
+     * @param columns The columns of the table.
+     * @returns The string that can be used to update this row.
+     */
     static makeSetValues(data, columns) {
@@ -110,4 +191,9 @@ const got = [];
     }
+    /**
+     * Checks whether a number is valid for sqlite.
+     * @param n The number to check.
+     * @returns Whether the number is valid.
+     */
     static isNumber(n) {
-        return isNaN(Number(n)) && n <= Number.MAX_SAFE_INTEGER && n >= Number.MIN_SAFE_INTEGER;
+        return !isNaN(Number(n)) && n <= Number.MAX_SAFE_INTEGER && n >= Number.MIN_SAFE_INTEGER;
     }
@@ -114,0 +200,0 @@ }

docs/assets/js/search.js

@@ -1,1 +0,1 @@
-window.searchData = {"kinds":{"128":"Class","256":"Interface","512":"Constructor","1024":"Property","2048":"Method","65536":"Type literal","262144":"Accessor","4194304":"Type alias"},"rows":[{"id":0,"kind":128,"name":"Database","url":"classes/Database.html","classes":"tsd-kind-class"},{"id":1,"kind":512,"name":"constructor","url":"classes/Database.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class tsd-is-overwrite","parent":"Database"},{"id":2,"kind":1024,"name":"db","url":"classes/Database.html#db","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":3,"kind":1024,"name":"options","url":"classes/Database.html#options","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":4,"kind":1024,"name":"tables","url":"classes/Database.html#tables","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":5,"kind":2048,"name":"_validateOptions","url":"classes/Database.html#_validateOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-private","parent":"Database"},{"id":6,"kind":2048,"name":"resolveTable","url":"classes/Database.html#resolveTable","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":7,"kind":2048,"name":"createTable","url":"classes/Database.html#createTable","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":8,"kind":2048,"name":"arrayFromMap","url":"classes/Database.html#arrayFromMap","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":9,"kind":2048,"name":"getTableData","url":"classes/Database.html#getTableData","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":10,"kind":262144,"name":"databaseTables","url":"classes/Database.html#databaseTables","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Database"},{"id":11,"kind":2048,"name":"all","url":"classes/Database.html#all","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":12,"kind":2048,"name":"set","url":"classes/Database.html#set","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":13,"kind":2048,"name":"delete","url":"classes/Database.html#delete","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":14,"kind":2048,"name":"insert","url":"classes/Database.html#insert","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":15,"kind":2048,"name":"get","url":"classes/Database.html#get","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":16,"kind":2048,"name":"connect","url":"classes/Database.html#connect","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":17,"kind":128,"name":"Column","url":"classes/Column.html","classes":"tsd-kind-class"},{"id":18,"kind":2048,"name":"transform","url":"classes/Column.html#transform","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Column"},{"id":19,"kind":2048,"name":"transformValue","url":"classes/Column.html#transformValue","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Column"},{"id":20,"kind":512,"name":"constructor","url":"classes/Column.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class","parent":"Column"},{"id":21,"kind":1024,"name":"name","url":"classes/Column.html#name","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":22,"kind":1024,"name":"default","url":"classes/Column.html#default","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":23,"kind":1024,"name":"notNull","url":"classes/Column.html#notNull","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":24,"kind":1024,"name":"primary","url":"classes/Column.html#primary","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":25,"kind":1024,"name":"type","url":"classes/Column.html#type","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":26,"kind":1024,"name":"_default","url":"classes/Column.html#_default","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":27,"kind":1024,"name":"db","url":"classes/Column.html#db","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":28,"kind":2048,"name":"attachDatabase","url":"classes/Column.html#attachDatabase","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":29,"kind":2048,"name":"getRealType","url":"classes/Column.html#getRealType","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":30,"kind":2048,"name":"hasDatabase","url":"classes/Column.html#hasDatabase","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":31,"kind":2048,"name":"create","url":"classes/Column.html#create","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":32,"kind":262144,"name":"creator","url":"classes/Column.html#creator","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Column"},{"id":33,"kind":2048,"name":"setName","url":"classes/Column.html#setName","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":34,"kind":2048,"name":"setType","url":"classes/Column.html#setType","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":35,"kind":2048,"name":"setDefault","url":"classes/Column.html#setDefault","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":36,"kind":262144,"name":"defaultValue","url":"classes/Column.html#defaultValue","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Column"},{"id":37,"kind":2048,"name":"setNotNull","url":"classes/Column.html#setNotNull","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":38,"kind":2048,"name":"setPrimary","url":"classes/Column.html#setPrimary","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":39,"kind":128,"name":"Table","url":"classes/Table.html","classes":"tsd-kind-class"},{"id":40,"kind":512,"name":"constructor","url":"classes/Table.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class","parent":"Table"},{"id":41,"kind":1024,"name":"db","url":"classes/Table.html#db","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":42,"kind":1024,"name":"name","url":"classes/Table.html#name","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":43,"kind":1024,"name":"_columns","url":"classes/Table.html#_columns","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":44,"kind":1024,"name":"columns","url":"classes/Table.html#columns","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":45,"kind":1024,"name":"ready","url":"classes/Table.html#ready","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":46,"kind":2048,"name":"setDatabase","url":"classes/Table.html#setDatabase","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":47,"kind":2048,"name":"setName","url":"classes/Table.html#setName","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":48,"kind":2048,"name":"transformColumns","url":"classes/Table.html#transformColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":49,"kind":2048,"name":"getTypeColumns","url":"classes/Table.html#getTypeColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":50,"kind":2048,"name":"getColumns","url":"classes/Table.html#getColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":51,"kind":2048,"name":"getColumn","url":"classes/Table.html#getColumn","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":52,"kind":2048,"name":"isReady","url":"classes/Table.html#isReady","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":53,"kind":262144,"name":"columnCreator","url":"classes/Table.html#columnCreator","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Table"},{"id":54,"kind":2048,"name":"getTableColumns","url":"classes/Table.html#getTableColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":55,"kind":2048,"name":"create","url":"classes/Table.html#create","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":56,"kind":2048,"name":"addColumns","url":"classes/Table.html#addColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":57,"kind":2048,"name":"addColumn","url":"classes/Table.html#addColumn","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":58,"kind":2048,"name":"get","url":"classes/Table.html#get","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":59,"kind":2048,"name":"all","url":"classes/Table.html#all","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":60,"kind":2048,"name":"insert","url":"classes/Table.html#insert","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":61,"kind":2048,"name":"delete","url":"classes/Table.html#delete","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":62,"kind":2048,"name":"set","url":"classes/Table.html#set","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":63,"kind":128,"name":"Util","url":"classes/Util.html","classes":"tsd-kind-class"},{"id":64,"kind":2048,"name":"mergeDefault","url":"classes/Util.html#mergeDefault","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":65,"kind":2048,"name":"makeWhereOptions","url":"classes/Util.html#makeWhereOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":66,"kind":2048,"name":"makeColumnsFrom","url":"classes/Util.html#makeColumnsFrom","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":67,"kind":2048,"name":"makeInsertValues","url":"classes/Util.html#makeInsertValues","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":68,"kind":2048,"name":"makeSetValues","url":"classes/Util.html#makeSetValues","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":69,"kind":2048,"name":"isNumber","url":"classes/Util.html#isNumber","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":70,"kind":512,"name":"constructor","url":"classes/Util.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class tsd-is-overwrite","parent":"Util"},{"id":71,"kind":128,"name":"DatabaseError","url":"classes/DatabaseError.html","classes":"tsd-kind-class"},{"id":72,"kind":65536,"name":"__type","url":"classes/DatabaseError.html#__type","classes":"tsd-kind-type-literal tsd-parent-kind-class","parent":"DatabaseError"},{"id":73,"kind":512,"name":"constructor","url":"classes/DatabaseError.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class tsd-is-overwrite","parent":"DatabaseError"},{"id":74,"kind":256,"name":"SqliteChanges","url":"interfaces/SqliteChanges.html","classes":"tsd-kind-interface"},{"id":75,"kind":1024,"name":"changes","url":"interfaces/SqliteChanges.html#changes","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteChanges"},{"id":76,"kind":1024,"name":"lastInsertRowid","url":"interfaces/SqliteChanges.html#lastInsertRowid","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteChanges"},{"id":77,"kind":4194304,"name":"SqliteDataTypes","url":"modules.html#SqliteDataTypes","classes":"tsd-kind-type-alias"},{"id":78,"kind":256,"name":"SqliteTableColumn","url":"interfaces/SqliteTableColumn.html","classes":"tsd-kind-interface"},{"id":79,"kind":1024,"name":"cid","url":"interfaces/SqliteTableColumn.html#cid","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":80,"kind":1024,"name":"name","url":"interfaces/SqliteTableColumn.html#name","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":81,"kind":1024,"name":"type","url":"interfaces/SqliteTableColumn.html#type","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":82,"kind":1024,"name":"notnull","url":"interfaces/SqliteTableColumn.html#notnull","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":83,"kind":1024,"name":"dflt_value","url":"interfaces/SqliteTableColumn.html#dflt_value","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":84,"kind":1024,"name":"pk","url":"interfaces/SqliteTableColumn.html#pk","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":85,"kind":256,"name":"SqliteQueryOptions","url":"interfaces/SqliteQueryOptions.html","classes":"tsd-kind-interface"},{"id":86,"kind":1024,"name":"columns","url":"interfaces/SqliteQueryOptions.html#columns","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":87,"kind":1024,"name":"where","url":"interfaces/SqliteQueryOptions.html#where","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":88,"kind":1024,"name":"limit","url":"interfaces/SqliteQueryOptions.html#limit","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":89,"kind":1024,"name":"offset","url":"interfaces/SqliteQueryOptions.html#offset","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":90,"kind":1024,"name":"sort","url":"interfaces/SqliteQueryOptions.html#sort","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":91,"kind":4194304,"name":"DataResolvable","url":"modules.html#DataResolvable","classes":"tsd-kind-type-alias"},{"id":92,"kind":4194304,"name":"DataTypes","url":"modules.html#DataTypes","classes":"tsd-kind-type-alias"},{"id":93,"kind":256,"name":"DatabaseEvents","url":"interfaces/DatabaseEvents.html","classes":"tsd-kind-interface"},{"id":94,"kind":2048,"name":"ready","url":"interfaces/DatabaseEvents.html#ready","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":95,"kind":2048,"name":"dataSet","url":"interfaces/DatabaseEvents.html#dataSet","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":96,"kind":2048,"name":"dataGet","url":"interfaces/DatabaseEvents.html#dataGet","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":97,"kind":2048,"name":"dataDelete","url":"interfaces/DatabaseEvents.html#dataDelete","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":98,"kind":256,"name":"DatabaseOptions","url":"interfaces/DatabaseOptions.html","classes":"tsd-kind-interface"},{"id":99,"kind":1024,"name":"path","url":"interfaces/DatabaseOptions.html#path","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"DatabaseOptions"},{"id":100,"kind":1024,"name":"sanitize","url":"interfaces/DatabaseOptions.html#sanitize","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"DatabaseOptions"},{"id":101,"kind":1024,"name":"length","url":"interfaces/DatabaseOptions.html#length","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"DatabaseOptions"},{"id":102,"kind":256,"name":"ColumnOptions","url":"interfaces/ColumnOptions.html","classes":"tsd-kind-interface"},{"id":103,"kind":1024,"name":"name","url":"interfaces/ColumnOptions.html#name","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":104,"kind":1024,"name":"default","url":"interfaces/ColumnOptions.html#default","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":105,"kind":1024,"name":"notNull","url":"interfaces/ColumnOptions.html#notNull","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":106,"kind":1024,"name":"primary","url":"interfaces/ColumnOptions.html#primary","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":107,"kind":1024,"name":"type","url":"interfaces/ColumnOptions.html#type","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":108,"kind":4194304,"name":"ColumnResolvable","url":"modules.html#ColumnResolvable","classes":"tsd-kind-type-alias"},{"id":109,"kind":256,"name":"WhereColumnOptions","url":"interfaces/WhereColumnOptions.html","classes":"tsd-kind-interface"},{"id":110,"kind":1024,"name":"column","url":"interfaces/WhereColumnOptions.html#column","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":111,"kind":1024,"name":"equals","url":"interfaces/WhereColumnOptions.html#equals","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":112,"kind":1024,"name":"greater","url":"interfaces/WhereColumnOptions.html#greater","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":113,"kind":1024,"name":"lesser","url":"interfaces/WhereColumnOptions.html#lesser","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":114,"kind":1024,"name":"lesserEquals","url":"interfaces/WhereColumnOptions.html#lesserEquals","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":115,"kind":1024,"name":"greaterEquals","url":"interfaces/WhereColumnOptions.html#greaterEquals","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":116,"kind":1024,"name":"in","url":"interfaces/WhereColumnOptions.html#in","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":117,"kind":1024,"name":"startsWith","url":"interfaces/WhereColumnOptions.html#startsWith","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":118,"kind":1024,"name":"endsWith","url":"interfaces/WhereColumnOptions.html#endsWith","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":119,"kind":1024,"name":"notEqual","url":"interfaces/WhereColumnOptions.html#notEqual","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":120,"kind":1024,"name":"includes","url":"interfaces/WhereColumnOptions.html#includes","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":121,"kind":1024,"name":"or","url":"interfaces/WhereColumnOptions.html#or","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":122,"kind":1024,"name":"not","url":"interfaces/WhereColumnOptions.html#not","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":123,"kind":4194304,"name":"TableResolvable","url":"modules.html#TableResolvable","classes":"tsd-kind-type-alias"},{"id":124,"kind":256,"name":"SortOptions","url":"interfaces/SortOptions.html","classes":"tsd-kind-interface"},{"id":125,"kind":1024,"name":"column","url":"interfaces/SortOptions.html#column","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SortOptions"},{"id":126,"kind":1024,"name":"order","url":"interfaces/SortOptions.html#order","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SortOptions"},{"id":127,"kind":1024,"name":"operator","url":"interfaces/SortOptions.html#operator","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SortOptions"}],"index":{"version":"2.3.9","fields":["name","parent"],"fieldVectors":[["name/0",[0,19.976]],["parent/0",[]],["name/1",[1,31.551]],["parent/1",[0,1.872]],["name/2",[2,36.07]],["parent/2",[0,1.872]],["name/3",[3,44.543]],["parent/3",[0,1.872]],["name/4",[4,44.543]],["parent/4",[0,1.872]],["name/5",[5,44.543]],["parent/5",[0,1.872]],["name/6",[6,44.543]],["parent/6",[0,1.872]],["name/7",[7,44.543]],["parent/7",[0,1.872]],["name/8",[8,44.543]],["parent/8",[0,1.872]],["name/9",[9,44.543]],["parent/9",[0,1.872]],["name/10",[10,44.543]],["parent/10",[0,1.872]],["name/11",[11,39.435]],["parent/11",[0,1.872]],["name/12",[12,39.435]],["parent/12",[0,1.872]],["name/13",[13,39.435]],["parent/13",[0,1.872]],["name/14",[14,39.435]],["parent/14",[0,1.872]],["name/15",[15,39.435]],["parent/15",[0,1.872]],["name/16",[16,44.543]],["parent/16",[0,1.872]],["name/17",[17,16.611]],["parent/17",[]],["name/18",[18,44.543]],["parent/18",[17,1.557]],["name/19",[19,44.543]],["parent/19",[17,1.557]],["name/20",[1,31.551]],["parent/20",[17,1.557]],["name/21",[20,33.557]],["parent/21",[17,1.557]],["name/22",[21,39.435]],["parent/22",[17,1.557]],["name/23",[22,36.07]],["parent/23",[17,1.557]],["name/24",[23,39.435]],["parent/24",[17,1.557]],["name/25",[24,36.07]],["parent/25",[17,1.557]],["name/26",[25,44.543]],["parent/26",[17,1.557]],["name/27",[2,36.07]],["parent/27",[17,1.557]],["name/28",[26,44.543]],["parent/28",[17,1.557]],["name/29",[27,44.543]],["parent/29",[17,1.557]],["name/30",[28,44.543]],["parent/30",[17,1.557]],["name/31",[29,39.435]],["parent/31",[17,1.557]],["name/32",[30,44.543]],["parent/32",[17,1.557]],["name/33",[31,39.435]],["parent/33",[17,1.557]],["name/34",[32,44.543]],["parent/34",[17,1.557]],["name/35",[33,44.543]],["parent/35",[17,1.557]],["name/36",[34,44.543]],["parent/36",[17,1.557]],["name/37",[35,44.543]],["parent/37",[17,1.557]],["name/38",[36,44.543]],["parent/38",[17,1.557]],["name/39",[37,16.611]],["parent/39",[]],["name/40",[1,31.551]],["parent/40",[37,1.557]],["name/41",[2,36.07]],["parent/41",[37,1.557]],["name/42",[20,33.557]],["parent/42",[37,1.557]],["name/43",[38,44.543]],["parent/43",[37,1.557]],["name/44",[39,39.435]],["parent/44",[37,1.557]],["name/45",[40,39.435]],["parent/45",[37,1.557]],["name/46",[41,44.543]],["parent/46",[37,1.557]],["name/47",[31,39.435]],["parent/47",[37,1.557]],["name/48",[42,44.543]],["parent/48",[37,1.557]],["name/49",[43,44.543]],["parent/49",[37,1.557]],["name/50",[44,44.543]],["parent/50",[37,1.557]],["name/51",[45,44.543]],["parent/51",[37,1.557]],["name/52",[46,44.543]],["parent/52",[37,1.557]],["name/53",[47,44.543]],["parent/53",[37,1.557]],["name/54",[48,44.543]],["parent/54",[37,1.557]],["name/55",[29,39.435]],["parent/55",[37,1.557]],["name/56",[49,44.543]],["parent/56",[37,1.557]],["name/57",[50,44.543]],["parent/57",[37,1.557]],["name/58",[15,39.435]],["parent/58",[37,1.557]],["name/59",[11,39.435]],["parent/59",[37,1.557]],["name/60",[14,39.435]],["parent/60",[37,1.557]],["name/61",[13,39.435]],["parent/61",[37,1.557]],["name/62",[12,39.435]],["parent/62",[37,1.557]],["name/63",[51,27.197]],["parent/63",[]],["name/64",[52,44.543]],["parent/64",[51,2.549]],["name/65",[53,44.543]],["parent/65",[51,2.549]],["name/66",[54,44.543]],["parent/66",[51,2.549]],["name/67",[55,44.543]],["parent/67",[51,2.549]],["name/68",[56,44.543]],["parent/68",[51,2.549]],["name/69",[57,44.543]],["parent/69",[51,2.549]],["name/70",[1,31.551]],["parent/70",[51,2.549]],["name/71",[58,36.07]],["parent/71",[]],["name/72",[59,44.543]],["parent/72",[58,3.381]],["name/73",[1,31.551]],["parent/73",[58,3.381]],["name/74",[60,36.07]],["parent/74",[]],["name/75",[61,44.543]],["parent/75",[60,3.381]],["name/76",[62,44.543]],["parent/76",[60,3.381]],["name/77",[63,44.543]],["parent/77",[]],["name/78",[64,28.449]],["parent/78",[]],["name/79",[65,44.543]],["parent/79",[64,2.666]],["name/80",[20,33.557]],["parent/80",[64,2.666]],["name/81",[24,36.07]],["parent/81",[64,2.666]],["name/82",[22,36.07]],["parent/82",[64,2.666]],["name/83",[66,44.543]],["parent/83",[64,2.666]],["name/84",[67,44.543]],["parent/84",[64,2.666]],["name/85",[68,29.88]],["parent/85",[]],["name/86",[39,39.435]],["parent/86",[68,2.801]],["name/87",[69,44.543]],["parent/87",[68,2.801]],["name/88",[70,44.543]],["parent/88",[68,2.801]],["name/89",[71,44.543]],["parent/89",[68,2.801]],["name/90",[72,44.543]],["parent/90",[68,2.801]],["name/91",[73,44.543]],["parent/91",[]],["name/92",[74,44.543]],["parent/92",[]],["name/93",[75,31.551]],["parent/93",[]],["name/94",[40,39.435]],["parent/94",[75,2.957]],["name/95",[76,44.543]],["parent/95",[75,2.957]],["name/96",[77,44.543]],["parent/96",[75,2.957]],["name/97",[78,44.543]],["parent/97",[75,2.957]],["name/98",[79,33.557]],["parent/98",[]],["name/99",[80,44.543]],["parent/99",[79,3.145]],["name/100",[81,44.543]],["parent/100",[79,3.145]],["name/101",[82,44.543]],["parent/101",[79,3.145]],["name/102",[83,29.88]],["parent/102",[]],["name/103",[20,33.557]],["parent/103",[83,2.801]],["name/104",[21,39.435]],["parent/104",[83,2.801]],["name/105",[22,36.07]],["parent/105",[83,2.801]],["name/106",[23,39.435]],["parent/106",[83,2.801]],["name/107",[24,36.07]],["parent/107",[83,2.801]],["name/108",[84,44.543]],["parent/108",[]],["name/109",[85,21.857]],["parent/109",[]],["name/110",[17,16.611]],["parent/110",[85,2.049]],["name/111",[86,44.543]],["parent/111",[85,2.049]],["name/112",[87,44.543]],["parent/112",[85,2.049]],["name/113",[88,44.543]],["parent/113",[85,2.049]],["name/114",[89,44.543]],["parent/114",[85,2.049]],["name/115",[90,44.543]],["parent/115",[85,2.049]],["name/116",[91,44.543]],["parent/116",[85,2.049]],["name/117",[92,44.543]],["parent/117",[85,2.049]],["name/118",[93,44.543]],["parent/118",[85,2.049]],["name/119",[94,44.543]],["parent/119",[85,2.049]],["name/120",[95,44.543]],["parent/120",[85,2.049]],["name/121",[96,44.543]],["parent/121",[85,2.049]],["name/122",[97,44.543]],["parent/122",[85,2.049]],["name/123",[98,44.543]],["parent/123",[]],["name/124",[99,33.557]],["parent/124",[]],["name/125",[17,16.611]],["parent/125",[99,3.145]],["name/126",[100,44.543]],["parent/126",[99,3.145]],["name/127",[101,44.543]],["parent/127",[99,3.145]]],"invertedIndex":[["__type",{"_index":59,"name":{"72":{}},"parent":{}}],["_columns",{"_index":38,"name":{"43":{}},"parent":{}}],["_default",{"_index":25,"name":{"26":{}},"parent":{}}],["_validateoptions",{"_index":5,"name":{"5":{}},"parent":{}}],["addcolumn",{"_index":50,"name":{"57":{}},"parent":{}}],["addcolumns",{"_index":49,"name":{"56":{}},"parent":{}}],["all",{"_index":11,"name":{"11":{},"59":{}},"parent":{}}],["arrayfrommap",{"_index":8,"name":{"8":{}},"parent":{}}],["attachdatabase",{"_index":26,"name":{"28":{}},"parent":{}}],["changes",{"_index":61,"name":{"75":{}},"parent":{}}],["cid",{"_index":65,"name":{"79":{}},"parent":{}}],["column",{"_index":17,"name":{"17":{},"110":{},"125":{}},"parent":{"18":{},"19":{},"20":{},"21":{},"22":{},"23":{},"24":{},"25":{},"26":{},"27":{},"28":{},"29":{},"30":{},"31":{},"32":{},"33":{},"34":{},"35":{},"36":{},"37":{},"38":{}}}],["columncreator",{"_index":47,"name":{"53":{}},"parent":{}}],["columnoptions",{"_index":83,"name":{"102":{}},"parent":{"103":{},"104":{},"105":{},"106":{},"107":{}}}],["columnresolvable",{"_index":84,"name":{"108":{}},"parent":{}}],["columns",{"_index":39,"name":{"44":{},"86":{}},"parent":{}}],["connect",{"_index":16,"name":{"16":{}},"parent":{}}],["constructor",{"_index":1,"name":{"1":{},"20":{},"40":{},"70":{},"73":{}},"parent":{}}],["create",{"_index":29,"name":{"31":{},"55":{}},"parent":{}}],["createtable",{"_index":7,"name":{"7":{}},"parent":{}}],["creator",{"_index":30,"name":{"32":{}},"parent":{}}],["database",{"_index":0,"name":{"0":{}},"parent":{"1":{},"2":{},"3":{},"4":{},"5":{},"6":{},"7":{},"8":{},"9":{},"10":{},"11":{},"12":{},"13":{},"14":{},"15":{},"16":{}}}],["databaseerror",{"_index":58,"name":{"71":{}},"parent":{"72":{},"73":{}}}],["databaseevents",{"_index":75,"name":{"93":{}},"parent":{"94":{},"95":{},"96":{},"97":{}}}],["databaseoptions",{"_index":79,"name":{"98":{}},"parent":{"99":{},"100":{},"101":{}}}],["databasetables",{"_index":10,"name":{"10":{}},"parent":{}}],["datadelete",{"_index":78,"name":{"97":{}},"parent":{}}],["dataget",{"_index":77,"name":{"96":{}},"parent":{}}],["dataresolvable",{"_index":73,"name":{"91":{}},"parent":{}}],["dataset",{"_index":76,"name":{"95":{}},"parent":{}}],["datatypes",{"_index":74,"name":{"92":{}},"parent":{}}],["db",{"_index":2,"name":{"2":{},"27":{},"41":{}},"parent":{}}],["default",{"_index":21,"name":{"22":{},"104":{}},"parent":{}}],["defaultvalue",{"_index":34,"name":{"36":{}},"parent":{}}],["delete",{"_index":13,"name":{"13":{},"61":{}},"parent":{}}],["dflt_value",{"_index":66,"name":{"83":{}},"parent":{}}],["endswith",{"_index":93,"name":{"118":{}},"parent":{}}],["equals",{"_index":86,"name":{"111":{}},"parent":{}}],["get",{"_index":15,"name":{"15":{},"58":{}},"parent":{}}],["getcolumn",{"_index":45,"name":{"51":{}},"parent":{}}],["getcolumns",{"_index":44,"name":{"50":{}},"parent":{}}],["getrealtype",{"_index":27,"name":{"29":{}},"parent":{}}],["gettablecolumns",{"_index":48,"name":{"54":{}},"parent":{}}],["gettabledata",{"_index":9,"name":{"9":{}},"parent":{}}],["gettypecolumns",{"_index":43,"name":{"49":{}},"parent":{}}],["greater",{"_index":87,"name":{"112":{}},"parent":{}}],["greaterequals",{"_index":90,"name":{"115":{}},"parent":{}}],["hasdatabase",{"_index":28,"name":{"30":{}},"parent":{}}],["in",{"_index":91,"name":{"116":{}},"parent":{}}],["includes",{"_index":95,"name":{"120":{}},"parent":{}}],["insert",{"_index":14,"name":{"14":{},"60":{}},"parent":{}}],["isnumber",{"_index":57,"name":{"69":{}},"parent":{}}],["isready",{"_index":46,"name":{"52":{}},"parent":{}}],["lastinsertrowid",{"_index":62,"name":{"76":{}},"parent":{}}],["length",{"_index":82,"name":{"101":{}},"parent":{}}],["lesser",{"_index":88,"name":{"113":{}},"parent":{}}],["lesserequals",{"_index":89,"name":{"114":{}},"parent":{}}],["limit",{"_index":70,"name":{"88":{}},"parent":{}}],["makecolumnsfrom",{"_index":54,"name":{"66":{}},"parent":{}}],["makeinsertvalues",{"_index":55,"name":{"67":{}},"parent":{}}],["makesetvalues",{"_index":56,"name":{"68":{}},"parent":{}}],["makewhereoptions",{"_index":53,"name":{"65":{}},"parent":{}}],["mergedefault",{"_index":52,"name":{"64":{}},"parent":{}}],["name",{"_index":20,"name":{"21":{},"42":{},"80":{},"103":{}},"parent":{}}],["not",{"_index":97,"name":{"122":{}},"parent":{}}],["notequal",{"_index":94,"name":{"119":{}},"parent":{}}],["notnull",{"_index":22,"name":{"23":{},"82":{},"105":{}},"parent":{}}],["offset",{"_index":71,"name":{"89":{}},"parent":{}}],["operator",{"_index":101,"name":{"127":{}},"parent":{}}],["options",{"_index":3,"name":{"3":{}},"parent":{}}],["or",{"_index":96,"name":{"121":{}},"parent":{}}],["order",{"_index":100,"name":{"126":{}},"parent":{}}],["path",{"_index":80,"name":{"99":{}},"parent":{}}],["pk",{"_index":67,"name":{"84":{}},"parent":{}}],["primary",{"_index":23,"name":{"24":{},"106":{}},"parent":{}}],["ready",{"_index":40,"name":{"45":{},"94":{}},"parent":{}}],["resolvetable",{"_index":6,"name":{"6":{}},"parent":{}}],["sanitize",{"_index":81,"name":{"100":{}},"parent":{}}],["set",{"_index":12,"name":{"12":{},"62":{}},"parent":{}}],["setdatabase",{"_index":41,"name":{"46":{}},"parent":{}}],["setdefault",{"_index":33,"name":{"35":{}},"parent":{}}],["setname",{"_index":31,"name":{"33":{},"47":{}},"parent":{}}],["setnotnull",{"_index":35,"name":{"37":{}},"parent":{}}],["setprimary",{"_index":36,"name":{"38":{}},"parent":{}}],["settype",{"_index":32,"name":{"34":{}},"parent":{}}],["sort",{"_index":72,"name":{"90":{}},"parent":{}}],["sortoptions",{"_index":99,"name":{"124":{}},"parent":{"125":{},"126":{},"127":{}}}],["sqlitechanges",{"_index":60,"name":{"74":{}},"parent":{"75":{},"76":{}}}],["sqlitedatatypes",{"_index":63,"name":{"77":{}},"parent":{}}],["sqlitequeryoptions",{"_index":68,"name":{"85":{}},"parent":{"86":{},"87":{},"88":{},"89":{},"90":{}}}],["sqlitetablecolumn",{"_index":64,"name":{"78":{}},"parent":{"79":{},"80":{},"81":{},"82":{},"83":{},"84":{}}}],["startswith",{"_index":92,"name":{"117":{}},"parent":{}}],["table",{"_index":37,"name":{"39":{}},"parent":{"40":{},"41":{},"42":{},"43":{},"44":{},"45":{},"46":{},"47":{},"48":{},"49":{},"50":{},"51":{},"52":{},"53":{},"54":{},"55":{},"56":{},"57":{},"58":{},"59":{},"60":{},"61":{},"62":{}}}],["tableresolvable",{"_index":98,"name":{"123":{}},"parent":{}}],["tables",{"_index":4,"name":{"4":{}},"parent":{}}],["transform",{"_index":18,"name":{"18":{}},"parent":{}}],["transformcolumns",{"_index":42,"name":{"48":{}},"parent":{}}],["transformvalue",{"_index":19,"name":{"19":{}},"parent":{}}],["type",{"_index":24,"name":{"25":{},"81":{},"107":{}},"parent":{}}],["util",{"_index":51,"name":{"63":{}},"parent":{"64":{},"65":{},"66":{},"67":{},"68":{},"69":{},"70":{}}}],["where",{"_index":69,"name":{"87":{}},"parent":{}}],["wherecolumnoptions",{"_index":85,"name":{"109":{}},"parent":{"110":{},"111":{},"112":{},"113":{},"114":{},"115":{},"116":{},"117":{},"118":{},"119":{},"120":{},"121":{},"122":{}}}]],"pipeline":[]}}
+window.searchData = {"kinds":{"128":"Class","256":"Interface","512":"Constructor","1024":"Property","2048":"Method","65536":"Type literal","262144":"Accessor","4194304":"Type alias"},"rows":[{"id":0,"kind":256,"name":"InnerJoinOptions","url":"interfaces/InnerJoinOptions.html","classes":"tsd-kind-interface"},{"id":1,"kind":1024,"name":"table","url":"interfaces/InnerJoinOptions.html#table","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"InnerJoinOptions"},{"id":2,"kind":1024,"name":"from","url":"interfaces/InnerJoinOptions.html#from","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"InnerJoinOptions"},{"id":3,"kind":1024,"name":"column","url":"interfaces/InnerJoinOptions.html#column","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"InnerJoinOptions"},{"id":4,"kind":128,"name":"Database","url":"classes/Database.html","classes":"tsd-kind-class"},{"id":5,"kind":512,"name":"constructor","url":"classes/Database.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class tsd-is-overwrite","parent":"Database"},{"id":6,"kind":1024,"name":"db","url":"classes/Database.html#db","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":7,"kind":1024,"name":"readyAt","url":"classes/Database.html#readyAt","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":8,"kind":1024,"name":"options","url":"classes/Database.html#options","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":9,"kind":1024,"name":"tables","url":"classes/Database.html#tables","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Database"},{"id":10,"kind":2048,"name":"_validateOptions","url":"classes/Database.html#_validateOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-private","parent":"Database"},{"id":11,"kind":2048,"name":"resolveTable","url":"classes/Database.html#resolveTable","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":12,"kind":2048,"name":"createTable","url":"classes/Database.html#createTable","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":13,"kind":2048,"name":"addTable","url":"classes/Database.html#addTable","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":14,"kind":2048,"name":"arrayFromMap","url":"classes/Database.html#arrayFromMap","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":15,"kind":262144,"name":"readyTimestamp","url":"classes/Database.html#readyTimestamp","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Database"},{"id":16,"kind":2048,"name":"getTableData","url":"classes/Database.html#getTableData","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":17,"kind":262144,"name":"databaseTables","url":"classes/Database.html#databaseTables","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Database"},{"id":18,"kind":2048,"name":"all","url":"classes/Database.html#all","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":19,"kind":2048,"name":"getRowPosition","url":"classes/Database.html#getRowPosition","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":20,"kind":2048,"name":"getRowCount","url":"classes/Database.html#getRowCount","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":21,"kind":2048,"name":"set","url":"classes/Database.html#set","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":22,"kind":2048,"name":"delete","url":"classes/Database.html#delete","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":23,"kind":2048,"name":"insert","url":"classes/Database.html#insert","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":24,"kind":2048,"name":"get","url":"classes/Database.html#get","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":25,"kind":2048,"name":"connect","url":"classes/Database.html#connect","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":26,"kind":2048,"name":"close","url":"classes/Database.html#close","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Database"},{"id":27,"kind":128,"name":"Column","url":"classes/Column.html","classes":"tsd-kind-class"},{"id":28,"kind":2048,"name":"transform","url":"classes/Column.html#transform","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Column"},{"id":29,"kind":2048,"name":"transformValue","url":"classes/Column.html#transformValue","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Column"},{"id":30,"kind":512,"name":"constructor","url":"classes/Column.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class","parent":"Column"},{"id":31,"kind":1024,"name":"name","url":"classes/Column.html#name","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":32,"kind":1024,"name":"default","url":"classes/Column.html#default","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":33,"kind":1024,"name":"notNull","url":"classes/Column.html#notNull","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":34,"kind":1024,"name":"primary","url":"classes/Column.html#primary","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":35,"kind":1024,"name":"type","url":"classes/Column.html#type","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":36,"kind":1024,"name":"_default","url":"classes/Column.html#_default","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":37,"kind":1024,"name":"db","url":"classes/Column.html#db","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Column"},{"id":38,"kind":2048,"name":"attachDatabase","url":"classes/Column.html#attachDatabase","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":39,"kind":2048,"name":"getRealType","url":"classes/Column.html#getRealType","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":40,"kind":2048,"name":"hasDatabase","url":"classes/Column.html#hasDatabase","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":41,"kind":2048,"name":"create","url":"classes/Column.html#create","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":42,"kind":262144,"name":"creator","url":"classes/Column.html#creator","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Column"},{"id":43,"kind":2048,"name":"setName","url":"classes/Column.html#setName","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":44,"kind":2048,"name":"setType","url":"classes/Column.html#setType","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":45,"kind":2048,"name":"setDefault","url":"classes/Column.html#setDefault","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":46,"kind":262144,"name":"defaultValue","url":"classes/Column.html#defaultValue","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Column"},{"id":47,"kind":2048,"name":"setNotNull","url":"classes/Column.html#setNotNull","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":48,"kind":2048,"name":"setPrimary","url":"classes/Column.html#setPrimary","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Column"},{"id":49,"kind":128,"name":"Table","url":"classes/Table.html","classes":"tsd-kind-class"},{"id":50,"kind":512,"name":"constructor","url":"classes/Table.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class","parent":"Table"},{"id":51,"kind":1024,"name":"db","url":"classes/Table.html#db","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":52,"kind":1024,"name":"name","url":"classes/Table.html#name","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":53,"kind":1024,"name":"_columns","url":"classes/Table.html#_columns","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":54,"kind":1024,"name":"columns","url":"classes/Table.html#columns","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":55,"kind":1024,"name":"ready","url":"classes/Table.html#ready","classes":"tsd-kind-property tsd-parent-kind-class","parent":"Table"},{"id":56,"kind":2048,"name":"setDatabase","url":"classes/Table.html#setDatabase","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":57,"kind":2048,"name":"setName","url":"classes/Table.html#setName","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":58,"kind":2048,"name":"transformColumns","url":"classes/Table.html#transformColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":59,"kind":2048,"name":"getTypeColumns","url":"classes/Table.html#getTypeColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":60,"kind":2048,"name":"getColumns","url":"classes/Table.html#getColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":61,"kind":2048,"name":"getColumn","url":"classes/Table.html#getColumn","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":62,"kind":2048,"name":"isReady","url":"classes/Table.html#isReady","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":63,"kind":262144,"name":"columnCreator","url":"classes/Table.html#columnCreator","classes":"tsd-kind-get-signature tsd-parent-kind-class","parent":"Table"},{"id":64,"kind":2048,"name":"getRowCount","url":"classes/Table.html#getRowCount","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":65,"kind":2048,"name":"getTableColumns","url":"classes/Table.html#getTableColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":66,"kind":2048,"name":"create","url":"classes/Table.html#create","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":67,"kind":2048,"name":"addColumns","url":"classes/Table.html#addColumns","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":68,"kind":2048,"name":"addColumn","url":"classes/Table.html#addColumn","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":69,"kind":2048,"name":"getRowPosition","url":"classes/Table.html#getRowPosition","classes":"tsd-kind-method tsd-parent-kind-class tsd-has-type-parameter","parent":"Table"},{"id":70,"kind":2048,"name":"get","url":"classes/Table.html#get","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":71,"kind":2048,"name":"all","url":"classes/Table.html#all","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":72,"kind":2048,"name":"insert","url":"classes/Table.html#insert","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":73,"kind":2048,"name":"delete","url":"classes/Table.html#delete","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":74,"kind":2048,"name":"set","url":"classes/Table.html#set","classes":"tsd-kind-method tsd-parent-kind-class","parent":"Table"},{"id":75,"kind":128,"name":"Util","url":"classes/Util.html","classes":"tsd-kind-class"},{"id":76,"kind":2048,"name":"mergeDefault","url":"classes/Util.html#mergeDefault","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":77,"kind":2048,"name":"makeInnerJoinOptions","url":"classes/Util.html#makeInnerJoinOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":78,"kind":2048,"name":"makeSelectOptions","url":"classes/Util.html#makeSelectOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":79,"kind":2048,"name":"makeWhereOptions","url":"classes/Util.html#makeWhereOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":80,"kind":2048,"name":"makeColumnsFrom","url":"classes/Util.html#makeColumnsFrom","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":81,"kind":2048,"name":"makeSortOptions","url":"classes/Util.html#makeSortOptions","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":82,"kind":2048,"name":"makeInsertValues","url":"classes/Util.html#makeInsertValues","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":83,"kind":2048,"name":"makeSetValues","url":"classes/Util.html#makeSetValues","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":84,"kind":2048,"name":"isNumber","url":"classes/Util.html#isNumber","classes":"tsd-kind-method tsd-parent-kind-class tsd-is-static","parent":"Util"},{"id":85,"kind":512,"name":"constructor","url":"classes/Util.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class tsd-is-overwrite","parent":"Util"},{"id":86,"kind":128,"name":"DatabaseError","url":"classes/DatabaseError.html","classes":"tsd-kind-class"},{"id":87,"kind":65536,"name":"__type","url":"classes/DatabaseError.html#__type","classes":"tsd-kind-type-literal tsd-parent-kind-class","parent":"DatabaseError"},{"id":88,"kind":512,"name":"constructor","url":"classes/DatabaseError.html#constructor","classes":"tsd-kind-constructor tsd-parent-kind-class tsd-is-overwrite","parent":"DatabaseError"},{"id":89,"kind":256,"name":"SqliteChanges","url":"interfaces/SqliteChanges.html","classes":"tsd-kind-interface"},{"id":90,"kind":1024,"name":"changes","url":"interfaces/SqliteChanges.html#changes","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteChanges"},{"id":91,"kind":1024,"name":"lastInsertRowid","url":"interfaces/SqliteChanges.html#lastInsertRowid","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteChanges"},{"id":92,"kind":4194304,"name":"SqliteDataTypes","url":"modules.html#SqliteDataTypes","classes":"tsd-kind-type-alias"},{"id":93,"kind":256,"name":"SqliteTableColumn","url":"interfaces/SqliteTableColumn.html","classes":"tsd-kind-interface"},{"id":94,"kind":1024,"name":"cid","url":"interfaces/SqliteTableColumn.html#cid","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":95,"kind":1024,"name":"name","url":"interfaces/SqliteTableColumn.html#name","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":96,"kind":1024,"name":"type","url":"interfaces/SqliteTableColumn.html#type","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":97,"kind":1024,"name":"notnull","url":"interfaces/SqliteTableColumn.html#notnull","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":98,"kind":1024,"name":"dflt_value","url":"interfaces/SqliteTableColumn.html#dflt_value","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":99,"kind":1024,"name":"pk","url":"interfaces/SqliteTableColumn.html#pk","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteTableColumn"},{"id":100,"kind":256,"name":"SqliteQueryOptions","url":"interfaces/SqliteQueryOptions.html","classes":"tsd-kind-interface"},{"id":101,"kind":1024,"name":"columns","url":"interfaces/SqliteQueryOptions.html#columns","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":102,"kind":1024,"name":"innerJoin","url":"interfaces/SqliteQueryOptions.html#innerJoin","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":103,"kind":1024,"name":"where","url":"interfaces/SqliteQueryOptions.html#where","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":104,"kind":1024,"name":"limit","url":"interfaces/SqliteQueryOptions.html#limit","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":105,"kind":1024,"name":"offset","url":"interfaces/SqliteQueryOptions.html#offset","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":106,"kind":1024,"name":"sort","url":"interfaces/SqliteQueryOptions.html#sort","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SqliteQueryOptions"},{"id":107,"kind":4194304,"name":"DataResolvable","url":"modules.html#DataResolvable","classes":"tsd-kind-type-alias"},{"id":108,"kind":4194304,"name":"DataTypes","url":"modules.html#DataTypes","classes":"tsd-kind-type-alias"},{"id":109,"kind":256,"name":"DatabaseEvents","url":"interfaces/DatabaseEvents.html","classes":"tsd-kind-interface"},{"id":110,"kind":2048,"name":"ready","url":"interfaces/DatabaseEvents.html#ready","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":111,"kind":2048,"name":"dataSet","url":"interfaces/DatabaseEvents.html#dataSet","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":112,"kind":2048,"name":"dataGet","url":"interfaces/DatabaseEvents.html#dataGet","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":113,"kind":2048,"name":"dataDelete","url":"interfaces/DatabaseEvents.html#dataDelete","classes":"tsd-kind-method tsd-parent-kind-interface","parent":"DatabaseEvents"},{"id":114,"kind":256,"name":"DatabaseOptions","url":"interfaces/DatabaseOptions.html","classes":"tsd-kind-interface"},{"id":115,"kind":1024,"name":"path","url":"interfaces/DatabaseOptions.html#path","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"DatabaseOptions"},{"id":116,"kind":1024,"name":"sanitize","url":"interfaces/DatabaseOptions.html#sanitize","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"DatabaseOptions"},{"id":117,"kind":1024,"name":"length","url":"interfaces/DatabaseOptions.html#length","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"DatabaseOptions"},{"id":118,"kind":256,"name":"ColumnOptions","url":"interfaces/ColumnOptions.html","classes":"tsd-kind-interface"},{"id":119,"kind":1024,"name":"name","url":"interfaces/ColumnOptions.html#name","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":120,"kind":1024,"name":"default","url":"interfaces/ColumnOptions.html#default","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":121,"kind":1024,"name":"notNull","url":"interfaces/ColumnOptions.html#notNull","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":122,"kind":1024,"name":"primary","url":"interfaces/ColumnOptions.html#primary","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":123,"kind":1024,"name":"type","url":"interfaces/ColumnOptions.html#type","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"ColumnOptions"},{"id":124,"kind":4194304,"name":"ColumnResolvable","url":"modules.html#ColumnResolvable","classes":"tsd-kind-type-alias"},{"id":125,"kind":256,"name":"WhereColumnOptions","url":"interfaces/WhereColumnOptions.html","classes":"tsd-kind-interface"},{"id":126,"kind":1024,"name":"column","url":"interfaces/WhereColumnOptions.html#column","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":127,"kind":1024,"name":"equals","url":"interfaces/WhereColumnOptions.html#equals","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":128,"kind":1024,"name":"greater","url":"interfaces/WhereColumnOptions.html#greater","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":129,"kind":1024,"name":"lesser","url":"interfaces/WhereColumnOptions.html#lesser","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":130,"kind":1024,"name":"lesserEquals","url":"interfaces/WhereColumnOptions.html#lesserEquals","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":131,"kind":1024,"name":"greaterEquals","url":"interfaces/WhereColumnOptions.html#greaterEquals","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":132,"kind":1024,"name":"in","url":"interfaces/WhereColumnOptions.html#in","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":133,"kind":1024,"name":"startsWith","url":"interfaces/WhereColumnOptions.html#startsWith","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":134,"kind":1024,"name":"endsWith","url":"interfaces/WhereColumnOptions.html#endsWith","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":135,"kind":1024,"name":"notEqual","url":"interfaces/WhereColumnOptions.html#notEqual","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":136,"kind":1024,"name":"includes","url":"interfaces/WhereColumnOptions.html#includes","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":137,"kind":1024,"name":"or","url":"interfaces/WhereColumnOptions.html#or","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":138,"kind":1024,"name":"not","url":"interfaces/WhereColumnOptions.html#not","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"WhereColumnOptions"},{"id":139,"kind":4194304,"name":"TableResolvable","url":"modules.html#TableResolvable","classes":"tsd-kind-type-alias"},{"id":140,"kind":256,"name":"SortOptions","url":"interfaces/SortOptions.html","classes":"tsd-kind-interface"},{"id":141,"kind":1024,"name":"column","url":"interfaces/SortOptions.html#column","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SortOptions"},{"id":142,"kind":1024,"name":"order","url":"interfaces/SortOptions.html#order","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SortOptions"},{"id":143,"kind":1024,"name":"operator","url":"interfaces/SortOptions.html#operator","classes":"tsd-kind-property tsd-parent-kind-interface","parent":"SortOptions"}],"index":{"version":"2.3.9","fields":["name","parent"],"fieldVectors":[["name/0",[0,34.727]],["parent/0",[]],["name/1",[1,16.625]],["parent/1",[0,3.269]],["name/2",[2,45.713]],["parent/2",[0,3.269]],["name/3",[3,17.381]],["parent/3",[0,3.269]],["name/4",[4,18.197]],["parent/4",[]],["name/5",[5,32.72]],["parent/5",[4,1.713]],["name/6",[6,37.24]],["parent/6",[4,1.713]],["name/7",[7,45.713]],["parent/7",[4,1.713]],["name/8",[8,45.713]],["parent/8",[4,1.713]],["name/9",[9,45.713]],["parent/9",[4,1.713]],["name/10",[10,45.713]],["parent/10",[4,1.713]],["name/11",[11,45.713]],["parent/11",[4,1.713]],["name/12",[12,45.713]],["parent/12",[4,1.713]],["name/13",[13,45.713]],["parent/13",[4,1.713]],["name/14",[14,45.713]],["parent/14",[4,1.713]],["name/15",[15,45.713]],["parent/15",[4,1.713]],["name/16",[16,45.713]],["parent/16",[4,1.713]],["name/17",[17,45.713]],["parent/17",[4,1.713]],["name/18",[18,40.604]],["parent/18",[4,1.713]],["name/19",[19,40.604]],["parent/19",[4,1.713]],["name/20",[20,40.604]],["parent/20",[4,1.713]],["name/21",[21,40.604]],["parent/21",[4,1.713]],["name/22",[22,40.604]],["parent/22",[4,1.713]],["name/23",[23,40.604]],["parent/23",[4,1.713]],["name/24",[24,40.604]],["parent/24",[4,1.713]],["name/25",[25,45.713]],["parent/25",[4,1.713]],["name/26",[26,45.713]],["parent/26",[4,1.713]],["name/27",[3,17.381]],["parent/27",[]],["name/28",[27,45.713]],["parent/28",[3,1.636]],["name/29",[28,45.713]],["parent/29",[3,1.636]],["name/30",[5,32.72]],["parent/30",[3,1.636]],["name/31",[29,34.727]],["parent/31",[3,1.636]],["name/32",[30,40.604]],["parent/32",[3,1.636]],["name/33",[31,37.24]],["parent/33",[3,1.636]],["name/34",[32,40.604]],["parent/34",[3,1.636]],["name/35",[33,37.24]],["parent/35",[3,1.636]],["name/36",[34,45.713]],["parent/36",[3,1.636]],["name/37",[6,37.24]],["parent/37",[3,1.636]],["name/38",[35,45.713]],["parent/38",[3,1.636]],["name/39",[36,45.713]],["parent/39",[3,1.636]],["name/40",[37,45.713]],["parent/40",[3,1.636]],["name/41",[38,40.604]],["parent/41",[3,1.636]],["name/42",[39,45.713]],["parent/42",[3,1.636]],["name/43",[40,40.604]],["parent/43",[3,1.636]],["name/44",[41,45.713]],["parent/44",[3,1.636]],["name/45",[42,45.713]],["parent/45",[3,1.636]],["name/46",[43,45.713]],["parent/46",[3,1.636]],["name/47",[44,45.713]],["parent/47",[3,1.636]],["name/48",[45,45.713]],["parent/48",[3,1.636]],["name/49",[1,16.625]],["parent/49",[]],["name/50",[5,32.72]],["parent/50",[1,1.565]],["name/51",[6,37.24]],["parent/51",[1,1.565]],["name/52",[29,34.727]],["parent/52",[1,1.565]],["name/53",[46,45.713]],["parent/53",[1,1.565]],["name/54",[47,40.604]],["parent/54",[1,1.565]],["name/55",[48,40.604]],["parent/55",[1,1.565]],["name/56",[49,45.713]],["parent/56",[1,1.565]],["name/57",[40,40.604]],["parent/57",[1,1.565]],["name/58",[50,45.713]],["parent/58",[1,1.565]],["name/59",[51,45.713]],["parent/59",[1,1.565]],["name/60",[52,45.713]],["parent/60",[1,1.565]],["name/61",[53,45.713]],["parent/61",[1,1.565]],["name/62",[54,45.713]],["parent/62",[1,1.565]],["name/63",[55,45.713]],["parent/63",[1,1.565]],["name/64",[20,40.604]],["parent/64",[1,1.565]],["name/65",[56,45.713]],["parent/65",[1,1.565]],["name/66",[38,40.604]],["parent/66",[1,1.565]],["name/67",[57,45.713]],["parent/67",[1,1.565]],["name/68",[58,45.713]],["parent/68",[1,1.565]],["name/69",[19,40.604]],["parent/69",[1,1.565]],["name/70",[24,40.604]],["parent/70",[1,1.565]],["name/71",[18,40.604]],["parent/71",[1,1.565]],["name/72",[23,40.604]],["parent/72",[1,1.565]],["name/73",[22,40.604]],["parent/73",[1,1.565]],["name/74",[21,40.604]],["parent/74",[1,1.565]],["name/75",[59,25.344]],["parent/75",[]],["name/76",[60,45.713]],["parent/76",[59,2.386]],["name/77",[61,45.713]],["parent/77",[59,2.386]],["name/78",[62,45.713]],["parent/78",[59,2.386]],["name/79",[63,45.713]],["parent/79",[59,2.386]],["name/80",[64,45.713]],["parent/80",[59,2.386]],["name/81",[65,45.713]],["parent/81",[59,2.386]],["name/82",[66,45.713]],["parent/82",[59,2.386]],["name/83",[67,45.713]],["parent/83",[59,2.386]],["name/84",[68,45.713]],["parent/84",[59,2.386]],["name/85",[5,32.72]],["parent/85",[59,2.386]],["name/86",[69,37.24]],["parent/86",[]],["name/87",[70,45.713]],["parent/87",[69,3.506]],["name/88",[5,32.72]],["parent/88",[69,3.506]],["name/89",[71,37.24]],["parent/89",[]],["name/90",[72,45.713]],["parent/90",[71,3.506]],["name/91",[73,45.713]],["parent/91",[71,3.506]],["name/92",[74,45.713]],["parent/92",[]],["name/93",[75,29.618]],["parent/93",[]],["name/94",[76,45.713]],["parent/94",[75,2.788]],["name/95",[29,34.727]],["parent/95",[75,2.788]],["name/96",[33,37.24]],["parent/96",[75,2.788]],["name/97",[31,37.24]],["parent/97",[75,2.788]],["name/98",[77,45.713]],["parent/98",[75,2.788]],["name/99",[78,45.713]],["parent/99",[75,2.788]],["name/100",[79,29.618]],["parent/100",[]],["name/101",[47,40.604]],["parent/101",[79,2.788]],["name/102",[80,45.713]],["parent/102",[79,2.788]],["name/103",[81,45.713]],["parent/103",[79,2.788]],["name/104",[82,45.713]],["parent/104",[79,2.788]],["name/105",[83,45.713]],["parent/105",[79,2.788]],["name/106",[84,45.713]],["parent/106",[79,2.788]],["name/107",[85,45.713]],["parent/107",[]],["name/108",[86,45.713]],["parent/108",[]],["name/109",[87,32.72]],["parent/109",[]],["name/110",[48,40.604]],["parent/110",[87,3.08]],["name/111",[88,45.713]],["parent/111",[87,3.08]],["name/112",[89,45.713]],["parent/112",[87,3.08]],["name/113",[90,45.713]],["parent/113",[87,3.08]],["name/114",[91,34.727]],["parent/114",[]],["name/115",[92,45.713]],["parent/115",[91,3.269]],["name/116",[93,45.713]],["parent/116",[91,3.269]],["name/117",[94,45.713]],["parent/117",[91,3.269]],["name/118",[95,31.049]],["parent/118",[]],["name/119",[29,34.727]],["parent/119",[95,2.923]],["name/120",[30,40.604]],["parent/120",[95,2.923]],["name/121",[31,37.24]],["parent/121",[95,2.923]],["name/122",[32,40.604]],["parent/122",[95,2.923]],["name/123",[33,37.24]],["parent/123",[95,2.923]],["name/124",[96,45.713]],["parent/124",[]],["name/125",[97,23.026]],["parent/125",[]],["name/126",[3,17.381]],["parent/126",[97,2.168]],["name/127",[98,45.713]],["parent/127",[97,2.168]],["name/128",[99,45.713]],["parent/128",[97,2.168]],["name/129",[100,45.713]],["parent/129",[97,2.168]],["name/130",[101,45.713]],["parent/130",[97,2.168]],["name/131",[102,45.713]],["parent/131",[97,2.168]],["name/132",[103,45.713]],["parent/132",[97,2.168]],["name/133",[104,45.713]],["parent/133",[97,2.168]],["name/134",[105,45.713]],["parent/134",[97,2.168]],["name/135",[106,45.713]],["parent/135",[97,2.168]],["name/136",[107,45.713]],["parent/136",[97,2.168]],["name/137",[108,45.713]],["parent/137",[97,2.168]],["name/138",[109,45.713]],["parent/138",[97,2.168]],["name/139",[110,45.713]],["parent/139",[]],["name/140",[111,34.727]],["parent/140",[]],["name/141",[3,17.381]],["parent/141",[111,3.269]],["name/142",[112,45.713]],["parent/142",[111,3.269]],["name/143",[113,45.713]],["parent/143",[111,3.269]]],"invertedIndex":[["__type",{"_index":70,"name":{"87":{}},"parent":{}}],["_columns",{"_index":46,"name":{"53":{}},"parent":{}}],["_default",{"_index":34,"name":{"36":{}},"parent":{}}],["_validateoptions",{"_index":10,"name":{"10":{}},"parent":{}}],["addcolumn",{"_index":58,"name":{"68":{}},"parent":{}}],["addcolumns",{"_index":57,"name":{"67":{}},"parent":{}}],["addtable",{"_index":13,"name":{"13":{}},"parent":{}}],["all",{"_index":18,"name":{"18":{},"71":{}},"parent":{}}],["arrayfrommap",{"_index":14,"name":{"14":{}},"parent":{}}],["attachdatabase",{"_index":35,"name":{"38":{}},"parent":{}}],["changes",{"_index":72,"name":{"90":{}},"parent":{}}],["cid",{"_index":76,"name":{"94":{}},"parent":{}}],["close",{"_index":26,"name":{"26":{}},"parent":{}}],["column",{"_index":3,"name":{"3":{},"27":{},"126":{},"141":{}},"parent":{"28":{},"29":{},"30":{},"31":{},"32":{},"33":{},"34":{},"35":{},"36":{},"37":{},"38":{},"39":{},"40":{},"41":{},"42":{},"43":{},"44":{},"45":{},"46":{},"47":{},"48":{}}}],["columncreator",{"_index":55,"name":{"63":{}},"parent":{}}],["columnoptions",{"_index":95,"name":{"118":{}},"parent":{"119":{},"120":{},"121":{},"122":{},"123":{}}}],["columnresolvable",{"_index":96,"name":{"124":{}},"parent":{}}],["columns",{"_index":47,"name":{"54":{},"101":{}},"parent":{}}],["connect",{"_index":25,"name":{"25":{}},"parent":{}}],["constructor",{"_index":5,"name":{"5":{},"30":{},"50":{},"85":{},"88":{}},"parent":{}}],["create",{"_index":38,"name":{"41":{},"66":{}},"parent":{}}],["createtable",{"_index":12,"name":{"12":{}},"parent":{}}],["creator",{"_index":39,"name":{"42":{}},"parent":{}}],["database",{"_index":4,"name":{"4":{}},"parent":{"5":{},"6":{},"7":{},"8":{},"9":{},"10":{},"11":{},"12":{},"13":{},"14":{},"15":{},"16":{},"17":{},"18":{},"19":{},"20":{},"21":{},"22":{},"23":{},"24":{},"25":{},"26":{}}}],["databaseerror",{"_index":69,"name":{"86":{}},"parent":{"87":{},"88":{}}}],["databaseevents",{"_index":87,"name":{"109":{}},"parent":{"110":{},"111":{},"112":{},"113":{}}}],["databaseoptions",{"_index":91,"name":{"114":{}},"parent":{"115":{},"116":{},"117":{}}}],["databasetables",{"_index":17,"name":{"17":{}},"parent":{}}],["datadelete",{"_index":90,"name":{"113":{}},"parent":{}}],["dataget",{"_index":89,"name":{"112":{}},"parent":{}}],["dataresolvable",{"_index":85,"name":{"107":{}},"parent":{}}],["dataset",{"_index":88,"name":{"111":{}},"parent":{}}],["datatypes",{"_index":86,"name":{"108":{}},"parent":{}}],["db",{"_index":6,"name":{"6":{},"37":{},"51":{}},"parent":{}}],["default",{"_index":30,"name":{"32":{},"120":{}},"parent":{}}],["defaultvalue",{"_index":43,"name":{"46":{}},"parent":{}}],["delete",{"_index":22,"name":{"22":{},"73":{}},"parent":{}}],["dflt_value",{"_index":77,"name":{"98":{}},"parent":{}}],["endswith",{"_index":105,"name":{"134":{}},"parent":{}}],["equals",{"_index":98,"name":{"127":{}},"parent":{}}],["from",{"_index":2,"name":{"2":{}},"parent":{}}],["get",{"_index":24,"name":{"24":{},"70":{}},"parent":{}}],["getcolumn",{"_index":53,"name":{"61":{}},"parent":{}}],["getcolumns",{"_index":52,"name":{"60":{}},"parent":{}}],["getrealtype",{"_index":36,"name":{"39":{}},"parent":{}}],["getrowcount",{"_index":20,"name":{"20":{},"64":{}},"parent":{}}],["getrowposition",{"_index":19,"name":{"19":{},"69":{}},"parent":{}}],["gettablecolumns",{"_index":56,"name":{"65":{}},"parent":{}}],["gettabledata",{"_index":16,"name":{"16":{}},"parent":{}}],["gettypecolumns",{"_index":51,"name":{"59":{}},"parent":{}}],["greater",{"_index":99,"name":{"128":{}},"parent":{}}],["greaterequals",{"_index":102,"name":{"131":{}},"parent":{}}],["hasdatabase",{"_index":37,"name":{"40":{}},"parent":{}}],["in",{"_index":103,"name":{"132":{}},"parent":{}}],["includes",{"_index":107,"name":{"136":{}},"parent":{}}],["innerjoin",{"_index":80,"name":{"102":{}},"parent":{}}],["innerjoinoptions",{"_index":0,"name":{"0":{}},"parent":{"1":{},"2":{},"3":{}}}],["insert",{"_index":23,"name":{"23":{},"72":{}},"parent":{}}],["isnumber",{"_index":68,"name":{"84":{}},"parent":{}}],["isready",{"_index":54,"name":{"62":{}},"parent":{}}],["lastinsertrowid",{"_index":73,"name":{"91":{}},"parent":{}}],["length",{"_index":94,"name":{"117":{}},"parent":{}}],["lesser",{"_index":100,"name":{"129":{}},"parent":{}}],["lesserequals",{"_index":101,"name":{"130":{}},"parent":{}}],["limit",{"_index":82,"name":{"104":{}},"parent":{}}],["makecolumnsfrom",{"_index":64,"name":{"80":{}},"parent":{}}],["makeinnerjoinoptions",{"_index":61,"name":{"77":{}},"parent":{}}],["makeinsertvalues",{"_index":66,"name":{"82":{}},"parent":{}}],["makeselectoptions",{"_index":62,"name":{"78":{}},"parent":{}}],["makesetvalues",{"_index":67,"name":{"83":{}},"parent":{}}],["makesortoptions",{"_index":65,"name":{"81":{}},"parent":{}}],["makewhereoptions",{"_index":63,"name":{"79":{}},"parent":{}}],["mergedefault",{"_index":60,"name":{"76":{}},"parent":{}}],["name",{"_index":29,"name":{"31":{},"52":{},"95":{},"119":{}},"parent":{}}],["not",{"_index":109,"name":{"138":{}},"parent":{}}],["notequal",{"_index":106,"name":{"135":{}},"parent":{}}],["notnull",{"_index":31,"name":{"33":{},"97":{},"121":{}},"parent":{}}],["offset",{"_index":83,"name":{"105":{}},"parent":{}}],["operator",{"_index":113,"name":{"143":{}},"parent":{}}],["options",{"_index":8,"name":{"8":{}},"parent":{}}],["or",{"_index":108,"name":{"137":{}},"parent":{}}],["order",{"_index":112,"name":{"142":{}},"parent":{}}],["path",{"_index":92,"name":{"115":{}},"parent":{}}],["pk",{"_index":78,"name":{"99":{}},"parent":{}}],["primary",{"_index":32,"name":{"34":{},"122":{}},"parent":{}}],["ready",{"_index":48,"name":{"55":{},"110":{}},"parent":{}}],["readyat",{"_index":7,"name":{"7":{}},"parent":{}}],["readytimestamp",{"_index":15,"name":{"15":{}},"parent":{}}],["resolvetable",{"_index":11,"name":{"11":{}},"parent":{}}],["sanitize",{"_index":93,"name":{"116":{}},"parent":{}}],["set",{"_index":21,"name":{"21":{},"74":{}},"parent":{}}],["setdatabase",{"_index":49,"name":{"56":{}},"parent":{}}],["setdefault",{"_index":42,"name":{"45":{}},"parent":{}}],["setname",{"_index":40,"name":{"43":{},"57":{}},"parent":{}}],["setnotnull",{"_index":44,"name":{"47":{}},"parent":{}}],["setprimary",{"_index":45,"name":{"48":{}},"parent":{}}],["settype",{"_index":41,"name":{"44":{}},"parent":{}}],["sort",{"_index":84,"name":{"106":{}},"parent":{}}],["sortoptions",{"_index":111,"name":{"140":{}},"parent":{"141":{},"142":{},"143":{}}}],["sqlitechanges",{"_index":71,"name":{"89":{}},"parent":{"90":{},"91":{}}}],["sqlitedatatypes",{"_index":74,"name":{"92":{}},"parent":{}}],["sqlitequeryoptions",{"_index":79,"name":{"100":{}},"parent":{"101":{},"102":{},"103":{},"104":{},"105":{},"106":{}}}],["sqlitetablecolumn",{"_index":75,"name":{"93":{}},"parent":{"94":{},"95":{},"96":{},"97":{},"98":{},"99":{}}}],["startswith",{"_index":104,"name":{"133":{}},"parent":{}}],["table",{"_index":1,"name":{"1":{},"49":{}},"parent":{"50":{},"51":{},"52":{},"53":{},"54":{},"55":{},"56":{},"57":{},"58":{},"59":{},"60":{},"61":{},"62":{},"63":{},"64":{},"65":{},"66":{},"67":{},"68":{},"69":{},"70":{},"71":{},"72":{},"73":{},"74":{}}}],["tableresolvable",{"_index":110,"name":{"139":{}},"parent":{}}],["tables",{"_index":9,"name":{"9":{}},"parent":{}}],["transform",{"_index":27,"name":{"28":{}},"parent":{}}],["transformcolumns",{"_index":50,"name":{"58":{}},"parent":{}}],["transformvalue",{"_index":28,"name":{"29":{}},"parent":{}}],["type",{"_index":33,"name":{"35":{},"96":{},"123":{}},"parent":{}}],["util",{"_index":59,"name":{"75":{}},"parent":{"76":{},"77":{},"78":{},"79":{},"80":{},"81":{},"82":{},"83":{},"84":{},"85":{}}}],["where",{"_index":81,"name":{"103":{}},"parent":{}}],["wherecolumnoptions",{"_index":97,"name":{"125":{}},"parent":{"126":{},"127":{},"128":{},"129":{},"130":{},"131":{},"132":{},"133":{},"134":{},"135":{},"136":{},"137":{},"138":{}}}]],"pipeline":[]}}

package.json

 {
   "name": "dbdts.db",
-  "version": "1.0.0",
-  "description": "dbdts.db - A TypeScript Database with Optimization.",
+  "version": "2.0.1",
+  "description": "Easy to use wrapper for sqlite databases, mainly designed for use with dbd.ts package.",
   "exports": {
@@ -29,2 +29,3 @@ "import": "./dist/index.mjs",
     "aoi.js",
+    "dbd.ts",
     "typescript",
@@ -31,0 +32,0 @@ "dbd",

README.md

@@ -0,0 +0,0 @@ # dbdts.db

tsconfig.json

@@ -0,0 +0,0 @@ {

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

New author

Supply chain risk

A new npm collaborator published a version of the package for the first time. New collaborators are usually benign additions to a project, but do indicate a change to the security surface area of a package.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

799623

increased by10.65%

Number of package files

59

increased by1.72%

Lines of code

4840

increased by9.5%

Worsened metrics

Number of medium supply chain risk alerts

1

increased byInfinity%

No dependency changes