Twitter

Given an app.js file and a database file twitterClone.db consisting of five tables user, follower, tweet, reply, and like.

Write APIs to perform operations on the tables user, follower, tweet, reply, and like containing the following columns,

User Table

| Column | Type | | -------- | ------- | | user_id | INTEGER | | name | TEXT | | username | TEXT | | password | TEXT | | gender | TEXT |

Follower Table

| Column | Type | | ------------------- | ------- | | follower_id | INTEGER | | follower_user_id | INTEGER | | following_user_id | INTEGER |

Here, if user1 follows user2 then,

follower_user_id is the user ID of user1 and following_user_id is the user ID of user2.

Tweet Table

| Column | Type | | --------- | -------- | | tweet_id | INTEGER | | tweet | TEXT | | user_id | INTEGER | | date_time | DATETIME |

Reply Table

| Column | Type | | --------- | -------- | | reply_id | INTEGER | | tweet_id | INTEGER | | reply | TEXT | | user_id | INTEGER | | date_time | DATETIME |

Like Table

| Column | Type | | --------- | -------- | | like_id | INTEGER | | tweet_id | INTEGER | | user_id | INTEGER | | date_time | DATETIME |

Sample Valid User Credentials

{
  "username":"JoeBiden",
  "password":"biden@123"
}

<Section id="section1" >

API 1

Path: /register/

Method: POST

Request

{
  "username": "adam_richard",
  "password": "richard_567",
  "name": "Adam Richard",
  "gender": "male"
}

• Scenario 1

  • Description:

    If the username already exists

  • Response

    • Status code

      400
      

    • Body

      User already exists
      

• Scenario 2

  • Description:

    If the registrant provides a password with less than 6 characters

  • Response

    • Status code

      400
      

    • Body

      Password is too short
      

• Scenario 3

  • Description:

    Successful registration of the registrant

  • Response

    • Status code

      200
      

    • Body

      User created successfully
      

</Section> <Section id="section2">

API 2

Path: /login/

Method: POST

Request

{
  "username":"JoeBiden",
  "password":"biden@123"
}

• Scenario 1

  • Description:

    If the user doesn't have a Twitter account

  • Response

    • Status code

      400
      

    • Body

      Invalid user
      

• Scenario 2

  • Description:

    If the user provides an incorrect password

  • Response

    • Status code

      400
      

    • Body

      Invalid password
      

• Scenario 3

  • Description:

    Successful login of the user

  • Response

    Return the JWT Token

    {
      "jwtToken": "ak2284ns8Di32......"
    }
    

</Section> <Section id="authToken">

Authentication with JWT Token

Write a middleware to authenticate the JWT token.

• Scenario 1

  • Description:

    If the JWT token is not provided by the user or an invalid JWT token is provided

  • Response

    • Status code

      401
      

    • Body

      Invalid JWT Token
      

• Scenario 2

  • After successful verification of JWT token, proceed to next middleware or handler

</Section> <Section id="section3">

API 3

Path: /user/tweets/feed/

Method: GET

Description:

Returns the latest tweets of people whom the user follows. Return 4 tweets at a time

Response

 [
   {
      username: "SrBachchan",
      tweet: "T 3859 - do something wonderful, people may imitate it ..",
      dateTime: "2021-04-07 14:50:19"
   },
   ...
 ]

</Section> <Section id="section4">

API 4

Path: /user/following/

Method: GET

Description:

Returns the list of all names of people whom the user follows

Response

[
  {
    "name": "Narendra Modi"
  },
  ...
]

</Section> <Section id="section5">

API 5

Path: /user/followers/

Method: GET

Description:

Returns the list of all names of people who follows the user

Response

[
  {
    "name": "Narendra Modi"
  },
  ...
]

</Section> <Section id="section6">

API 6

Path: /tweets/:tweetId/

Method: GET

• Scenario 1

  • Description:

    If the user requests a tweet other than the users he is following

  • Response

    • Status code

      401
      

    • Body

      Invalid Request
      

• Scenario 2

  • Description:

    If the user requests a tweet of the user he is following, return the tweet, likes count, replies count and date-time

  • Response

    {
       "tweet": "T 3859 - do something wonderful, people may imitate it ..",
       "likes": 3,
       "replies": 1,
       "dateTime": "2021-04-07 14:50:19"
    }
    

</Section> <Section id="section7">

API 7

Path: /tweets/:tweetId/likes/

Method: GET

• Scenario 1

  • Description:

    If the user requests a tweet other than the users he is following

  • Response

    • Status code

      401
      

    • Body

      Invalid Request
      

• Scenario 2

  • Description:

    If the user requests a tweet of a user he is following, return the list of usernames who liked the tweet

  • Response

    {
       "likes": ["albert", ]
    }
    

</Section> <Section id="section8">

API 8

Path: /tweets/:tweetId/replies/

Method: GET

• Scenario 1

  • Description:

    If the user requests a tweet other than the users he is following

  • Response

    • Status code

      401
      

    • Body

      Invalid Request
      

• Scenario 2

  • Description:

    If the user requests a tweet of a user he is following, return the list of replies.

  • Response

    ```
    {
       "replies": [
         {
           "name": "Narendra Modi",
           "reply": "When you see it.."
          },
        ...]
    }
    ```
    

    </Section>

<Section id="section9">

API 9

Path: /user/tweets/

Method: GET

Description:

Returns a list of all tweets of the user

Response

[
  {
    "tweet": "Ready to don the Blue and Gold",
    "likes": 3,
    "replies": 4,
    "dateTime": "2021-4-3 08:32:44"
  },
  ...
]

</Section> <Section id="section10">

API 10

Path: /user/tweets/

Method: POST

Description:

Create a tweet in the tweet table

Request

{
   "tweet": "The Mornings..."
}

Response

Created a Tweet

</Section> <Section id="section11">

API 11

Path: /tweets/:tweetId/

Method: DELETE

• Scenario 1

  • Description:

    If the user requests to delete a tweet of other users

  • Response

    • Status code

      401
      

    • Body

      Invalid Request
      

• Scenario 2

  • Description:

    If the user deletes his tweet

  • Response

    Tweet Removed
    

</Section> <br/>

Use npm install to install the packages.

Export the express instance using the default export syntax.

Use Common JS module syntax.