Raspberry Pi Forums

Hi all,
New to python, new to programming in fact. I'm creating a project that uses RFID cards and a reader to add credit to a video arcade machine.
As it stands, I can read an RFID card and check to see if the card is active of disabled. If active I need a way to allow the same card to be used only once per minute so looking for some kind of cool down function.

I'm using a mysql database to store the card numbers, maybe I need to have a separate column that holds a value for when the card was last used?

nortski wrote: ↑

Sun Mar 25, 2018 10:12 am

I'm using a mysql database to store the card numbers, maybe I need to have a separate column that holds a value for when the card was last used?

That sounds like a good idea, or even store a time one minute later than when the card was last used and check for that when the card is presented again.

rpdom wrote: ↑

Sun Mar 25, 2018 10:59 am

nortski wrote: ↑

Sun Mar 25, 2018 10:12 am

I'm using a mysql database to store the card numbers, maybe I need to have a separate column that holds a value for when the card was last used?

That sounds like a good idea, or even store a time one minute later than when the card was last used and check for that when the card is presented again.

Hmm yeh that sounds like a good idea, thanks!

In my code, where I'm reading RFID cards with a Wemos, I'm using a 5000 millisecond timer to avoid duplicate reads.

DougieLawson wrote: ↑

Mon Mar 26, 2018 12:26 am

In my code, where I'm reading RFID cards with a Wemos, I'm using a 5000 millisecond timer to avoid duplicate reads.

I used the TIMESTAMPADD to set a time in the future then compare it with the current TIMESTAMP