Author: tfischer
Date: Wed Mar 5 21:34:39 2014
New Revision: 1574676
URL: http://svn.apache.org/r1574676
Log:
add insert ... select ... docs
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/write-to-db.xml
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/write-to-db.xml
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/write-to-db.xml?rev=1574676&r1=1574675&r2=1574676&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/write-to-db.xml
(original)
+++
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/write-to-db.xml
Wed Mar 5 21:34:39 2014
@@ -27,7 +27,7 @@
</properties>
<body>
- <section name="Saving an object (inserts and updates)">
+ <section name="Saving an object (simple inserts and updates)">
<p>
To write an object into the database, call its save() method. Depending
@@ -213,6 +213,32 @@ BasePeer.doUpdate(criteria, columnValues
</section>
+ <section name="insert ... select ... statements">
+ <p>
+ The supported Databases allow to insert values which are previously
+ selected from the database, using an insert ... select ... statement.
+ These statements can be created using a special doInsert method
+ in the Peer classes: The first argument is an array of Column
+ objects which define the columns where the data is inserted
+ (all these columns must be in one table, though this is not checked
+ by Torque), and the second argument is a Criteria which
+ select the values to be inserted from the database (this criteria
+ must select the same number of columns as are in the first array,
+ although again this is not checked by Torque).
+ As an example (which makes no sense in a logical sense),
+ we can insert a number of authors into the author table,
+ setting the name of the inserted authors to the title of all books
+ in the database:
+ </p>
+
+<source>
+ int numberOfInsertedRows = AuthorPeer.doInsert(
+ new Column[] {AuthorPeer.NAME},
+ new Criteria().addSelectColumn(BookPeer.TITLE));
+</source>
+
+ </section>
+
<section name="Deleting objects">
<p>
If you want to delete an author which was already loaded into memory,
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
