DataNucleus

Revision: 5828
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=5828&view=rev
Author:   andy_jefferson
Date:     2009-03-29 16:32:35 +0000 (Sun, 29 Mar 2009)

Log Message:
-----------
recent additions

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-03-29 16:29:50 UTC (rev 5827)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-03-29 16:32:35 UTC (rev 5828)
@@ -150,7 +150,7 @@
                     <td>contains(value)</td>
                     <td>Returns whether the collection contains the passed element</td>
                     <td>JDO 1.0, JDO 2.0</td>
-                    <td><img src="../images/icon_error_sml.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
                 <tr>
                     <td>Collection</td>
@@ -171,7 +171,7 @@
                     <td>containsKey(key)</td>
                     <td>Returns whether the map contains the passed key</td>
                     <td>JDO 2.0</td>
-                    <td><img src="../images/icon_error_sml.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
                 <tr>
                     <td>Map</td>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 5830
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=5830&view=rev
Author:   andy_jefferson
Date:     2009-03-29 19:09:58 +0000 (Sun, 29 Mar 2009)

Log Message:
-----------
recent additions

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-03-29 19:09:29 UTC (rev 5829)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-03-29 19:09:58 UTC (rev 5830)
@@ -178,7 +178,7 @@
                     <td>containsValue(value)</td>
                     <td>Returns whether the map contains the passed value</td>
                     <td>JDO 2.0</td>
-                    <td><img src="../images/icon_error_sml.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
                 <tr>
                     <td>Map</td>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 5839
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=5839&view=rev
Author:   andy_jefferson
Date:     2009-03-30 13:33:42 +0000 (Mon, 30 Mar 2009)

Log Message:
-----------
[NUCRDBMS-162] Support for Map.containsEntry

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-03-30 13:32:48 UTC (rev 5838)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-03-30 13:33:42 UTC (rev 5839)
@@ -182,6 +182,13 @@
                 </tr>
                 <tr>
                     <td>Map</td>
+                    <td>containsEntry(key, value)</td>
+                    <td>Returns whether the map contains the passed entry</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
+                    <td>Map</td>
                     <td>get(key)</td>
                     <td>Returns the value from the map with the passed key</td>
                     <td>JDO 2.0</td>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 5855
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=5855&view=rev
Author:   andy_jefferson
Date:     2009-04-01 07:47:33 +0000 (Wed, 01 Apr 2009)

Log Message:
-----------
String.equals

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-04-01 07:27:28 UTC (rev 5854)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2009-04-01 07:47:33 UTC (rev 5855)
@@ -42,6 +42,13 @@
                 </tr>
                 <tr>
                     <td>String</td>
+                    <td>equals(String)</td>
+                    <td>Returns if the strings are equal</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
+                    <td>String</td>
                     <td>indexOf(String)</td>
                     <td>Returns the first position of the passed string</td>
                     <td>JDO 2.0</td>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 8467
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=8467&view=rev
Author:   andy_jefferson
Date:     2010-01-04 14:14:39 +0000 (Mon, 04 Jan 2010)

Log Message:
-----------
SQL boolean/numeric methods

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-04 13:26:27 UTC (rev 8466)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-04 14:14:39 UTC (rev 8467)
@@ -365,6 +365,20 @@
                     <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
                 <tr>
+                    <td>SQL</td>
+                    <td>boolean({sql})</td>
+                    <td>Embed the provided SQL and return a boolean result</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
+                    <td>SQL</td>
+                    <td>numeric({sql})</td>
+                    <td>Embed the provided SQL and return a numeric result</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
                     <td>{}</td>
                     <td>length</td>
                     <td>Returns the length of an array</td>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 8468
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=8468&view=rev
Author:   andy_jefferson
Date:     2010-01-04 14:16:32 +0000 (Mon, 04 Jan 2010)

Log Message:
-----------
List.get

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-04 14:14:39 UTC (rev 8467)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-04 14:16:32 UTC (rev 8468)
@@ -174,6 +174,13 @@
                     <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
                 <tr>
+                    <td>List</td>
+                    <td>get(index)</td>
+                    <td>Returns the element at that position</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
                     <td>Map</td>
                     <td>containsKey(key)</td>
                     <td>Returns whether the map contains the passed key</td>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 8527
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=8527&view=rev
Author:   andy_jefferson
Date:     2010-01-13 08:24:07 +0000 (Wed, 13 Jan 2010)

