Method view

src/drivers/sqlite-base-driver.ts:284–292

(schemaName: string, name: string)

  }

  async view(schemaName: string, name: string): Promise<DatabaseViewSchema> {
    const sql = `SELECT * FROM ${this.escapeId(schemaName)}.sqlite_schema WHERE type = 'view' AND name = ${this.escapeValue(name)};`;
    const result = await this.query(sql);

    const viewRow = result.rows[0] as { sql: string } | undefined;
    if (!viewRow) throw new Error("View dose not exist");

    return parseCreateViewScript(schemaName, viewRow.sql);
  }

  createView(view: DatabaseViewSchema): string {
    return `CREATE VIEW ${this.escapeId(view.schemaName)}.${this.escapeId(view.name)} AS ${view.statement}`;