Closed

Python programming for rfid, MySQL and Raspberry Pi

This project was awarded to ngocphukmt for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$10 - $150 USD
Total Bids
8
Project Description

I need help to write a python program described below to read rfid tags, activate two relays and save rfid number to MySQL database.

----------- Equipment -----------

I will use the following products for this project:
- Raspberry Pi B with ethernet connection and Raspbian OS (OS can of course be changed if needed)
- SainSmart 5V 2 Channel Relay ([url removed, login to view])
- MAX3232 RS232 Serial Port To TTL Converter Module ([url removed, login to view])
- RFID-reader (please see attached pdf for user manual. Help on how to connect it to the rs232 converter is needed)


----------- Programming details-----------

MySQL database specification:

Three tables; one table named MF_Logg with fields Logg_ID, Logg_RFID_ID and Logg_Tid, one table named MF_Djur with fields Djur_RFID_ID, Djur_Namn, Djur_Intervall, Djur_Intervall_Foder1, Djur_Intervall_Foder2, Djur_Foder1 and Djur_Foder2 and one table named MF_Lantbruk (I will complete this table later, but data from column Lantbruk_Email will be used in this project).


Programming details:

1. When a rfid tag is read, the rfid number is controlled in the MF_Djur table (field Djur_RFID_ID).
1.1 If tag number exist in table MF_Djur:
1.1.1 Read the time for the latest time the tag was recorded in MF_Logg (A) and read the value of Djur_Intervall (minutes) from table MF_Djur (B).
1.1.1.1 If current time is within time interval A + B minutes: Read values from field Djur_Intervall_Foder1 and Djur_Intervall_Foder2 and activate the relay 1 for the time (seconds) specified in Djur_Intervall_Foder1 and activate the relay 2 for the time (seconds) specified in Djur_Intervall_Foder2.
1.1.1.2 If current time is not within time interval: Read values from field Djur_Foder1 and Djur_Foder2 and activate the relay 1 for the time (seconds) specified in Djur_Foder1 and activate the relay 2 for the time (seconds) specified in Djur_Foder2. Write tag number and current date and time to table MF_Logg. If internet connection exist: MySQL table need to synchronize with a MySQL database on another server on Internet.

2.1 If tag number does not exist in table MF_Djur:
2.1.1 In table MF_Djur save rfid number to Djur_RFID_ID, set Djur_Intervall to 180, set all four Foder-fields to 2.
2.1.2 Activate both relays for 2 seconds
2.1.3 Write tag number and current date and time to table MF_Logg.
2.1.4 If/when internet connection exist: Syncronize both tables with MySQL database on other server and send email to the specified emailaddress in table MF_Lantbruk with info that a new rfid tag has been saved to the database.


- When the Raspberry Pi starts up, this program must autostart.
- Programming must be well commented.


----------- Comments-----------

- Because this is a personal project that I will work on in my rare spare time, testing may take a little longer than usual so please accept that I need two-three weeks for testing after your coding has been finished.
- I can’t connect the rfid reader at the moment because I’m still waiting for the male db9/rs232 connector to arrive (it is said to arrive in beginning of next week)
- Because I don’t know Linux very well, please accept questions on what commands I have to run to get the script working.
- If you suggest that the coding can be made better in another language or with other hardware, please tell me in your bid description so I know before I choose a coder.
- I prefer fixed bids and will not rent a coder on hourly rates.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online