Forem: Marco David Martinez

Finally completed my Twilio Hackathon COVID-19-Communications project

Marco David Martinez — Fri, 01 May 2020 04:15:14 +0000

About

Send SMS & Emails to Covid19 patients family members in a simple to use portal

Video

Features

Reactjs Portal
Reporting capabilities
Twilio SMS and Twilio Sendgrid
Server less DB
Server less Node.js functions

How to use it

Project Overview

Folder Structure

├───diagrams
├───lambda
│   ├───covid19-rds-service
│   └───covid19-twilio-service
│       └───node_modules
│           ├───axios
│           │   ├───dist
│           │   └───lib
│           │       ├───adapters
│           │       ├───cancel
│           │       ├───core
│           │       └───helpers
│           ├───debug
│           │   └───src
│           ├───follow-redirects
│           └───ms
└───react-portal
    ├───public
    └───src
        ├───components
        │   ├───CardOption
        │   ├───DialogNewFamilly
        │   ├───DialogNewPatientNote
        │   ├───DialogPatient
        │   ├───DialogUpdateFamilly
        │   ├───DialogUpdatePatientNote
        │   ├───FabBack
        │   ├───GridOptions
        │   ├───HeroMessage
        │   ├───PatientTable
        │   ├───RegisterFamily
        │   ├───RegisterPatient
        │   ├───SearchOptions
        │   ├───SnackBarNotification
        │   ├───TableHeadPatient
        │   ├───TabPanel
        │   └───ToolbarTop
        ├───hooks
        │   └───Debounce
        ├───icons
        ├───pages
        │   ├───Main
        │   ├───Patient
        │   └───Register
        └───utils

Local Setup

git https://github.com/markwinap/Twilio-Hackathon-COVID-19-Communications.git
cd Twilio-Hackathon-COVID-19-Communications\react-portal

Install Portal dependencies

npm install

Run portal locally

npm run

LAMBDA

covid19-rds-service
covid19-twilio-service

RDS

NAME: covid19
Engine: Aurora (MySQL) Serverless

Patient TABLE SCHEDMA

CREATE TABLE patient (
patientId INT AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(30) DEFAULT '',
lastName VARCHAR(30) DEFAULT '',
ssn VARCHAR(9) DEFAULT '',
bed VARCHAR(20) DEFAULT '',
age TINYINT DEFAULT 1,
sex TINYINT DEFAULT 1,
status TINYINT DEFAULT 1,
createdDate DATE,
updatedDate DATE,
admissionDate DATE ,
exitDate DATE
);

Patient TABLE SCHEDMA

CREATE TABLE familly (
famillyId INT AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(30) DEFAULT '',
lastName VARCHAR(30)  DEFAULT '',
relationship TINYINT  DEFAULT 1,
email VARCHAR(40),
mobile VARCHAR(40),
createdDate DATE,
updatedDate DATE,
patientId INT DEFAULT 1
);

PatientNotes TABLE SCHEDMA

CREATE TABLE notes (
noteId INT AUTO_INCREMENT PRIMARY KEY,
createdDate DATE,
updatedDate DATE,
patientId INT DEFAULT 1,
public TINYINT(1) DEFAULT 0,
note TEXT
);

API GATEWAY

INSERT RECORD

curl --location --request POST 'https://host/DEV/aurora' \
--header 'Content-Type: application/json' \
--data-raw ' {
    "sql":
      "INSERT INTO patient (firstName,lastName,ssn,bed,age,sex,status,createdDate,updatedDate,admissionDate,exitDate) values (:firstName,:lastName,:ssn,:bed,:age,:sex,:status,:createdDate,:updatedDate,:admissionDate,:exitDate)",
    "parameters": [
      { "name": "firstName", "value": { "stringValue": "juan" } },
      { "name": "lastName", "value": { "stringValue": "perez" } },
      { "name": "ssn", "value": { "stringValue": "123456789" } },
      { "name": "bed", "value": { "stringValue": "abc12" } },
      { "name": "age", "value": { "longValue": 1 } },
      { "name": "sex", "value": { "longValue": 1 } },
      { "name": "status", "value": { "longValue": 1 } },
      { "name": "createdDate", "value": { "stringValue": "2020-04-29" } },
      { "name": "updatedDate", "value": { "stringValue": "2020-04-29" } },
      { "name": "admissionDate", "value": { "stringValue": "2020-04-29" } },
      { "name": "exitDate", "value": { "stringValue": "2020-04-29" } }
    ]
}'

SELECT RECORDS

curl --location --request POST 'https://host/DEV/aurora' \
--header 'Content-Type: application/json' \
--data-raw ' {
    "sql": "SELECT * FROM patient LIMIT 1",
    "parameters": []
}'

UPDATE RECORD

