Notes

var AWS = require("aws-sdk");

AWS.config = new AWS.Config();
AWS.config.accessKeyId = "AKIAJQVFLOR6GBGYO4ZA";
AWS.config.secretAccessKey = "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";
AWS.config.region = "us-east-2";

// AWS.config.update({
// region: "us-east-2"
// // endpoint: "http://localhost:8000"
// });

var docClient = new AWS.DynamoDB.DocumentClient();

//console.log("Querying for movies from 1992 - titles A-L, with genres and lead actor");

var params = {
TableName: "deviceDump",
// ProjectionExpression:"#yr, title, info.genres, info.actors[0]",
// KeyConditionExpression: "#yr = :yyyy and title between :letter1 and :letter2",
KeyConditionExpression: "senseID = :senseID",
// ExpressionAttributeNames: {
// senseID: "senseID"
// },
ExpressionAttributeValues: {
// ":yyyy": 1992,
// ":letter1": "A",
// ":letter2": "L"
":senseID": "B4E62DA814AD"
}
};

const STY1SD1ArrayForChart = [];

docClient.query(params, function(err, data) {
if (err) {
console.log("Unable to query. Error:", JSON.stringify(err, null, 2));
} else {
console.log("Query succeeded.");
data.Items.forEach(function(item) {
const STY1SD1Array = [
parseInt(item.timestamp),
item.payload.DATA[0].SD_1
];
STY1SD1ArrayForChart.push(STY1SD1Array);
console.log(
"For senseId board # " +
item.senseID +
" at timestamp " +
parseInt(item.timestamp) +
"n" +
"STY 1 - TSL2540 - SD_1 - VisData is " +
item.payload.DATA[0].SD_1 +
"n" +
"STY 1 - TSL2540 - SD_2 - IrData is " +
item.payload.DATA[0].SD_2 +
"n" +
"STY 2 - SHT3X - SD_1 - Temperature is " +
item.payload.DATA[1].SD_1 +
" Celsius" +
"n" +
"STY 2 - SHT3X - SD_2 - Humidity is " +
item.payload.DATA[1].SD_2 +
" %RH" +
"n" +
"STY 4 - MAX31856 - SD_1 - Thermocouple C is " +
item.payload.DATA[2].SD_1 +
" Celsius" +
"n" +
"STY 4 - MAX31856 - SD_2 - Thermocouple F is " +
item.payload.DATA[2].SD_2 +
" Fahrenheit" +
"n" +
"STY 5 - SCD30 - SD_1 - Temperature is " +
item.payload.DATA[3].SD_1 +
" Celsius" +
"n" +
"STY 5 - SCD30 - SD_2 - Humidity is " +
item.payload.DATA[3].SD_2 +
" %RH" +
"n" +
"STY 5 - SCD30 - SD_2 - Co2 is " +
item.payload.DATA[3].SD_3 +
" ppm" +
"n" +
"STY 6 - SGP30 - SD_1 - TVOC is " +
item.payload.DATA[4].SD_1 +
" ppb" +
"n" +
"STY 6 - SGP30 - SD_2 - eCO2 is " +
item.payload.DATA[4].SD_2 +
" ppm" +
"n"
);
// + ": " + item.title
// + " ... " + item.info.genres
// + " ... " + item.info.actors[0]);
// });
//console.log(JSON.stringify(data, null, 2));
});
}
console.log(STY1SD1ArrayForChart);
});

module.exports = { STY1SD1ArrayForChart: "STY1SD1ArrayForChart" };