Skip to content

Instantly share code, notes, and snippets.

View rashadsternes's full-sized avatar

Rashad rashadsternes

View GitHub Profile
@rashadsternes
rashadsternes / BizRecords
Created August 31, 2019 06:58
Biz Records
bizschema=# SELECT * FROM biz WHERE bid =1000;
bid | bizname | reviewcount | rating | price | category | location | phone | url | photos
------+--------------------------+-------------+--------+-------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+---------
1000 | Fried Los Pollos Cottage | 6905 | 3.5 | $ | ["Filipino","Soup"] | {"address1":"35606 Harvey Burgs","address2":"Apt. 212","city":"Jasttown","state":"VT","zipcode":"47923","neighborhood":"Braeswood Place","latitude":-57.253,"longitude":60.998} | (270) 682-4168 | http://margarete.net | {1,2,3}
(1 row)
bizschema=# SELECT * FRO
@rashadsternes
rashadsternes / response.json
Created May 14, 2019 03:42
Get Reviews for business - http://localhost:3000/reviews/business/7
{
"data": [
{
"useful": [],
"funny": [
{
"username": "Lavada Hermiston",
"uId": 75
},
{