Skip to content

Latest commit

 

History

History
62 lines (51 loc) · 1.67 KB

README.md

File metadata and controls

62 lines (51 loc) · 1.67 KB

FutureTube-Back

Stack

  • Bcrypt
  • Cors
  • Dotenv
  • Express
  • Jsonwebtoken
  • Knex
  • MySql
  • Uuid

Running the project

  1. Clone this repository into your machine

  2. Open your CLI inside the cloned repo and run the following commands:

    • npm install
    • touch .env
    • start .env

  3. Paste the following environment variables into your .env file, replacing their values for those of your own SQL database:

    DB_HOST = mysql
DB_USER = me
DB_PASSWORD = xxxxxx
DB_NAME = myschema
JWT_KEY = xxxxxx

  4. Run the following queries on your SQL database:

     CREATE TABLE future_tube_users (
    id VARCHAR(255) PRIMARY KEY,
    name VARCHAR(255) UNIQUE NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    birth_date DATE NOT NULL,
    password VARCHAR(255) NOT NULL,
    profile_picture VARCHAR(255) NOT NULL
);
     CREATE TABLE future_tube_videos (
    id VARCHAR(255) PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description VARCHAR(255),
    url VARCHAR(255) NOT NULL,
    user_id VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES future_tube_users (id)
);

  5. Run npm run start on your CLI

  6. Open your browser's localhost and test the endpoints using this project's own GUI. You'll find templates for all available requests, but feel free to send them via other softwares such as Postman.

Notes

  • When creating a new user, birthDate must be in format YYYY-MM-DD
  • On Get User Uploads endpoint, you can use either a valid token as authorization in the request headers or an existing ID as a query parameter.