CSE451 Final Project Solved

This project will use:

●     Creation of a REST API server

●     Use of O-AUTH

●     Invoking ToDoist APIs

●     Using a new Census API

●     Alexa Skills that will use call ToDoist and will also call other RestAPIs

●     Storing data in a mysql database

●     Use of AJAX calls from a browser based application.

 

Phase 1 will be for Alexa to get access to the users ToDoist Token. To do this start with the provided Skill and modify it in anyway necessary so that if the ToDoist Token for the current user is not present, the token is obtained.

 

Phase 2 will be to create a REST API

 

Phase 3 will be to implement a Web Interface

 

Phase 4 will be to complete the Alexa Skill from the template code.

 

 

You can complete as many phases as you desire. Points for each phase are denoted in the details. You MUST complete phase 1 and can complete the other phases as you desire. They are independent of each other.

 

Details:

●     Phase 1 - MUST BE COMPLETED

                        ○    Title: Alexa OAuth

                        ○    Points: 40

                        ○    The provided code has both the Json for Alexa and the Lambda js code.

○    If the token exists the program will read out the first task. This function exists and does not need to be changed.  If the token does not exist, the code calls a function for oauth which you have to implement.

○    Starter code is https://gitlab.csi.miamioh.edu/campbest/cse451-campbest-node-s19/tree/master/ FinalExam

○     Note: Make sure to use the blueprint "trivia" when setting up the lambda code as this will include the needed dynamodb libraries.

●     Phase 2

○     Title: Rest API

                        ○    Points: 20

                        ○    Implement a REST API on ceclnx01 that meets the following specifications.

○    Create a mysql database (the create script is in the git project associated with this assignment).

                        ○    Create the following APIs

                        ○    get Comments

                                        ■    url: /api/v1/Comments

                                        ■    Method: get

■    JSON_IN: N/A ■      JSON_OUT:

{"msg":string,"Comments":[{"id":int,"comment":string,"createTime":int (unixtime)},...}

                        ○    get Last Comment

                                        ■    url: /api/v1/Comments/Last

                                        ■    method: get

                                        ■    JSON_IN: N/A

                                        ■    JSON_OUT: {"msg":string,"id":int,"comment":string,"createTime":int}

                        ○    Add Comment to List

                                        ■    url: /api/v1/Comment

                                        ■    method: put

                                        ■    JSON_IN: {"password":"class","comment":string}

                                        ■    JSON_OUT: {"msg":string}

                        ○    Delete Comment

                                        ■    url: /api/v1/Comment/:id

                                        ■    method: put

                                        ■    JSON_IN: {"password":"class"}

                                        ■    JSON_OUT: {"msg":string}

                        ○    Delete all comments

                                        ■    url: /api/v1/Comments

                                        ■    method: Delete

                                        ■    JSON_IN: {"password":"class"}

                                        ■    JSON_OUT: {"msg":string}

                        ○    Store all data inside the mysql database

●     Phase 3

○     Title: Web Interface

                        ○    Points: See Below, have to be done in order.

                        ○    Create a web-interface that will call the Above Rest API

                                        ■     Create a table that lists the Comments in the collection. 5 points

                                        ■       For each Comment, create a link that will delete the comment.  5 Points

■    Have a form that will add a comment with good error checking and reporting. (10 points)

                        ○    Must be an AJAX based solution. NO PHP.

●     Phase 4

                        ○    Title: Create Alexa Skill

                        ○    Points: 20

                        ○    Create an alexa Skill that will add and read the last comment.

 

All code used (lambda, javascript, html…) will be submitted to Gitlab and a link shared with the instructor.