#include <iostream>
#include <string>
#include <sstream>
#include <time.h>
#include <strings.h>
#include <string.h>

#include "sqlite3.h"

const int nCount = 500000;

int main ( int argc, char** argv )
{
 sqlite3* db;
 sqlite3_open ( "testdb.db", &db );
 sqlite3_exec ( db, "PRAGMA synchronous = OFF; ", 0, 0, 0 );
 sqlite3_exec ( db, "drop table if exists t1", 0, 0, 0 );
 sqlite3_exec ( db, "create table t1(id integer,x integer,y integer ,weight real)", 0, 0, 0 );
 clock_t t1 = clock();

 sqlite3_exec ( db, "begin;", 0, 0, 0 );
 sqlite3_stmt* stmt;
 const char* sql = "insert into t1 values(?,?,?,?)";
 sqlite3_prepare_v2 ( db, sql, strlen ( sql ), &stmt, 0 );

 for ( int i = 0; i < nCount; ++i )
 {
 // std::stringstream ssm;
 // ssm<<"insert into t1 values("<<i<<","<<i*2<<","<<i/2<<","<<i*i<<")";
 // sqlite3_exec(db,ssm.str().c_str(),0,0,0);
 sqlite3_reset ( stmt );
 sqlite3_bind_int ( stmt, 1, i );
 sqlite3_bind_int ( stmt, 2, i * 2 );
 sqlite3_bind_int ( stmt, 3, i / 2 );
 sqlite3_bind_double ( stmt, 4, i * i );
 sqlite3_step ( stmt );
 }

 sqlite3_finalize ( stmt );
 sqlite3_exec ( db, "commit;", 0, 0, 0 );
 clock_t t2 = clock();

 sqlite3_close ( db );

 std::cout << 1000.0 / ( ( t2 - t1 ) / 1000.0 ) *nCount << " rec/s" << std::endl;

 return 0;
}