Function saveTable

src/persisters/common/database/commands.ts:147–358

(
    tableName: string,
    rowIdColumnName: string,
    content:
      | {
          [contentId: Id]:
            | {[contentSubId: Id]: CellOrUndefined | ValueOrUndefined}
            | undefined;
        }
      | undefined,
    deleteEmptyColumns: boolean,
    deleteEmptyTable: boolean,
    partial = false,
    condition: DpcTabularCondition = TRUE,
    contentSubIds?: Ids,
  )

  };

  const saveTable = async (
    tableName: string,
    rowIdColumnName: string,
    content:
      | {
          [contentId: Id]:
            | {[contentSubId: Id]: CellOrUndefined | ValueOrUndefined}
            | undefined;
        }
      | undefined,
    deleteEmptyColumns: boolean,
    deleteEmptyTable: boolean,
    partial = false,
    condition: DpcTabularCondition = TRUE,
    contentSubIds?: Ids,
  ): Promise<void> => {
    const contentSubIdSet = isUndefined(contentSubIds)
      ? undefined
      : setNew(contentSubIds);
    const includeContentSubId = (contentSubId: Id): boolean =>
      isUndefined(contentSubIdSet) || collHas(contentSubIdSet, contentSubId);
    const settingColumnNameSet = setNew<string>();
    objMap(content ?? {}, (contentRow) =>
      arrayMap(
        arrayFilter(objIds(contentRow ?? {}), includeContentSubId),
        (cellOrValueId) => setAdd(settingColumnNameSet, cellOrValueId),
      ),
    );
    const settingColumnNames = collValues(settingColumnNameSet);

    // Delete the table
    if (
      isUndefined(contentSubIdSet) &&
      !partial &&
      deleteEmptyTable &&
      condition == TRUE &&
      arrayIsEmpty(settingColumnNames) &&
      collHas(schemaMap, tableName)
    ) {
      await databaseExecuteCommand('DROP ' + TABLE + escapeId(tableName));
      mapSet(schemaMap, tableName);
      return;
    }

    const currentColumnNames = mapGet(schemaMap, tableName);
    const unaccountedColumnNames = setNew(
      arrayFilter(
        collValues(currentColumnNames),
        (columnName) =>
          columnName == rowIdColumnName || includeContentSubId(columnName),
      ),
    );
    if (!arrayIsEmpty(settingColumnNames)) {
      if (!collHas(schemaMap, tableName)) {
        // Create the table
        await databaseExecuteCommand(
          CREATE_TABLE +
            escapeId(tableName) +