Method setRecords

packages/widget-sdk/src/model/datasheet.ts:494–532

* Updates cell values for records. * @param records Specify the records be modified. * @return * * #### Description * Throws an error if the user does not have permission to update the given cell values in the record, or or recordId does not exist, * or when the written value type

(records: { id: string, valuesMap: { [key: string]: any } }[])

   * ```
   */
  async setRecords(records: { id: string, valuesMap: { [key: string]: any } }[]) {
    const recordIds: string[] = [];
    const recordsValues: { [key: string]: any }[] = [];
    for (const record of records) {
      recordIds.push(record.id);
      recordsValues.push(record.valuesMap);
    }
    const state = this.wCtx.widgetStore.getState() as any as IReduxState;
    const transformedRecordsValues = this.transformRecordValues(recordsValues);
    this.checkRecordsValues(transformedRecordsValues);

    const data = records.reduce<ISetRecordOptions[]>((pre, record) => {
      const recordId = record.id;
      const recordData = Selectors.getRecord(state, recordId, this.datasheetId);
      if (!recordData) {
        throw new Error(`RecordId: ${recordId} is not exist in datasheet`);
      }

      this.transformRecordValues([record.valuesMap]).forEach(valueMap => {
        Object.entries(valueMap).forEach(([fieldId, cellValue])=> {
          pre.push({
            recordId,
            fieldId,
            value: cellValue,
          });
        });
      });
      return pre;
    }, []);

    const result: ICollaCommandExecuteResult<any> = await cmdExecute({
      cmd: CollaCommandName.SetRecords,
      datasheetId: this.datasheetId,
      data,
    }, this.wCtx.id);
    if (result.result === ExecuteResult.Fail) {
      throw new Error(result.reason);
    }
  }

  /**
   * Delete the given record.