You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by aa...@apache.org on 2019/11/02 09:31:51 UTC
[cayenne] branch STABLE-4.1 updated: minor edits
This is an automated email from the ASF dual-hosted git repository.
aadamchik pushed a commit to branch STABLE-4.1
in repository https://gitbox.apache.org/repos/asf/cayenne.git
The following commit(s) were added to refs/heads/STABLE-4.1 by this push:
new ed5c272 minor edits
ed5c272 is described below
commit ed5c27267804f725b77ada071aa0255c0511c994
Author: Andrus Adamchik <an...@objectstyle.com>
AuthorDate: Sat Nov 2 12:31:45 2019 +0300
minor edits
---
.../src/docs/asciidoc/_cayenne-guide/part2/queries/sql.adoc | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries/sql.adoc b/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries/sql.adoc
index 58429ce..7184aa0 100644
--- a/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries/sql.adoc
+++ b/docs/asciidoc/cayenne-guide/src/docs/asciidoc/_cayenne-guide/part2/queries/sql.adoc
@@ -16,8 +16,8 @@
SQL is very powerful and allows to manipulate data in ways that can not always be described as a graph of related entities.
Cayenne acknowledges this fact and provides a facility to execute SQL, sometimes allowing to map results back to
persistent objects. `SQLSelect` and `SQLExec` are a pair of queries that allow to run native SQL. `SQLSelect` can be
-used (as name suggests) to select custom data in form of entities, separate columns, collection of `DataRow` or Object[].
-`SQLExec` is designed to execute any raw SQL code (e.g. updates, deletes, DDLs, etc.).
+used (as the name suggests) to select custom data in form of entities, separate columns, collection of `DataRow` or
+`Object[]`. `SQLExec` is designed to execute any SQL (e.g. updates, deletes, DDLs, etc.).
Both queries support advanced SQL templating, with variable substitution and special directives as described
<<sqlscripting,in the next chapter>>. Here we'll just provide a few simple examples:
@@ -39,12 +39,12 @@ List<String> paintingNames = SQLSelect
// Selecting DataRow with predefined types
List<DataRow> result = SQLSelect
- .dataRowQuery("SELECT * FROM ARTIST", Integer.class, String.class, LocalDateTime.class)
+ .dataRowQuery("SELECT * FROM ARTIST", Integer.class, String.class, LocalDate.class)
.select(context);
// Selecting Object[] with predefined types
List<Object[]> result = SQLSelect
- .scalarQuery("SELECT * FROM ARTIST", Integer.class, String.class, LocalDateTime.class)
+ .scalarQuery("SELECT * FROM ARTIST", Integer.class, String.class, LocalDate.class)
.select(context);
----