[Neuclear-develop] neuclear-ledger-hibernate/src/java/org/neuclear/ledger/hibernate HHeld.hbm.xml,1.2,1.3 HTransaction.hbm.xml,1.2,1.3 HibernateLedger.java,1.5,1.6

[Pelle B. <pe...@us...>]

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 {