The services exposes two routes:
/orama/:author- returns a list of all the posts that matches theauthorquery param using Orama/mapper/:author- returns a list of all the posts that matches theauthorquery param using the native @platformatic/sql-mapper
$ npm installCreate a new migration file in database/migrations/001.do.sql.
CREATE TABLE quotes(
id INTEGER PRIMARY KEY,
author VARCHAR(255) NOT NULL,
quote TEXT NOT NULL
)$ npm run platformatic:migrate
$ npm run platformatic:seed
$ npm start