|
From: Pelle B. <pe...@us...> - 2004-03-25 16:55:58
|
Update of /cvsroot/neuclear/neuclear-ledger-hibernate/src/java/org/neuclear/ledger/hibernate In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8651/src/java/org/neuclear/ledger/hibernate Modified Files: HHeld.hbm.xml HTransaction.hbm.xml HibernateLedger.java Log Message: Added getTestBalance() and isBalanced() to Ledger to see if ledger is balanced. The hibernate implementation has changed the comment size to 255 to work with mysql and now has included hibernates full hibernate.properties to make it easier to try various databases. It has now been tested with hsql and mysql. Index: HTransaction.hbm.xml =================================================================== RCS file: /cvsroot/neuclear/neuclear-ledger-hibernate/src/java/org/neuclear/ledger/hibernate/HTransaction.hbm.xml,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** HTransaction.hbm.xml 24 Mar 2004 12:33:10 -0000 1.2 --- HTransaction.hbm.xml 25 Mar 2004 16:45:08 -0000 1.3 *************** *** 23,27 **** </property> <property name="comment" type="string"> ! <column name="comment" sql-type="varchar(256)" not-null="true"/> </property> --- 23,27 ---- </property> <property name="comment" type="string"> ! <column name="comment" sql-type="varchar(255)" not-null="true"/> </property> Index: HHeld.hbm.xml =================================================================== RCS file: /cvsroot/neuclear/neuclear-ledger-hibernate/src/java/org/neuclear/ledger/hibernate/HHeld.hbm.xml,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** HHeld.hbm.xml 24 Mar 2004 23:13:21 -0000 1.2 --- HHeld.hbm.xml 25 Mar 2004 16:45:08 -0000 1.3 *************** *** 27,31 **** </property> <property name="comment"> ! <column name="comment" sql-type="varchar(256)" not-null="true"/> </property> --- 27,31 ---- </property> <property name="comment"> ! <column name="comment" sql-type="varchar(255)" not-null="true"/> </property> Index: HibernateLedger.java =================================================================== RCS file: /cvsroot/neuclear/neuclear-ledger-hibernate/src/java/org/neuclear/ledger/hibernate/HibernateLedger.java,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** HibernateLedger.java 24 Mar 2004 23:13:21 -0000 1.5 --- HibernateLedger.java 25 Mar 2004 16:45:08 -0000 1.6 *************** *** 328,331 **** --- 328,352 ---- } + public double getTestBalance() throws LowlevelLedgerException { + try { + Session ses = factory.openSession(); + Query q = ses.createQuery("select sum(item.amount) from HTransactionItem item"); + Iterator iter = q.iterate(); + if (iter.hasNext()) { + final Object o = iter.next(); + if (o != null) { + ses.close(); + return ((Double) o).doubleValue(); + } + // throw new LowlevelLedgerException(this,"Query returned more or less than one column"); + } + // throw new LowlevelLedgerException(this,"Query didnt return a row"); + ses.close(); + return 1; //if we have to return something here there has been an error and we better flag it. + } catch (HibernateException e) { + throw new LowlevelLedgerException(e); + } + } + public void close() throws LowlevelLedgerException { try { |