:RES: learn mongo, look into mongo AWS stuff

[brennongs]

We are going to put friend info into sql and movie information into mongo. I will get started on working on the SQL first.

• [ ] add friend
• [ ] remove friend
• [ ] accept friend request
• [ ] reject friend request
• [ ] draft schema:
  • user
  • relationshipStatus (initiator [fkey user], recipient [fkey user], status [0 = pending, 1 = active, 2 = inactive])
  • addFriend
  • removeFriend
  • acceptFriendRequest
  • rejectFriendRequest
  • listFriends
• [x] import schema into RDS
• [ ] generate dummy data
• [ ] list friends

[brennongs]

Working on add friends functionality. Currently in the DB there is a function get_user_id(email) which returns ID. invoke it like this select * from get_user_id('brennon@suvi.tv'); --> returns 1

[brennongs]

insert into "Relations" (initiator, recipient, current_status)
  values (
    (select * from get_user_id('brennon@suvi.tv')),
    (select * from get_user_id('steve@suvi.tv')),
    'pending'
  );

inserts the row correctly. next step is to switch on current status.