curl --location --request POST 'https://host/DEV/aurora' \
--header 'Content-Type: application/json' \
--data-raw ' {
    "sql": "UPDATE patient SET firstName=:firstName,lastName=:lastName,ssn=:ssn,bed=:bed,age=:age,sex=:sex,status=:status,updatedDate=:updatedDate WHERE patientId = :patientId",
    "parameters": [
        { "name": "patientId", "value": { "longValue": 1 } },
      { "name": "firstName", "value": { "stringValue": "Juan" } },
      { "name": "lastName", "value": { "stringValue": "Perez" } },
      { "name": "ssn", "value": { "stringValue": "987654321" } },
      { "name": "bed", "value": { "stringValue": "abc12" } },
      { "name": "age", "value": { "longValue": 30 } },
      { "name": "sex", "value": { "longValue": 1 } },
      { "name": "status", "value": { "longValue": 20 } },
      { "name": "updatedDate", "value": { "stringValue": "2020-04-30" } }
    ]
}'

Send Notifications

curl --location --request POST 'https://w1dms5jz5f.execute-api.us-west-2.amazonaws.com/DEV/twilio' \
--header 'Content-Type: application/json' \
--data-raw '{"familyMembers":[{"famillyId":4,"firstName":"Marco","lastName":"Martinez","relationship":1,"email":"markwinap@gmail.com","mobile":"","createdDate":"2020-05-01","updatedDate":"2020-05-01","patientId":4},{"famillyId":5,"firstName":"oswaldo","lastName":"Martinnez","relationship":1,"email":"","mobile":"","createdDate":"2020-05-01","updatedDate":"2020-05-01","patientId":4},{"famillyId":6,"firstName":"Simple","lastName":"test","relationship":3,"email":"test@test.com","mobile":"+524494382517","createdDate":"2020-05-01","updatedDate":"2020-05-01","patientId":4}],"selectedPatient":{"patientId":4,"firstName":"Chucho","lastName":"Gonzalez","name":"Chucho Gonzalez","ssn":"4561","bed":"TTT3","age":20,"sex":0,"status":1,"createdDate":"2020-04-29","updatedDate":"2020-04-30","admissionDate":"2020-04-29","exitDate":"2020-04-29"},"note":"Patient is feeling a lot better"}'

Cognito

Identity Pool

Id:
us-west-2:a2eb48fc-6f49-49a1-b111-fd3482f80043
ARN
arn:aws:cognito-identity:us-west-2:843132870052:identitypool/us-west-2:a2eb48fc-6f49-49a1-b111-fd3482f80043

User Pool

Id:
us-west-2_suNGk8GOZ
ARN:
arn:aws:cognito-idp:us-west-2:843132870052:userpool/us-west-2_suNGk8GOZ

App Clients
WebClient
App Id:
5u2cgop5aghadug1do59rp8s5o
AppClient
App Id:
7pqjad5dlqbiqnfp7aqqdluork

Finally touching back-end stuff

Marco David Martinez — Wed, 29 Apr 2020 15:15:35 +0000

Yesterday night finally crossed the line of having a nice portal (zombie mode) and a portal pushing and pulling data from the cloud. On my first post i described the overall picture of my project and based on that, i decided to host my back-end on AWS.

Basic stuff. API Gateway for my rest endpoints, lambdas for my server-less Node.js functions and RDS the relational database using Aurora server-less. I chose a relational DB instead of non-relational (DynamoDB) primarily for others to host their DB using other services and secondly for relating patient tables with family members.

Also I finally updated my README file :P

Twilio-Hackathon-COVID-19-Communications

LAMBDA

covid19-rds-service

RDS

NAME: covid19
Engine: Aurora (MySQL) Serverless

Patient TABLE SCHEDMA

CREATE TABLE patient (
patientId INT AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(30) DEFAULT '',
lastName VARCHAR(30) DEFAULT '',
ssn VARCHAR(9) DEFAULT '',
bed VARCHAR(20) DEFAULT '',
age TINYINT DEFAULT 1,
sex TINYINT DEFAULT 1,
status TINYINT DEFAULT 1,
createdDate DATE,
updatedDate DATE,
admissionDate DATE ,
exitDate DATE
);

Patient TABLE SCHEDMA

CREATE TABLE familly (
famillyId INT AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(30) DEFAULT '',
lastName VARCHAR(30)  DEFAULT '',
relationship TINYINT  DEFAULT 1,
email VARCHAR(40),
mobile VARCHAR(40),
createdDate DATE,
updatedDate DATE,
patientId INT DEFAULT 1
);

PatientNotes TABLE SCHEDMA

CREATE TABLE notes (
noteId INT AUTO_INCREMENT PRIMARY KEY,
createdDate DATE,
updatedDate DATE,
patientId INT DEFAULT 1,
public TINYINT(1) DEFAULT 0,
note TEXT
);

API GATEWAY

INSERT RECORD

