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...
On a second thought, it seemed much cleaner to throw UnsupportedOperationException on remove(), just like for clear(), and this is allowed by the spec. So I...
Hello Franck, You have been busy. You even implemented EntrySet for the Map, which I was not suggesting but it is good. Should have a comment that it is...
Hi, ... I added a comment. ... You are right. Moreover, the Map interface allows this behaviour (optionnal). I wanted to stick to the interface for cases like...
Hello Franck, Thanks for polishing the SRecord get* methods. Probably negligible speed difference for most applications, but best not to ignore efficiency. ...
... One more thought, what happens if someone does a get("xxx") where xxx is not a field in an SRecord, or is a field but is not valid? Probably should throw...
Hello Anthony, one way to make entrySet(), containsKey(), etc. more efficient and clean would be to create an entrySet for each record instance, and add an ...