VARUNAMAALAA-Work package 2-Software Modules-Storage and GUI [VARUNAMAALAA WEB]]

@Shameera S L, Guide the activity.

JSON from datahandling module for struct data storage in online and offline mode from buoys/satellite

[{
"DS_DATA_LBL": ""
"PKT_CAPTURE_DATETIME": ""
"PKT_DESCRIPTION" : "",
"SEN_LABEL": "",
"PARAM_DATA_LBL": "",
"PARAM_VALUE": "",
"SEN_LABEL_FOR_HEALTH": "",
"QC1_VALUE": "",
"QC2_VALUE": "",
"MEAN_VALUE": "",
"KURTOSIS_VALUE": "",
"ACCEPT_OR_REJECT": "",
"SEN_DESCRIPTION": "",
"SEN_DATETIME": "",
"STD_VALUE": "",
"PERCENTILE_VALUE": [],
"CREATED_BY":
}]

Write an API in Node JS with database functions for accepting a JSON format as above
and insert data based on the following logic

• The tables DATA_STRUCT_STORE, DATA_STRUCT_PARAMS and DATA_STRUCT_BUOY_PARAMS
• to be filled with data in online and offline from data handling module

• Form Primary keys
• Check for existing DATA_STRUCT_STORE_ID from DATA_STRUCT_PARAMS based on MISS_DPL_ID, DS_ID and CAPTURE_DATETIME for each data
• For sensor reprsenting buoy health measurement (17), the table DATA_STRUCT_BUOY_PARAMS is to be populated
• Retrieve DS_ID from DS_DATA_LBL
• Retreive MISS_DPL_ID from the mission active based on CAPTURE_DATE_TIME
• Get MISS_DPL_SEN_ID from SEN_LABEL and from the mission active based on CAPTURE_DATE_TIME (MISS_DPL_ID)