#include <iostream> #include <vector> #include <sqlplus.hh> #include <custom.hh>

sql_create_5 (stock, 1, 5, string, item, int, num, double, weight, double, price, Date, sdate)

int main() { try { // its in one big try block

Connection con(use_exceptions); con.connect("mysql_cpp_data","localhost","root"); Query query = con.query();

stock row;

row.set("Cachorro Hot Dogs",100,1.5,1.75,"1998-09-25"); // populate stock

query.insert(row); // form the query to insert the row // the table name is the name of the struct by default

cout << "Query : " << query.preview() << endl; // show the query about to be executed

query.execute(); // execute a query that does not return a result set

return 0;

} catch (BadQuery er){ // handle any connection // or query errors that may come up cerr << "Error_1: " << er.error << endl; return -1;

} catch (BadConversion er) { cerr << "Error_2: Tried to convert \"" << er.data << "\" to a \"" << er.type_name << "\"." << endl; return -1; } }