tinvaan / frenzy Goto Github PK

At present, when querying for all restaurants that are open at a given datetime, we simply iterate over all records and look for matches where the given datetime falls within the opening hours in the json field for the restaurant.

This is a very naive approach. Can we perform some level of filtering on the data layer before any processing and transforming on the application layer?

SQlite supports the json1 format for querying: https://www.sqlite.org/json1.html

Some usage examples:

• https://database.guide/sqlite-json_extract/
• https://stackoverflow.com/questions/8187288/sql-select-between-dates
• https://stackoverflow.com/questions/1975737/sqlite-datetime-comparison
• https://sqlite.org/lang_datefunc.html
• https://stackoverflow.com/questions/29971762/sqlite-database-select-the-data-between-two-dates
• https://stackoverflow.com/questions/51061623/mysql-date-comparison-using-between-in-mysql-json-data
• https://stackoverflow.com/a/58521322 [READ THIS]
• https://stackoverflow.com/a/43127894 [READ THIS]

• Update README
• API documentation (optional)

tape/blue-tape should do: https://www.npmjs.com/package/tape

Taks

• Test harness
• Coverage report
• Linter

We are provided two raw datasets that we want to model onto a relational database schema.

1. https://gist.github.com/seahyc/b9ebbe264f8633a1bf167cc6a90d4b57
2. https://gist.github.com/seahyc/de33162db680c3d595e955752178d57d

Tasks

• Extract and parse the given datasets
  • Opening hours datetime strings
  • Transaction datetime strings

Deploy the app on a free hosting tier available somewhere. Heroku might be the easiest.

The datetime parsing module is still a bit flaky. Cover more test cases and fix them all

Tasks

• Containerization (Dockerfile)
• drone.yaml or GHA scripts

Use a dedicated logging library to provide improved debugging contexts. Bunyan seems like a good choice: https://www.npmjs.com/package/bunyan

Tasks

• Design suitable schema CRUD operations
• Add a pluggable ORM support
• Support and test for atomic transactions (eg: purchases)

Can use a config package available in npm: https://www.npmjs.com/package/config

• Server name
• Server port
• Database configs
• Runtime secrets

We need to test for concurrent requests on the purchase endpoint. Can we use something like https://www.npmjs.com/package/loadtest ?