You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by nt...@apache.org on 2018/07/24 08:09:43 UTC
cayenne git commit: Docs: fix SQLSelect example
Repository: cayenne
Updated Branches:
refs/heads/master 9b4f9e5ee -> 31f558618
Docs: fix SQLSelect example
Project: http://git-wip-us.apache.org/repos/asf/cayenne/repo
Commit: http://git-wip-us.apache.org/repos/asf/cayenne/commit/31f55861
Tree: http://git-wip-us.apache.org/repos/asf/cayenne/tree/31f55861
Diff: http://git-wip-us.apache.org/repos/asf/cayenne/diff/31f55861
Branch: refs/heads/master
Commit: 31f55861800de702b225840472c43d2fc805c51c
Parents: 9b4f9e5
Author: Nikita Timofeev <st...@gmail.com>
Authored: Tue Jul 24 11:09:35 2018 +0300
Committer: Nikita Timofeev <st...@gmail.com>
Committed: Tue Jul 24 11:09:35 2018 +0300
----------------------------------------------------------------------
.../src/docs/asciidoc/_cayenne-guide/part2/queries.adoc | 9 ++++++++-
1 file changed, 8 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cayenne/blob/31f55861/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries.adoc
----------------------------------------------------------------------
diff --git a/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries.adoc b/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries.adoc
index 0351940..d047dbb 100644
--- a/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries.adoc
+++ b/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries.adoc
@@ -303,13 +303,20 @@ Here is example of how to use SQLSelect:
[source, java]
----
-SQLSelect<Painting> q1 = SQLSelect
+// Selecting objects
+List<Painting> paintings = SQLSelect
.query(Painting.class, "SELECT * FROM PAINTING WHERE PAINTING_TITLE LIKE #bind($title)")
.params("title", "painting%")
.upperColumnNames()
.localCache()
.limit(100)
.select(context);
+
+// Selecting scalar values
+List<String> paintingNames = SQLSelect
+ .scalarQuery(String.class, "SELECT PAINTING_TITLE FROM PAINTING ESTIMATED_PRICE > #bind($price)")
+ .params("price", 100000)
+ .select(context);
----