cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <>
Subject Re: SQLExec query
Date Wed, 28 Jan 2015 01:13:37 GMT
On 27/01/2015 10:45pm, Andrus Adamchik wrote:
> List<Object> is a confusing data structure. When iterating through it you will
need to do instanceof/cast on every entry, and more importantly, you will need to know upfront
what are the valid entries in there. 
> With List<QueryResult> you don't do instanceof/cast, and also if say tomorrow we
add/change something in the entry format/type, we simply alter QueryResult API, making the
change visible to the user. 

OK, so let's examine your example:

List<QueryResult> result = SQLExec
     .query("INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (#bind($id), #bind($name))")
     .paramsArray(55, "a3")

Let's say I want to get the number of rows added. I do this:

count = result.get(0).getBatchUpdateResult()[0]; or
count = result.get(0).getUpdateResult();

except that I didn't run an "UPDATE", I ran an "INSERT". But perhaps that can be solved with
enough javadocs to explain the naming...

Now, for a result set:

List<QueryResult> result = SQLExec.query("CALL getContacts_proc()").execute(context);

List<Contact> contact = (List<Contact>) result.get(0).getSelectResult();

Am I missing the point here?


Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

View raw message