T6: PUT Keys connected to the DB

North-Seattle-College / ad440-winter2020-thursday-repo

Repository for AD440 Thursday Class in Winter 2020

Apache License 2.0

10 stars 5 forks source link

T6: PUT Keys connected to the DB #77

Open UnTamedLaw opened 4 years ago

UnTamedLaw commented 4 years ago

Deliverables:

PUT Keys connected to the DB
Documentation via Swagger -Copy and paste link to wiki page

miscdats commented 4 years ago

Connection code added to function in AWS Lambda. Dev time: 5 points

When called upon, function will connect to RDS with environment variables, then run a mysql query to update the entry specified by the input. Main input consists of keybundle_id and property_id to be able to find the entry needing to be modified.

To do next: get info from RDS on entry, with a join query for cross-table examination before updating. This will add 'check-in' functionality, as well as current check-out.

lambda PR : https://github.com/North-Seattle-College/ad440-winter2020-thursday-repo/pull/88 OpenAPI documentation

miscdats commented 4 years ago

When I tried to test as previously, I ran into 403 FORBIDDEN at times. Yun pointed out SAM CLI tool from AWS, am in process of setting that up. Installing Windows 10 first as pre-req.

miscdats commented 4 years ago

test task feature branch feature endpoint - test during development

Actual dev time: 8 pts

When testing new endpoint link, not receiving 403 FORBIDDEN! Now is 500 INTERNAL SERVER ERROR, due to update in swagger doc (I believe) not rolled out in API gateway; no problem, should update by next sprint. The logs tell us what has happened behind server doors: successful function interaction with our DB using temporary Anu credentials. lambda_func access credentials should hopefully be coming soon. Relevant issue created

CloudWatch Log pictured below:

cloudwatch_log