Method deleteField

packages/core/meta-table/column.ts:225–323

(tableName: string, tableColumnName: string)

  }

  async deleteField(tableName: string, tableColumnName: string) {
    const effectTables: string[] = [tableName]
    const columnsToDelete: { tableName: string; columnName: string }[] = []

    try {
      await this.dataSpace.db.prepare("BEGIN TRANSACTION;").run()

      const column = await this.getColumn(tableName, tableColumnName)
      const tm = new TableManager(
        getTableIdByRawTableName(tableName),
        this.dataSpace
      )
      if (column?.type === FieldType.Text) {
        await tm.fields.text.beforeDeleteColumn(tableName, tableColumnName)
      }
      if (column?.type === FieldType.Link) {
        const pairedField = await tm.fields.link.getPairedLinkField(column)
        effectTables.push(pairedField.table_name)
        // delete relation
        await tm.fields.link.beforeDeleteColumn(
          tableName,
          tableColumnName,
          this.dataSpace.db
        )
        // queue paired field for deletion
        columnsToDelete.push({
          tableName: pairedField.table_name,
          columnName: pairedField.table_column_name,
        })
        // queue paired field's __title column for deletion
        columnsToDelete.push({
          tableName: pairedField.table_name,
          columnName: `${pairedField.table_column_name}__title`,
        })
        // queue current field's __title column for deletion
        columnsToDelete.push({
          tableName: tableName,
          columnName: `${tableColumnName}__title`,
        })
      }

      // queue main column for deletion
      columnsToDelete.push({ tableName, columnName: tableColumnName })

      const affectedTables = new Set(columnsToDelete.map((c) => c.tableName))

      // Step 1: Delete all metadata records first
      for (const { tableName: tn, columnName: cn } of columnsToDelete) {
        // Skip __title columns as they don't have metadata records
        if (!cn.endsWith("__title")) {
          this.dataSpace.db
            .prepare(
              `DELETE FROM ${ColumnTableName} WHERE table_column_name = ? AND table_name = ?;`
            )
            .run([cn, tn])
        }
      }