How to insert into table in database after every 5 minutes using Real time clock module

Question

I have RTC module attached to arduino mega,

to calculate time difference of minutes I am getting minute from the RTC module

and checking if passed time is greater than 5 minutes then insert to MySQL table in database.

  int mint = util::getMinute();

  if (util::getMinute() - mint >= 5)

  {
    // inserting to sql database on mysql server
    INSERT_SQL = "";
    INSERT_SQL.concat("INSERT INTO arduinoSensorData.outTempLog (out_temperature) VALUES ('");
    INSERT_SQL.concat(tempInC);
    INSERT_SQL.concat("');");

    const char *mycharp = INSERT_SQL.c_str();
    delay(1000);

    if (!connected) {
      my_conn.mysql_connect(server_addr, 3306, user, password);
      connected = true;
    }
    else if (connected == true)
    {
      delay(500);
      Serial.print("Inserting : ");
      Serial.println(INSERT_SQL);
      Serial.println("Connection Successfull,inserting to database.");
      my_conn.cmd_query(mycharp);

    }
    else {
      Serial.println("Connection failed.");
    }
    mint = util::getMinute();
  }

the full code is here

Move int mint = util::getMinute(); outside the loop function. Otherwise util::getMinute() - mint will always be 0. — Gerben
– Gerben, Commented Dec 22, 2016 at 19:43
Just a tip, you didn't specify what RTC you're using, but most RTCs have an internal alarm functionality that will trigger an alert when a specific time of day is reached. This allows you to eliminate the polling from your code, and even sleep in between the 5 mins, which can greatly improve your power consumption. — uint128_t
– uint128_t, Commented Dec 29, 2016 at 17:57

Majenko · Accepted Answer · 2016-12-22 19:45:12Z

0

int mint = util::getMinute();

if (util::getMinute() - mint >= 5)

{

Well, if mint is util::getMinute() then surely util::getMinute() - mint will always be 0.

I think you meant mint to be static, or a variable in the global scope.

answered Dec 22, 2016 at 19:45

Majenko

106k5 gold badges82 silver badges139 bronze badges

done that but I don't see database getting inserted even after making the change

Ciasto piekarz
– Ciasto piekarz

2016-12-23 02:13:29 +00:00
Commented Dec 23, 2016 at 2:13

Add a comment |

Ciasto piekarz · Accepted Answer · 2016-12-30 17:18:52Z

So I figured it out myself and used millis instead.

in global declaration I did:

unsigned long sqlInsertInterval = 300000; // the repeat interval after 5 minutes

then initiate timer in setup method

  timer = millis(); // start timer

followed by below changes in the loop method.

void loop() {
  // perform sql insert after 5 minutes
  if ((millis() - timer) > sqlInsertInterval) {
    // timed out
    timer += sqlInsertInterval;// reset timer by moving it along to the next interval

    // inserting to sql database on mysql server
    INSERT_SQL = "";
    INSERT_SQL.concat("INSERT INTO arduinoSensorData.outTempLog (out_temperature) VALUES ('");
    INSERT_SQL.concat(tempInC);
    INSERT_SQL.concat("');");

    const char *mycharp = INSERT_SQL.c_str();
    if (!connected) {
      my_conn.mysql_connect(server_addr, 3306, user, password);
      connected = true;
    }
    else if (connected == true)
    {
      Serial.print("Inserting : ");
      Serial.println(INSERT_SQL);
      Serial.println("Connection Successfull,inserting to database.");
      my_conn.cmd_query(mycharp);

    }
    else {
      Serial.println("Connection failed.");
    }
  }
}

Stack Exchange Network

How to insert into table in database after every 5 minutes using Real time clock module

2 Answers 2

Your Answer

Hot Network Questions

How to insert into table in database after every 5 minutes using Real time clock module

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions