An app that helps you select the perfect gift for those times you just don’t know what to get someone. Giftr helps you select the perfect gift by retrieving the products that best align with your recipient’s hobbies and interests from listings on Etsy.
Tech Stack: SQL, Express, React, Node
Project Map: https://docs.google.com/document/d/1X7YQfvnJKm4Ng_a9i5zoWpwS0UKnWzWGpddiF6J6Kh0/edit
Techtonica Project Outline: https://github.com/Techtonica/curriculum/blob/master/projects/final-project/final-project.md
-
Clone this repo to your desktop.
cd desktop
thengit clone https://github.com/lianthompson/final_react_project.git
-
Go into the folder and install the dependencies.
cd final-react-project
npm install
-
Create an .env file and add your API key to it.
(Request your own key here: https://www.etsy.com/developers/documentation/getting_started/api_basics)
touch .env
REACT_APP_ETSY_API_KEY={YOUR_KEY_HERE}
-
After setting up your database, run
npm run dev
-
Download
Sequel Pro
(http://www.sequelpro.com/) -
Open
Sequel Pro
and enter the following to establish a connection:Host: 127.0.0.1
Username: root
-
Create a database named
Giftr
with the tablesProducts
,Purchases
,Recipients
,Users
.
- In
Products
add the columnstitle
,description
,purchase_id
- In
Purchases
add the columnsproduct_id
,user_id
,recipient_id
- In
Recipients
add the columnsemail
,firstName
,lastName
- In
Users
add the columnsfirstName
,lastName
,email
- Display dummy data from databases on
localhost:4000/products
- Display landing page on
localhost:3000
- Display redirect page on
localhost:4000
- Type text in search
- User Sign in/Sign up
- Search retreives Etsy API data
- Display 3 optimal gift selections
- Purchase history page