Compile with cppconn and mysqlclient

1. cpp 

#include "Model/Util.h"
#include <functional>
#include <string_view>
#include <experimental/source_location>
#include <cppconn/driver.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>
#include <cppconn/exception.h>
#include <cppconn/prepared_statement.h>
#include <mysql/mysql.h>

void mysqlClient74();

int main(int args, char **argv)
{
    batchInsert(atoi(argv[1]));
}

void batchInsert(int loops)
{
    try
    {
        sql::Driver *driver;
        sql::Connection *conn;
        sql::PreparedStatement *prepStmt;
        driver = get_driver_instance();

        conn = driver->connect("tcp://127.0.0.1:3306", "root", "Root0001!");
        conn->setSchema("myDB");

        stringstream ss;
        int repeatedTimes = 1000000;
        int64_t num = 0;
        Util ul;

        for (int i = 0; i < loops; i++)
        {
            ss = stringstream();
            conn = driver->connect("tcp://127.0.0.1:3306", "root", "Root0001!");
            conn->setSchema("myDB");
            ss << "insert into mt(BookId,BookName,BookTitle) values ";
            for (int j = 0; j < repeatedTimes; j++)
            {
                ss << "(" << ++num << ",'" << getUuid() << "','" << getUuid() << "')," << endl;
            }

            string str = ss.str();
            int lastIndex = str.find_last_of(",");
            str = str.erase(lastIndex);
            prepStmt = conn->prepareStatement(str);
            prepStmt->execute();
            cout << ul.getTimeNow() << ",Loop=" << i + 1 << " finished!" << endl;
            conn->close();
            prepStmt->close();
        }

        delete prepStmt;
        delete conn;
    }
    catch (sql::SQLException &e)
    {
        cout << "# ERR: SQLException in " << __FILE__;
        cout << "(" << __FUNCTION__ << ") on line " << __LINE__ << endl;
        cout << "# ERR: " << e.what();
        cout << " (MySQL error code: " << e.getErrorCode();
        cout << ", SQLState: " << e.getSQLState() << " )" << endl;
        return;
    }
    cout << "Finished in void batchInsert(int loops)!" << endl;
}

 

 

2.Compile:

g++ -g -std=c++2a -I. -Wall -I/usr/include/cppconn -I/usr/include/mysql/ *.cpp ./Model/*.cpp -o h1 -luuid -lpthread -L/usr/lib -lmysqlcppconn -lmysqlclient

 

3.Execute

./h1 10