Data into Database #234
-
|
Hi, Now comes question: Does someone throw this data into a database to archive it? Thanks a lot upfront. this is the data which I'm using now:
And as well:
Response for tripinfo: trips : [{ Response for status: full status cached : {"vehicleLocation": { |
Beta Was this translation helpful? Give feedback.
Replies: 4 comments 7 replies
-
|
Database: It depends on which kind you want to use. I'm not familiar with Synology, so I can't say what would be the easiest interface. In any case you would probably need to create tables for the data you want to store before creating commands to store the data. Extracting a single value: client.on("ready", async () => {
const vehicle = client.getVehicle("********");
const fullStatus = await vehicle.fullStatus({ refresh: false, parsed: false });
const time = fullStatus.vehicleLocation.time;
const fuel = fullStatus.vehicleStatus.fuelLevel;
console.log(`time: ${time}, fuel: ${fuel}`);
})Also, if you just want to display the latest data on a HTML page, there's no need for a database. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks a lot. This is exactly what I want to achieve. First try: Result: Next logical step for me: Result: undefined Any idea? |
Beta Was this translation helpful? Give feedback.
-
|
The result is inside an array, so it should be console.log(response[0].dayRaw); |
Beta Was this translation helpful? Give feedback.
-
|
Hi, My issue now: For fetchting the data I needed a loop and now I have no idea how to upload data from a loop into the database. Any advice is appreciated. Thanks Code for fetching the data: Code for write data into mariadb: |
Beta Was this translation helpful? Give feedback.
-
|
thanks, but I struggle already on step before. "2022-12-04","3","237","75","134","51","108","17:40:34","17:52:34","12","8","Sonntag";""; This is the result from the loop. |
Beta Was this translation helpful? Give feedback.
-
|
I would test a couple of variables before putting everything into the database. In the example below I've just used tripdaydate and tripdayCnt. // Define a function to do insert query
function insert_db( tripdaydate , tripdayCnt ) {
pool.getConnection()
.then(conn => {
conn.query(
"INSERT INTO db_table(tripdayavgSpeed) VALUES (?,?)",
[ tripdaydate , tripdayCnt ]
)
.then(...)
})
.catch(...)
}
// Whenever you want to insert actual values, you call the function e.g. in a loop
for(...){
...
insert_db(tripdaydate,tripdayCnt);
}And if you're struggling with the fact that you got some code in one file and some in another file you can export the function you need from the database script. E.g. "mariaDB" fileexport function insert_db( tripdaydate , tripdayCnt ) {
...
}"Fetching data" fileThen import in another file: import { insert_db } from "path/to/mariaDB.js";
for(...){
...
insert_db(tripdaydate,tripdayCnt);
} |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for your help. I imported each single value into the database manually to make sure that everything works. The last step is really to put the values from the "fetching data" file into the "mariadb" file and this not work as I don't know how put the data into the "mariaDB" file. |
Beta Was this translation helpful? Give feedback.
-
|
Does it work if you keep everything in a single file? E.g: // Use the MariaDB Node.js Connector
const mariadb = require('mariadb');
const trpInfo = await vehicle.tripInfo({ year: 2022, month: 12, day: 4 });
// Create a connection pool
const pool =
mariadb.createPool({
host: 'ipaddress',
port: port,
user: 'db_user',
password: 'db_password',
database: 'db'
});
if (trpInfo != '') {
//Erstelle Datum
const tripdaydateraw = trpInfo[0].dayRaw.slice(4, 6) + '/' + trpInfo[0].dayRaw.slice(6, 8) + '/' + trpInfo[0].dayRaw.slice(0, 4);
const tripdaydate = trpInfo[0].dayRaw.slice(0, 4) + '-' + trpInfo[0].dayRaw.slice(4, 6) + '-' + trpInfo[0].dayRaw.slice(6, 8);
const tripdayname = new Date(tripdaydateraw).toLocaleDateString('de-de', { weekday: 'long' });
//Erstelle Anzahl der Fahrten
const tripdayCnt = trpInfo[0].tripsCount;
//Erstelle Tagesdistanz
const tripdayDistance = trpInfo[0].distance;
//Erstelle Tagedurchschnittsgeschwindigkeit
const tripdayavgSpeed = trpInfo[0].speed.avg;
//Erstelle maximale Tagesgeschwindigkeit
const tripdaymaxSpeed = trpInfo[0].speed.max;
// Errechne Anzahl der Fahrten
let i = 0, n = tripdayCnt - 1;
while (i <= n) {
//Restliche Werte definieren
//Erstelle Durchschnittsgeschwindigkeit Fahrt
const tripavgSpeed = trpInfo[0].trips[i].speed.avg;
//Erstelle maximal Fahrgeschwindigkeit
const tripmaxSpeed = trpInfo[0].trips[i].speed.max;
//Startzeit
const strttimstamp = trpInfo[0].trips[i].start;
//Enzeit
const endtimstamp = trpInfo[0].trips[i].end;
//Startdatum
const strtdate = strttimstamp.toLocaleDateString();
//toLocaleTimeString konvertiert GMT + 1, Startzeit
const strtime = strttimstamp.toLocaleTimeString();
//Enddatum
const enddate = endtimstamp.toLocaleDateString();
//toLocaleTimeString konvertiert GMT + 1, Endzeit
const endtime = endtimstamp.toLocaleTimeString();
// Fahrzeit von Minuten in das Format hh:mm umwandeln
function toHoursAndMinutes(totalMinutes) {
const minutes = totalMinutes % 60;
const hours = Math.floor(totalMinutes / 60);
return `${padTo2Digits(hours)}:${padTo2Digits(minutes)}`;
}
function padTo2Digits(num) {
return num.toString().padStart(2, '0');
}
//Fahrzeit in Minuten
const drvtime = toHoursAndMinutes(trpInfo[0].trips[i].durations.drive);
//Distanz
const drvdistance = trpInfo[0].trips[i].distance;
//Werte Ausgeben
const tripinfodata = tripdaydate + ',"' + tripdayCnt + '","' + tripdayDistance + '","' + tripdayavgSpeed + '","' + tripdaymaxSpeed + '","' + tripavgSpeed + '","' + tripmaxSpeed + '","' + strtime + '","' + endtime + '","' + drvtime + '","' + drvdistance + '","' + tripdayname + '";"";';
//console.log(strtime)
pool.getConnection()
.then(conn => {
conn.query("INSERT INTO db_table(tripdayavgSpeed) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)", [tripdaydate, tripdayCnt, tripdayDistance, tripdayavgSpeed, tripdaymaxSpeed, tripavgSpeed, tripmaxSpeed, strtime, endtime, drvtime, drvdistance, tripdayname])
.then((rows) => {
console.log(rows); //[ {val: 1}, meta: ... ]
pool.end();
conn.end();
})
.catch(err => {
//handle error
console.log(err);
pool.end();
conn.end();
});
}).catch(() => {
//not connected
pool.end();
conn.end();
});
console.log(tripinfodata);
i += 1;
}
}; |
Beta Was this translation helpful? Give feedback.
-
|
You made my day. Thanks a lot. After really small tweaks it works. If you need the correct code, please let me know. Thanks again for your support and your time. |
Beta Was this translation helpful? Give feedback.
Hi,
thanks for the support so far.
With your help I'm able to fetch the data I need and convert into a proper structure. I'm also able to connect to my mariadb on synology.
My issue now: For fetchting the data I needed a loop and now I have no idea how to upload data from a loop into the database.
Any advice is appreciated.
Thanks
Code for fetching the data: