Author: wyoung
Date: Fri Mar 16 00:07:09 2007
New Revision: 1441
URL: http://svn.gna.org/viewcvs/mysqlpp?rev=1441&view=rev
Log:
Added tquery example. We have needed such a thing for a long time
(resetdb was the only one previously, and it's complicated) but it will
also help debug the 1-parameter bug that was recently reported.
Added:
trunk/examples/tquery.cpp
Modified:
trunk/ (props changed)
trunk/mysql++.bkl
Propchange: trunk/
------------------------------------------------------------------------------
--- svn:ignore (original)
+++ svn:ignore Fri Mar 16 00:07:09 2007
@@ -44,6 +44,7 @@
multiquery
resetdb
simple[0-9]
+tquery
updel
usequery
xaction
Added: trunk/examples/tquery.cpp
URL:
http://svn.gna.org/viewcvs/mysqlpp/trunk/examples/tquery.cpp?rev=1441&view=auto
==============================================================================
--- trunk/examples/tquery.cpp (added)
+++ trunk/examples/tquery.cpp Fri Mar 16 00:07:09 2007
@@ -1,0 +1,87 @@
+/***********************************************************************
+ tquery.cpp - Example similar to custom3.cpp, except that it uses
+ template queries instead of SSQLS.
+
+ Copyright (c) 1998 by Kevin Atkinson, (c) 1999, 2000 and 2001 by
+ MySQL AB, and (c) 2004-2007 by Educational Technology Resources, Inc.
+ Others may also hold copyrights on code in this file. See the CREDITS
+ file in the top directory of the distribution for details.
+
+ This file is part of MySQL++.
+
+ MySQL++ is free software; you can redistribute it and/or modify it
+ under the terms of the GNU Lesser General Public License as published
+ by the Free Software Foundation; either version 2.1 of the License, or
+ (at your option) any later version.
+
+ MySQL++ is distributed in the hope that it will be useful, but WITHOUT
+ ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
+ FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public
+ License for more details.
+
+ You should have received a copy of the GNU Lesser General Public
+ License along with MySQL++; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
+ USA
+***********************************************************************/
+
+#include "util.h"
+
+#include <iostream>
+
+using namespace std;
+
+int
+main(int argc, char *argv[])
+{
+ try {
+ // Establish the connection to the database server.
+ mysqlpp::Connection con(mysqlpp::use_exceptions);
+ if (!connect_to_db(argc, argv, con)) {
+ return 1;
+ }
+
+ // Build a template query to retrieve a stock item given by
+ // item name.
+ mysqlpp::Query query = con.query();
+ query << "select * from stock where item = %0q";
+ query.parse();
+
+ // Retrieve one item which will be there unless the examples
+ // aren't run in the order we hope they are.
+ mysqlpp::Result res1 = query.store("Nürnberger Brats");
+ if (res1.empty()) {
+ throw mysqlpp::BadQuery("UTF-8 bratwurst item not found
in "
+ "table, run resetdb");
+ }
+
+ // Replace the UTF-8 German name with a 7-bit ASCII aproximation
+ query.reset();
+ query << "update stock set item = %0q where item = %1q";
+ query.parse();
+ mysqlpp::ResNSel res2 = query.execute("Nuerenberger Bratwurst",
+ res1.at(0).at(0).c_str());
+
+ // Print the new table contents.
+ print_stock_table(query);
+ }
+ catch (const mysqlpp::BadQuery& er) {
+ // Handle any query errors
+ cerr << "Query error: " << er.what() << endl;
+ return -1;
+ }
+ catch (const mysqlpp::BadConversion& er) {
+ // Handle bad conversions
+ cerr << "Conversion error: " << er.what() << endl <<
+ "\tretrieved data size: " << er.retrieved <<
+ ", actual size: " << er.actual_size << endl;
+ return -1;
+ }
+ catch (const mysqlpp::Exception& er) {
+ // Catch-all for any other MySQL++ exceptions
+ cerr << "Error: " << er.what() << endl;
+ return -1;
+ }
+
+ return 0;
+}
Modified: trunk/mysql++.bkl
URL:
http://svn.gna.org/viewcvs/mysqlpp/trunk/mysql%2B%2B.bkl?rev=1441&r1=1440&r2=1441&view=diff
==============================================================================
--- trunk/mysql++.bkl (original)
+++ trunk/mysql++.bkl Fri Mar 16 00:07:09 2007
@@ -199,6 +199,9 @@
<exe id="multiquery" template="util-example,common-example">
<sources>examples/multiquery.cpp</sources>
</exe>
+ <exe id="tquery" template="util-example,common-example">
+ <sources>examples/tquery.cpp</sources>
+ </exe>
<exe id="usequery" template="util-example,common-example">
<sources>examples/usequery.cpp</sources>
</exe>
_______________________________________________
Mysqlpp-commits mailing list
[email protected]
https://mail.gna.org/listinfo/mysqlpp-commits
