#include "mbed.h"
#include "EthernetNetIf.h"
#include "MySQLClient.h"

#define SQL_SERVER "192.168.1.57"
#define SQL_DB "heart_rate"
#define SQL_USER "hrm"
#define SQL_PASS "atanu"



EthernetNetIf ether
(
  IpAddr(192,168,1,26), //IP Address
  IpAddr(255,255,255,0), //Network Mask
  IpAddr(192,168,1,57), //Gateway
  IpAddr(192,168,1,57)  //DNS
);

IpAddr myIP;
MySQLClient mySQL;
MySQLResult sqlResult;


void onMySQLResult(MySQLResult r)
{
  sqlResult = r;
}

int main()
{
    EthernetErr error = ether.setup();
    if(error == 0)
    {
        printf("Ethernet Connection Setup Success\n");
    }
    else
    {
        printf("Error %s", error);
        return -1;
    }
    Host host(IpAddr(), 3306, SQL_SERVER);
    
    sqlResult=mySQL.open(host, SQL_USER, SQL_PASS, SQL_DB, onMySQLResult);
    while(sqlResult == MYSQL_PROCESSING)
    {
        Net::poll();//Don't Understand !!
        
    }
    if(sqlResult != MYSQL_OK)
    {
        printf("\nError %d in opening mysql connection\n", sqlResult);
    }

    //Make command
    char cmd[128] = {0};
    const char* msg="Hello World!";
    sprintf(cmd, "INSERT INTO test (test) VALUES('%s')", msg);
  
    //INSERT INTO DB
    string cmdStr = string(cmd); 
    sqlResult = mySQL.sql(cmdStr);
    while(sqlResult == MYSQL_PROCESSING)
    {
        Net::poll();
    }
    if(sqlResult != MYSQL_OK)
    {
        printf("\nError %d during SQL Command\n", sqlResult);
    }
    mySQL.exit();
    return 0;
}