Insert statement

Insert data without writing any code

Insert

{
  "type": "sql-insert",
  "id": "order-item-insert",
  "connection": "sample-database-connection",
  "table": "order_item",
  "selectAfterInsert": "SELECT product_id as productId, quantity FROM order_item where id = :lastInsertId",
  "params": [
    {
      "columnName": "order_id",
      "name": "orderId",
      "required": true
    },
    {
      "columnName": "product_id",
      "name": "productId",
      "required": true
    },
    {
      "columnName": "quantity",
      "name": "quantity",
      "required": true
    }
  ]
}

selectAfterInsert - query that will be run after insert, you could for example count total number of items in database and show it to the user

lastInsertId - special param that can be used in selectAfterInsert query

required - required parameters must be provided, otherwise query won’t start, non required params will be omitted in insert