We need a simple C/C++ program that can read and write a text formatted ascii datastream from/to a serial communication port and a sql database.
The serial port can be either a physical port or a virtual serial port( for usb/serial converters)
The datastream is human readable in form of ascii characters.
The datastream contains a start and stop token.
The program shall read a text file at startup and this text file will tell the program the ip address of the (my)sql server, the username, database name and the table name to be used. There are two tables initially. One for read and one for write.
Incoming communication from the serial port shall be placed in the table at the end of the table.
The program shall monitor the outgoing table and if a new port is detected the data in this post shall be written to the serial port according to the prescribed format.
The program does not need to create the tables or manage the tables in any way. For incoming data the program assumes that the fields exist. For outgoing data, the program shall use the field list in the init-file ( same file that describe ip-address, username etc.)
The data flowing to/from the serial port shall always be of the format:
STARTDATA <field name1> <data1> <field name2> <data2> ...<field name n> <data n> ENDDATA