2018-01-01 18:49:07 +00:00
|
|
|
# bengaluru-food-census
|
|
|
|
|
|
|
|
|
|
Keep track of restaurant openings and closures in the city.
|
|
|
|
|
|
2018-01-01 19:35:00 +00:00
|
|
|
# Quirks
|
2018-01-01 18:49:07 +00:00
|
|
|
|
2018-12-25 14:28:04 +00:00
|
|
|
- Zomato does not support HTTP/1.1, so wget can't be used.
|
2018-01-01 18:49:07 +00:00
|
|
|
|
2018-01-01 19:35:00 +00:00
|
|
|
# Tech
|
|
|
|
|
|
|
|
|
|
This project uses GNU Parallel, Ruby, Nokogiri, and curl.
|
2018-01-01 18:49:07 +00:00
|
|
|
|
|
|
|
|
# Features
|
|
|
|
|
|
2018-12-25 14:28:04 +00:00
|
|
|
- Keep track of historical data using regularly generated CSV files
|
|
|
|
|
- Does not use the API (since the rate-limit is too low at 1k/day)
|
|
|
|
|
- We need to checkout around 15k restaurant status (closed or not)
|
|
|
|
|
- Keep track of whether restaurant is still alive or not
|
|
|
|
|
- Tweet any restaurant closures (or any new openings)
|
2018-01-14 20:38:10 +00:00
|
|
|
|
|
|
|
|
For now, run the following command to get a diff of new restaurants not in the old listings:
|
|
|
|
|
|
2018-12-25 14:28:04 +00:00
|
|
|
`q -d , "SELECT * from ./2018-MM-DD.csv WHERE c1 not in (SELECT c1 from 2018-MM-DD.csv)"`
|