Log Message:
-----------
SQL_boolean method names etc

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-13 07:47:23 UTC (rev 8526)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-13 08:24:07 UTC (rev 8527)
@@ -356,36 +356,6 @@
                     <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
                 <tr>
-                    <td>SQL</td>
-                    <td>rollup({object})</td>
-                    <td>Perform a rollup operation over the results. 
-                        Only available for some datastores e.g DB2, MSSQL, Oracle</td>
-                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
-                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
-                </tr>
-                <tr>
-                    <td>SQL</td>
-                    <td>cube({object})</td>
-                    <td>Perform a cube operation over the results. 
-                        Only available for some datastores e.g DB2, MSSQL, Oracle</td>
-                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
-                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
-                </tr>
-                <tr>
-                    <td>SQL</td>
-                    <td>boolean({sql})</td>
-                    <td>Embed the provided SQL and return a boolean result</td>
-                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
-                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
-                </tr>
-                <tr>
-                    <td>SQL</td>
-                    <td>numeric({sql})</td>
-                    <td>Embed the provided SQL and return a numeric result</td>
-                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
-                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
-                </tr>
-                <tr>
                     <td>{}</td>
                     <td>length</td>
                     <td>Returns the length of an array</td>
@@ -415,6 +385,36 @@
                     <td><img src="../images/nucleus_extension.gif" border="0"/></td>
                     <td><img src="../images/icon_success_sml.gif" border="0"/></td>
                 </tr>
+                <tr>
+                    <td></td>
+                    <td>SQL_rollup({object})</td>
+                    <td>Perform a rollup operation over the results. 
+                        Only available for some datastores e.g DB2, MSSQL, Oracle</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
+                    <td></td>
+                    <td>SQL_cube({object})</td>
+                    <td>Perform a cube operation over the results. 
+                        Only available for some datastores e.g DB2, MSSQL, Oracle</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
+                    <td></td>
+                    <td>SQL_boolean({sql})</td>
+                    <td>Embed the provided SQL and return a boolean result</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
+                <tr>
+                    <td></td>
+                    <td>SQL_numeric({sql})</td>
+                    <td>Embed the provided SQL and return a numeric result</td>
+                    <td><img src="../images/nucleus_extension.gif" border="0"/></td>
+                    <td><img src="../images/icon_success_sml.gif" border="0"/></td>
+                </tr>
             </table>
             <p>
                 Here are a few examples using some of the extensions available for RDBMS with "JDOQL2".


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Revision: 8528
          http://datanucleus.svn.sourceforge.net/datanucleus/?rev=8528&view=rev
Author:   andy_jefferson
Date:     2010-01-13 08:43:17 +0000 (Wed, 13 Jan 2010)

Log Message:
-----------
better examples

Modified Paths:
--------------
    documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml

Modified: documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml
===================================================================
--- documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-13 08:24:07 UTC (rev 8527)
+++ documentation/accessplatform.datanucleus.org/trunk/docs/rdbms/jdoql2_methods.xml	2010-01-13 08:43:17 UTC (rev 8528)
@@ -471,7 +471,7 @@
                 <br/>
             </subsection>
 
-            <subsection name="Example 4 - SQL.rollup() method">
+            <subsection name="Example 4 - SQL_rollup() method">
                 <p>
                     Here's an example using the Product in a store and the rollup method. 
                     We want to find the max price of a product and all products at given end dates.
@@ -479,12 +479,27 @@
                 <source>
 Query query = pm.newQuery(org.datanucleus.samples.store.Product.class);
 query.setResult("name, endDate, max(price)");
-query.setGrouping("SQL.rollup({name,endDate})");
+query.setGrouping("SQL_rollup({name,endDate})");
 List results = (List)query.execute();
 </source>
                 <br/>
             </subsection>
 
+            <subsection name="Example 5 - SQL_boolean() method">
+                <p>
+                    Here's an example using the Product in a store and injecting some SQL.
+                    We want to find the max price of a product and there is some non-managed column
+                    that we want to apply a condition on (so we use SQL on that column).
+                </p>
+                <source>
+Query query = pm.newQuery(org.datanucleus.samples.store.Product.class);
+query.setResult("name, endDate, max(price)");
+query.setFilter("SQL_boolean(\"OTHER_COL = 5\")");
+List results = (List)query.execute();
+</source>
+                <br/>
+            </subsection>
+
         </section>
     </body>
 </document>
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.