curl --location --request POST 'https://host.com/DEV/aurora' \
--header 'Content-Type: application/json' \
--data-raw ' {
    "sql":
      "INSERT INTO patient (firstName,lastName,ssn,bed,age,sex,status,createdDate,updatedDate,admissionDate,exitDate) values (:firstName,:lastName,:ssn,:bed,:age,:sex,:status,:createdDate,:updatedDate,:admissionDate,:exitDate)",
    "parameters": [
      { "name": "firstName", "value": { "stringValue": "juan" } },
      { "name": "lastName", "value": { "stringValue": "perez" } },
      { "name": "ssn", "value": { "stringValue": "123456789" } },
      { "name": "bed", "value": { "stringValue": "abc12" } },
      { "name": "age", "value": { "longValue": 1 } },
      { "name": "sex", "value": { "longValue": 1 } },
      { "name": "status", "value": { "longValue": 1 } },
      { "name": "createdDate", "value": { "stringValue": "2020-04-29" } },
      { "name": "updatedDate", "value": { "stringValue": "2020-04-29" } },
      { "name": "admissionDate", "value": { "stringValue": "2020-04-29" } },
      { "name": "exitDate", "value": { "stringValue": "2020-04-29" } }
    ]
}'

SELECT RECORDS

curl --location --request POST 'https://host/DEV/aurora' \
--header 'Content-Type: application/json' \
--data-raw ' {
    "sql": "SELECT * FROM patient LIMIT 1",
    "parameters": []
}'

UPDATE RECORD

curl --location --request POST 'https://host/DEV/aurora' \
--header 'Content-Type: application/json' \
--data-raw ' {
    "sql": "UPDATE patient SET firstName=:firstName,lastName=:lastName,ssn=:ssn,bed=:bed,age=:age,sex=:sex,status=:status,updatedDate=:updatedDate WHERE patientId = :patientId",
    "parameters": [
        { "name": "patientId", "value": { "longValue": 1 } },
      { "name": "firstName", "value": { "stringValue": "Juan" } },
      { "name": "lastName", "value": { "stringValue": "Perez" } },
      { "name": "ssn", "value": { "stringValue": "987654321" } },
      { "name": "bed", "value": { "stringValue": "abc12" } },
      { "name": "age", "value": { "longValue": 30 } },
      { "name": "sex", "value": { "longValue": 1 } },
      { "name": "status", "value": { "longValue": 20 } },
      { "name": "updatedDate", "value": { "stringValue": "2020-04-30" } }
    ]
}'

Its always a good idea to keep your project simple and under scope.

Marco David Martinez — Tue, 28 Apr 2020 13:18:04 +0000

Yesterday i hit the wall at 100MPH, the wall of complexity and frustration. The worst part is that is all my fault. I more or less narrow my faults in the following points.

Started my project 2 days ago.
Over scope my project (take a look at my first post detailing the project structure)
Spent a ton of time creating the web portal components

Thankfully is see the light at the end of the tunnel. Today i will start working on connecting the front end and back end (DB + server-less functions + Twilio ) Tomorrow, hopefully i will have time to complete the security and connect the remaining services.

Portal progress, still a long way to go!

Marco David Martinez — Sun, 26 Apr 2020 23:21:24 +0000

Today i was able to make good progress on the portal side. I created a portal for adding COVID-19 patients, family members and the skeleton for my patient search.

The stress is killing me and i need time off from this project. But tomorrow i will resume my activities and hopefully start working on the back-end,

Repo
https://github.com/markwinap/Twilio-Hackathon-COVID-19-Communications

My Hackathon Project - Better Late Than Never

Marco David Martinez — Sun, 26 Apr 2020 01:41:52 +0000

I fins interesting that now that we are forced to stay at home (global pandemic) it is extremely hard to find time and to get things done. But i now added a tone of post-its to my computer to slap my face (stay focus) and get things done. I only have at the most 15 hours to complete this project (full time job + sleep + eat + home tasks)

You can find attached my project in a simple diagram with a simple overview of the user flow, the data to capture and the services i want to use.

So guys wish me luck.

Forem: Marco David Martinez

Finally completed my Twilio Hackathon COVID-19-Communications project

About

Video

Features

How to use it

Portal Demo

Repo

Miro whiteboard

Project Overview

Folder Structure

Local Setup

Install Portal dependencies

Run portal locally

LAMBDA

RDS

Patient TABLE SCHEDMA

Patient TABLE SCHEDMA

PatientNotes TABLE SCHEDMA

API GATEWAY

INSERT RECORD

SELECT RECORDS

UPDATE RECORD

Send Notifications

Cognito

Identity Pool

User Pool

Finally touching back-end stuff

Twilio-Hackathon-COVID-19-Communications

LAMBDA

RDS

Patient TABLE SCHEDMA

Patient TABLE SCHEDMA

PatientNotes TABLE SCHEDMA

API GATEWAY

INSERT RECORD

SELECT RECORDS

UPDATE RECORD

Its always a good idea to keep your project simple and under scope.

Portal progress, still a long way to go!

My Hackathon Project - Better Late Than Never