I am using my own laptop (node red and db running on same machine)
1.Processor: Intel® Core™ i3-4005U CPU @ 1.70GHz × 4
2. linux 64-bit (16.04 ubuntu)
3.RAM-3.8
4.Memory-3.8 GiB
5.1 day at least
Shipra, you said:
That is the computer I am asking about. You said:
so please clarify, which computer is the DB getting full on, ram getting full and the code gets stuck? If it is the arm computer then what type of computer is it and answer the five questions about it. Thank you.
Sir,for time being I am testing first this whole flow in my laptop for testing purpose.
Why bother to test it on your laptop if the 'arm' computer freezes when running the flow?
Sir ,thats true but for now i have to complete this project with testing So kindly help.
Sir ,because on one platform we need to freeze code for reference
Fine, I will try to guide you so you can solve your issue.
If you now want to add a row to the database each time someone uses the FOB, how do you add a row to a database?
ok thank you sir.
we have to trigger everytime the add command in sqlite i think but how i dont know
So this would be a good time to go and do a sqllite tutorial where you will learn how to add rows to a database. I seem to remember suggesting you take a dabase tutorial back in July. You should go back and review it to see how to add rows to a database
Sir that add would be done by insert command that thing i have watched and learned ,but how can i add everytime when a successful fob id is received that i want to know
and with timestamp of uk and india it should insert
Sir please help how can i update timestamp in sqlite db in node red
you should only store the date/time in the database as a UTC value. Then you can convert it to the local time when you read the database and present it.
Why whoul you update the timestamp? When you insert the record, the timestamp should be part of the data you are inserting.
How to do that I want to insert timestamp in a Date-and-time column
Have you done a google search asking that question?
Sir what i learned from google is ,i tried and got the result as this
9/8/2020, 4:44:00 PMnode: 6133b2fa.5dafbc
UPDATE NCS_DATABASE SET Date_and_Time='2020-09-08T11:14:00.195Z' WHERE Person_ID='undefined' : msg.payload : undefined
undefined
First flaw is:
the time is getting updated only when i am triggering the insert timestamp node
Second flaw:
I am using moment node which is giving me correct date but i want UK tine as well as India time.
third flaw:
person id is showing undefined.
So why is the person id not filled in? What are you putting in it that it would show up as undefined?
because it is coming from my gateway side and in my flow it is set as flow.id
