How to add to field if id already exists

[gaganbiswas]

I have a stock and a virtual_stock collection. I want to add data to the virtual_stock wherever my stock is added. I wrote this piece of code for the same which is working fine.

routerAdd("POST", "/stock/add", (c) => {
  const info = $apis.requestInfo(c);
  const { data } = info.data;

  const stock_collection = $app.dao().findCollectionByNameOrId("stock");
  const vstock_collection = $app
    .dao()
    .findCollectionByNameOrId("virtual_stock");

  $app.dao().runInTransaction((txDao) => {
    for (let item of data) {
      const stock_record = new Record(stock_collection);
      const vstock_record = new Record(vstock_collection);

      const stock_form = new RecordUpsertForm($app, stock_record);

      stock_form.setDao(txDao); // use the transaction dao for the db operations
      stock_form.loadData(item);
      stock_form.submit();

      const vstock_form = new RecordUpsertForm($app, vstock_record);

      vstock_form.setDao(txDao); // use the transaction dao for the db operations
      vstock_form.loadData(item);
      vstock_form.submit();

      //   verify that the inserted record can be accessed by the current request client, otherwise rollback
      if (
        !txDao.canAccessRecord(
          stock_record,
          info,
          stock_collection.createRule
        ) &&
        !txDao.canAccessRecord(
          vstock_record,
          info,
          vstock_collection.createRule
        )
      ) {
        throw new ForbiddenError("The operation is not allowed.");
      }
    }
  });

  return c.json(200, { status: 1 });
});

But, I also wanna check if my stock & virtual stock already have the product and if it does then I just wanna update the quantity for the same.

My stock & virtual_stock has the same model:
id(string), product(relation), quantity(number)

Side Note: The data that I am sending is in the form of {product: string, quantity: number}[]

[ganigeorgiev]

You can call findRecordById as part of your transaction and try catch the result, something like:

let stock_record;
try {
    stock_record = txDao.findRecordById(stock_collection.id, item.id);
} catch {
    stock_record = new Record(stock_collection);
}

let vstock_record;
try {
    vstock_record = txDao.findRecordById(vstock_collection.id, item.id);
} catch {
    vstock_record = new Record(vstock_collection);
}

[ganigeorgiev]

On second read and based on your side-note, you want to check for stock_record/vstock_record based on the "product" field and not on the "id". In this case you can replace findRecordById in the above with findFirstRecordByData(yourCollecitonNameOrId, "product", item.product) (assuming that the product field is unique).

[gaganbiswas]

Thank you for the swift reply and solution.

[gaganbiswas]

So, I got the first part ok. But how will I update the quantity field if the product already exists. It says Value must be unique when I am trying to update using this:

const stock_form = new RecordUpsertForm($app, stock_record);
stock_form.setDao(txDao); // use the transaction dao for the db operations
stock_form.loadData(item);
stock_form.submit();

[gaganbiswas]

Did something like this:

const stock_form = new RecordUpsertForm($app, stock_record);
stock_form.setDao(txDao);
stock_form.loadData({
product: stock_record.get("product") || item.product,
quantity: stock_record.getInt("quantity")
          ? stock_record.getInt("quantity") + item.quantity
          : item.quantity,
      });
stock_form.submit();

Getting the same result when doing this. And on the side note, yes my product field is unique.

[ganigeorgiev]

It is not clear what is the issue and what you are trying to do.

If you are receiving a "unique" validation error then either the stock_record is a new record with existing unique field values or you are not properly fetching the old record.

But in any case without details about your collections structure I don't think I'll be able to help you. If you are still not able to resolve your issue, please elaborate more clearly what you are trying to do and export your collections configuration as json (Admin UI > Settings > Export collections).