Cassandra DB: create keyspace covid_hms with replication={'class':'SimpleStrategy', 'replication_factor':1};
CREATE TABLE covid_hms.patientdetails ( patientid text, actiontaken text, admittedon date, age int, bedallotment text, city text, comment text, comorbidity boolean, contacthistory boolean, covidactivestatus boolean, dailypatientcounter text, dateoffirstresult date, dateoffirsttest date, dateofsecondresult date, dateofsecondtest date, dateofthirdresult date, dateofthirdtest date, dischargedon date, district text, firstresult text, lastupdatedon timestamp, mobilenumber text, name text, outcome text, secondresult text, sex text, srfno boolean, symptomstatus text, thirdresult text, travelhistory boolean, PRIMARY KEY (patientid) );
select patientid,actiontaken,admittedon,age,bedallotment,city,comment,comorbidity,contacthistory,covidactivestatus,dateoffirstresult,dateoffirsttest,dateofsecondresult,dateofsecondtest,dateofthirdresult,dateofthirdtest,district,firstname,firstresult,landmark,mobilenumber,outcome,secondresult,sex,symptomstatus,thirdresult,travelhistory from patientdetails; select * from patientdetails;
sample insert:
INSERT INTO covid_hms.patientdetails (patientid,admittedon,covidactivestatus,age,city,country,dischargedon,district,dob,dod,firstname,landmark,lastname,mobilenumber,pincode,sex,state) VALUES ('b776ef4e-a269-11ea-bb37-df','2020-08-08',true,16,'nagpur','India',null,'nagpur','2001-01-01',null,'abc','school','xyz','98765914676',412455,'male','mh');
Sample patient: POST : localhost:8080\covid\addPatient\
{ "patientid": "03544fd8-003c-43bb-af28-ead72a98639f", "firstname": "yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy", "lastname": "asdfsdgsdsdgasd", "age": 46, "sex": "male", "covidactivestatus": false, "mobilenumber": "98765914676", "landmark": "elephant", "city": "uganda", "district": "undada", "country": "Africa", "pincode": 412455, "srfno" : null, "admittedon": "2020-07-08", "dischargedon": "2020-07-08", "travelhistory": null, "contacthistory": null, "comorbidity": null, "symptomstatus": null, "actiontaken": null, "bedallotment": null, "outcome": null, "dateoffirstresult": "2020-07-08", "firstresult": null, "dateofsecondresult": "2020-07-08", "secondresult": null, "dateofthirdresult": "2020-07-08", "thirdresult": null, "comment": null, "lastupdatedon": 1902853 }