The services exposes two routes:
/orama/:author
- returns a list of all the posts that matches theauthor
query param using Orama/mapper/:author
- returns a list of all the posts that matches theauthor
query param using the native @platformatic/sql-mapper
$ npm install
Create 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