Method createDataView

packages/core/sdk/sql-data-view.ts:175–211

(
    id: string,
    createViewSql: string,
    isTemp: boolean = false
  )

  }

  async createDataView(
    id: string,
    createViewSql: string,
    isTemp: boolean = false
  ) {
    const viewName = `vw_${id}`
    // delete temp view
    await this.dataSpace.db.prepare(`DROP VIEW IF EXISTS ${viewName};`).run()
    await this.dataSpace.view.deleteByTableId(id)
    // Clean up existing column metadata for this view
    await this.dataSpace.column.deleteByRawTableName(viewName)
    await this.dataSpace.db.prepare("BEGIN TRANSACTION;").run()

    try {
      await this.dataSpace.db
        .prepare(
          `CREATE ${isTemp ? "TEMPORARY" : ""} VIEW IF NOT EXISTS ${viewName} AS \n ${createViewSql};`
        )
        .run()
      await this.dataSpace.view.add({
        id: shortenId(uuidv7()),
        name: `New View`,
        type: ViewTypeEnum.Grid,
        table_id: id,
        query: `select * from ${viewName}`,
      })
      // Parse column types from SQL comments and create column metadata
      await this.createColumnMetadataFromComments(viewName, createViewSql)
    } catch (error) {
      await this.dataSpace.db.prepare("ROLLBACK;").run()
      console.error("Error in createDataView transaction:", error)
      throw error
    } finally {
      await this.dataSpace.db.prepare("COMMIT;").run()
    }
    return true
  }

  /**
   * Create column metadata from SQL comments