Sample REST endpoint

create table product
(
    id                 int auto_increment
        primary key,
    name               varchar(300)  not null,
    price              int default 0 not null,
    available          tinyint(1)    null,
    image              varchar(300)  null,
    available_quantity int default 0 not null
)
    charset = utf8mb3;

{
  "path": "/products",
  "methods": [
    "GET"
  ],
  "query": "products-paginated",
  "authorized": false
}

{
  "type": "sql-select-paginated",
  "id": "products-paginated",
  "connection": "sample-database-connection",
  "query": "SELECT * FROM `product` limit :offset, :limit",
  "queryCount": "SELECT count(*) as c FROM `product`",
  "params": [
    {
      "name": "limit",
      "type": "int",
      "default": 10,
      "required": true
    },
    {
      "name": "page",
      "type": "int",
      "default": 1,
      "required": true
    }
  ]
}

{
  "results": [
    {
      "available": 1,
      "available_quantity": 10,
      "id": 1,
      "image": "/images/shoes.jpng",
      "name": "Shoes",
      "price": 10000
    },
    {
      "available": 1,
      "available_quantity": 2,
      "id": 2,
      "image": "/images/t-shirt.jpng",
      "name": "T-Shirt",
      "price": 1000
    }
  ],
  "count": 2,
  "pages": 1,
  "page": 1
}