Answer to Question #205844 in NodeJS Web Application for zzc

Question #205844

Twitter

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

ColumnTypeuser_idINTEGERnameTEXTusernameTEXTpasswordTEXTgenderTEXT

Follower Table

ColumnTypefollower_idINTEGERfollower_user_idINTEGERfollowing_user_idINTEGER

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

ColumnTypetweet_idINTEGERtweetTEXTuser_idINTEGERdate_timeDATETIME

Reply Table

ColumnTypereply_idINTEGERtweet_idINTEGERreplyTEXTuser_idINTEGERdate_timeDATETIME

Like Table

ColumnTypelike_idINTEGERtweet_idINTEGERuser_idINTEGERdate_timeDATETIME

Sample Valid User Credentials



{

"username":"JoeBiden",

"password":"biden@123"

}


  • API 1
  • API 2
  • Authentication with JWT Token
  • API 3
  • API 4
  • API 5
  • API 6
  • API 7
  • API 8
  • API 9
  • API 10
  • API 11
1
Expert's answer
2021-06-13T18:18:44-0400
Dear zzc, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS