Hello Franck, SQueryAggregate is an interesting concept which raises many questions. It is really a special case of doing general ad hoc queries and should...
Hello Anthony, ... I've done this. SRecordAdHoc feels a bit strange to me, as SRecordInstance is not really an adhoc object... but I don't have any really...
Hello Franck, So, you are worse than me, coding on Easter Sunday... Looks good to me. There is still an awkward overlap between SQuery, SQueryAggregate and...
Hello Franck, So any reaction to my notes below? I think that specifically SQueryAggregate and friends should be renamed into something like SQueryGeneric....
Hello Anthony, I've not be changing anything recently, except adding a rawInnerJoin method to SQuery, that truly adds an arbitrary table to a query (a table ...
Hello Franck, I see your point about SQueryGeneric. How about SQuerySelect, because it lets you explicitly specify a select list? I realize that you are busy...
Hello Franck, I would like to package up the current subversion state fairly soon and make it the next build. There are a few tweak I would add. Could you...
Hello, I have a few other commits waiting here that I would like to go in the build. Mainly, it allows to do: aggQuery.sum("some arbitrary sql here") (or...
Sounds good. I'll have some time over the next few weeks. Anthony ... Spreadsheet Detective, Southern Cross Software Queensland Pty Limited 54 Gerler Street ...
berglas@...
May 24, 2009 7:56 am
1768
I have been using SimpleORM for the last two months and its a great tool. I have a question about record caching If one has static information in the database...
... You can make this action as first one after starting your program. So no other items in the database can be affected, because your program hasn't any open...
Hello Gary You could also just reattach the data set to a session (ses.begin(ds)) updated it, then detachAndCommit again. See...
berglas@...
Jun 8, 2009 12:14 am
1771
Hello, You can also use SSessionJDBC.detachUnflushedDataSet() instead of SSessionJDBC.commitAndDetachDataSet(); If you only query record without flushing, it...
damien hostin
damien.hostin@...
Jun 8, 2009 8:31 am
1772
Hi, just to add my two (euro) cents, I think you could use a different dataSet to handle your configuration information. SDataSet configDs = new SDataSet(); ...
Thanks for the response. I looked thru LongTransactionTest. From what I see, it looks like the code assumes it can set the dataset for a session. I dont...
Normally you start your sessions at the top level where a request comes in. But you can call session.hasBegun() to find out. Anthony ... Spreadsheet Detective,...
berglas@...
Jun 24, 2009 8:35 am
1775
Hello Garry, I am confused by your use case. If you just want to have a record set of cached values that is not really part of the transaction, then just don't...
How do you feel about having a findReferencing method in SRecordInstance, just like the existing findReference there? That'd make it just as easy to lazily...
A good question, and the answer is no. Suppose one performed a query to select Employees in Sales where Salary > 100000 order by Name What would you expect...
berglas@...
Jul 7, 2009 12:45 am
1778
OK. Should we then widen the SSessionI interface? It's nice to be able to write fully testable code that doesn't depend on the concrete SSessionJdbc. But you...
I haven't bothered putting abstract classes on things like SSessionJdbc because I'm not sure that it is useful. Mocking out the database essentially mocks out...
berglas@...
Jul 7, 2009 6:08 am
1780
Hello to you all. Just wanted to find out whether it is possible to work with more than one data source with simple-orm and if so hwo it can be done....
Yes, easy. It is just an initial parameter when opening a connection. Can swap connections too, see LongTransactionTest. Anthony ... Spreadsheet Detective, ...
berglas@...
Jul 25, 2009 4:22 am
1782
Hi Anthony, it's been a long time since I said I would rename SAggregateQuery to SQuerySelect, as soon as... well. I'm ready now :) I just come back to make...
Hello Franck, Good to hear that you are back on this. Producing a new release is way over due. I have also been busy. The reasoning is that aggregates is...
Hi, there is a point I don't get... there are big differences between SRecordGeneric and SRecordInstance, that make me think it would be hard to unify them: ...
Hello Franck, Yes, I was thinking along similar lines after I posted. The primary key is the big issue. (And having multiple queries with different select...
berglas@...
Jul 30, 2009 10:58 am
1786
Hello, so, I would go: SRecordGeneric as the base abstract class SRecordInstance... SRecordTransient for what is called SRecordGeneric now... I would also...
Hello Franck, Sounds good. I would like the copied code pushed up into SRecordGeneric as private methods. Pushing getString(String) up as abstracts should also...
Hello Anthony, I finally commited my changes right now. So, I created a new SRecordGeneric, an abstract class that implements Map and has all the code related...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
