Author: wyoung
Date: Thu Nov 8 00:46:56 2007
New Revision: 1827
URL: http://svn.gna.org/viewcvs/mysqlpp?rev=1827&view=rev
Log:
Removed 'endl's in multiquery example between each statement. It was
causing people to believe they were necessary, but we only had them in
there for pretty preview() output.
Modified:
trunk/bmark.txt
trunk/examples/multiquery.cpp
Modified: trunk/bmark.txt
URL:
http://svn.gna.org/viewcvs/mysqlpp/trunk/bmark.txt?rev=1827&r1=1826&r2=1827&view=diff
==============================================================================
--- trunk/bmark.txt (original)
+++ trunk/bmark.txt Thu Nov 8 00:46:56 2007
@@ -50,13 +50,7 @@
---------------- BEGIN multiquery OUTPUT ----------------
Multi-query:
-DROP TABLE IF EXISTS test_table;
-CREATE TABLE test_table(id INT);
-INSERT INTO test_table VALUES(10);
-UPDATE test_table SET id=20 WHERE id=10;
-SELECT * FROM test_table;
-DROP TABLE test_table
-
+DROP TABLE IF EXISTS test_table; CREATE TABLE test_table(id INT); INSERT INTO
test_table VALUES(10); UPDATE test_table SET id=20 WHERE id=10; SELECT * FROM
test_table; DROP TABLE test_table
Result set 0 is empty.
Result set 1 is empty.
Result set 2 is empty.
@@ -69,14 +63,7 @@
+----+
Result set 5 is empty.
Stored procedure query:
-DROP PROCEDURE IF EXISTS get_stock;
-CREATE PROCEDURE get_stock
-( i_item varchar(20) )
-BEGIN
-SET i_item = concat('%', i_item, '%');
-SELECT * FROM stock WHERE lower(item) like lower(i_item);
-END
-;
+DROP PROCEDURE IF EXISTS get_stock; CREATE PROCEDURE get_stock( i_item
varchar(20) ) BEGIN SET i_item = concat('%', i_item, '%'); SELECT * FROM stock
WHERE lower(item) like lower(i_item); END;
Result set 0 is empty.
Result set 1 is empty.
Query: CALL get_stock('relish')
Modified: trunk/examples/multiquery.cpp
URL:
http://svn.gna.org/viewcvs/mysqlpp/trunk/examples/multiquery.cpp?rev=1827&r1=1826&r2=1827&view=diff
==============================================================================
--- trunk/examples/multiquery.cpp (original)
+++ trunk/examples/multiquery.cpp Thu Nov 8 00:46:56 2007
@@ -163,12 +163,12 @@
// Set up query with multiple queries.
Query query = con.query();
- query << "DROP TABLE IF EXISTS test_table;" << endl <<
- "CREATE TABLE test_table(id INT);" << endl <<
- "INSERT INTO test_table VALUES(10);" << endl <<
- "UPDATE test_table SET id=20 WHERE id=10;" <<
endl <<
- "SELECT * FROM test_table;" << endl <<
- "DROP TABLE test_table" << endl;
+ query << "DROP TABLE IF EXISTS test_table; " <<
+ "CREATE TABLE test_table(id INT); " <<
+ "INSERT INTO test_table VALUES(10); " <<
+ "UPDATE test_table SET id=20 WHERE id=10; " <<
+ "SELECT * FROM test_table; " <<
+ "DROP TABLE test_table";
cout << "Multi-query: " << endl << query.preview() << endl;
// Execute statement and display all result sets.
@@ -177,14 +177,13 @@
#if MYSQL_VERSION_ID >= 50000
// If it's MySQL v5.0 or higher, also test stored procedures,
which
// return their results the same way multi-queries do.
- query << "DROP PROCEDURE IF EXISTS get_stock;" << endl <<
- "CREATE PROCEDURE get_stock" << endl <<
- "( i_item varchar(20) )" << endl <<
- "BEGIN" << endl <<
- "SET i_item = concat('%', i_item, '%');" <<
endl <<
- "SELECT * FROM stock WHERE lower(item) like
lower(i_item);" <<
- endl << "END" << endl <<
- ";";
+ query << "DROP PROCEDURE IF EXISTS get_stock; " <<
+ "CREATE PROCEDURE get_stock" <<
+ "( i_item varchar(20) ) " <<
+ "BEGIN " <<
+ "SET i_item = concat('%', i_item, '%'); " <<
+ "SELECT * FROM stock WHERE lower(item) like
lower(i_item); " <<
+ "END;";
cout << "Stored procedure query: " << endl << query.preview()
<< endl;
// Create the stored procedure.
_______________________________________________
Mysqlpp-commits mailing list
[email protected]
https://mail.gna.org/listinfo/mysqlpp-commits
