Typings for Typescript [feature request] about node-sqlite

[tenry92]

I've created a local definitions file for myself at the moment. It may not conform the guidelines from DefinitelyTyped or whatever, and not 100 % correct / complete yet, but I can work with it for now.

Feel free to update or publish this code.

declare module 'sqlite' {
  class Database {
    open(fileName: string, options?: OpenOptions): Promise<Database>;
    close(): Promise<void>;
    run(query: string, ...params: any[]): Promise<RunExecResult>;
    get(query: string, ...params: any[]): Promise<Object>;
    all(query: string, ...params: any[]): Promise<Object[]>;
    exec(query: string): Promise<Database>;
    each(query: string, ...params: any[]): Promise<Statement>;
  }

  interface OpenOptions {
    mode?: string;
    verbose?: boolean;
  }

  class Statement {
    bind(...params: any[]): Promise<Statement>;
    reset(): Promise<Statement>;
    finalize(): Promise<Statement>;
    run(...params: any[]): Promise<RunExecResult>;
    get(...params: any[]): Promise<Statement>;
    all(...params: any[]): Promise<Statement>;
    each(...params: any[]): Promise<number>;
  }

  interface RunExecResult {
    lastID?: number;
    changes?: number;
  }

  export = new Database;
}

[villesinisalo]

Seems to be resolved by #21