Method updateFormulaColumn

packages/core/meta-table/column.ts:344–418

* Update formula column and handle dependencies * @param tableName Table name * @param tableColumnName Column name * @param property New property * @param fields All fields * @param db Database connection

(
    tableName: string,
    tableColumnName: string,
    property: any,
    fields: IField[],
    db: BaseServerDatabase
  )

   * @param db Database connection
   */
  private async updateFormulaColumn(
    tableName: string,
    tableColumnName: string,
    property: any,
    fields: IField[],
    db: BaseServerDatabase
  ) {
    // Find other generated columns that depend on the current column
    const dependentFields = findDependentFormulaFields(tableColumnName, fields)

    if (dependentFields.length > 0) {
      // If there are dependencies, we need to temporarily delete all dependent columns
      const allColumnsToUpdate = [
        tableColumnName,
        ...dependentFields.map((f) => f.columnName),
      ]

      // Get the correct deletion order (delete columns that depend on others first)
      const deletionOrder = getFormulaFieldDeletionOrder(
        allColumnsToUpdate,
        fields
      )

      // Save all column expressions for later recreation
      const columnExpressions: Record<string, string> = {}

      // First delete all related columns (in dependency order)
      for (const colName of deletionOrder) {
        // Save expression for rebuilding
        const expr = transformFormula2VirtualGeneratedField(colName, fields)
        if (expr) {
          columnExpressions[colName] = expr
        }

        // Delete column
        db.prepare(`ALTER TABLE ${tableName} DROP COLUMN ${colName};`).run()
      }

      // Update the current column's expression
      const updatedFields = fields.map((f) =>
        f.table_column_name === tableColumnName ? { ...f, property } : f
      )

      // Recalculate the current column's expression
      columnExpressions[tableColumnName] =
        transformFormula2VirtualGeneratedField(
          tableColumnName,
          updatedFields
        ) || ""

      // Recreate all columns in reverse order (create dependent columns first)
      for (const colName of deletionOrder.reverse()) {
        if (columnExpressions[colName]) {
          db.prepare(
            `ALTER TABLE ${tableName} ADD COLUMN ${colName} GENERATED ALWAYS AS (${columnExpressions[colName]});`
          ).run()
        }
      }