#include <mysql++.h>
#include <string>
#include <iostream>
#include <iomanip>
#include <time.h>

using namespace std;

int
main()
{
	// Get database access parameters from command line
	const char* db = "mysql_cpp_data", *server = "localhost", *user = "root", *pass = "1234";
	// Connect to the sample database.
	mysqlpp::Connection conn(false);
	if (conn.connect(db, server, user, pass)) {
	  string temp = "test1";
	  string humi = "test2";
	  string amps = "test3";
	  time_t tsec = time();

	  string q = "INSERT INTO environmentstats (temperature, humidity, amperage, timestamp) VALUES (" + temp + ", " + humi + ", " + amps + ", " + tsec + ")";

	  mysqlpp::Query write_query = conn.query(q);
	  return 0;
	}
	else {
		cerr << "DB connection failed: " << conn.error() << endl;
		return 1;
	}
}