deleted: ruralHouses/hs_err_pid6014.log

[RRRRHHHH_Code] / ruralHouses / src / dataAccess / DB4oManager.java

diff --git a/ruralHouses/src/dataAccess/DB4oManager.java b/ruralHouses/src/dataAccess/DB4oManager.java
index 15b2ad4..40fe83c 100644 (file)
--- a/ruralHouses/src/dataAccess/DB4oManager.java
+++ b/ruralHouses/src/dataAccess/DB4oManager.java
@@ -110,12 +110,12 @@ public class DB4oManager {
                try {
                        Owner jon = new Owner("Jon");
                        Owner alfredo = new Owner("Alfredo");
-                       jon.addRuralHouse(1, "Ezkioko etxea", "Ezkio", 3, 3, 3, 3, 3);
-                       jon.addRuralHouse(2, "Eskiatzeko etxea", "Jaca", 4, 4, 4, 4, 4);
+                       jon.addRuralHouse("Ezkio", "Ezkioko etxea", "Ezkio", 3, 3, 3, 3, 3);
+                       jon.addRuralHouse("Eskia", "Eskiatzeko etxea", "Jaca", 4, 4, 4, 4, 4);
                        jon.setBankAccount("1349 5677 21 2133567777");
-                       alfredo.addRuralHouse(3, "Casa del abuelo", "Pitillas", 5, 5, 5, 5,
+                       alfredo.addRuralHouse("Aitonako", "Casa del abuelo", "Pitillas", 5, 5, 5, 5,
                                        5);
-                       alfredo.addRuralHouse(4, "", "Murgia", 6, 6, 6, 6, 6);
+                       alfredo.addRuralHouse("Murgoitz", "", "Murgia", 6, 6, 6, 6, 6);
                        alfredo.setBankAccount("4144 0087 23 9700002133");
                        Account jonAcc = new Account("userJon", "passJon", jon);
                        Account alfredoAcc = new Account("userAlfredo", "passAlfredo",
@@ -130,21 +130,42 @@ public class DB4oManager {
                }
        }
 
+       public void deleteDB() {
+
+               if (c.isDatabaseLocal() == false)
+                       openSDB();
+               else
+                       openDB();
+
+               try {
+                       Owner proto = new Owner(null, null);
+                       ObjectSet result = db.queryByExample(proto);
+                       Vector<Owner> owners = new Vector<Owner>();
+                       while (result.hasNext()) {
+                               Owner o = (Owner) result.next();
+                               System.out.println("Deleted owner: " + o.toString());
+                               db.delete(o);
+                       }
+                       db.commit();
+               } finally {
+                       db.close();
+               }
+       }
+       
+       
        @SuppressWarnings("finally")
        public Offer createOffer(RuralHouse ruralHouse, Date firstDay,
                        Date lastDay, float price) throws RemoteException, Exception {
                Offer o = null;
-               
+
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
                        openDB();
-               
-               try {
 
-                       
+               try {
 
-                       RuralHouse proto = new RuralHouse(ruralHouse.getHouseNumber(),
+                       RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(),
                                        null, null, null, null);
                        ObjectSet result = db.queryByExample(proto);
                        RuralHouse rh = (RuralHouse) result.next();
@@ -159,31 +180,54 @@ public class DB4oManager {
                        System.out
                                        .println("Error: com.db4o.ext.ObjectNotStorableException in createOffer");
                } finally {
-                       return o;
+                       db.close();
                }
+               return o;
        }
 
-       public void deleteDB() {
+       @SuppressWarnings("finally")
+       public Offer modifyOffer(Offer offer) throws RemoteException, Exception {
+               if (c.isDatabaseLocal() == false)
+                       openSDB();
+               else
+                       openDB();
+
+               try {
 
+                       
+                       db.store(offer);
+                       db.commit();
+
+               } catch (com.db4o.ext.ObjectNotStorableException e) {
+                       System.out
+                                       .println("Error: com.db4o.ext.ObjectNotStorableException in createOffer");
+               } finally {
+                       db.close();
+               }
+               return offer;
+       }
+       
+       @SuppressWarnings("finally")
+       public void deleteOffer(RuralHouse rh, Offer offer) throws RemoteException, Exception {
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
                        openDB();
-               
+
                try {
-                       Owner proto = new Owner(null, null);
-                       ObjectSet result = db.queryByExample(proto);
-                       Vector<Owner> owners = new Vector<Owner>();
-                       while (result.hasNext()) {
-                               Owner o = (Owner) result.next();
-                               System.out.println("Deleted owner: " + o.toString());
-                               db.delete(o);
-                       }
+
+                       db.store(rh);
+                       db.delete(offer);
                        db.commit();
+
+               } catch (com.db4o.ext.ObjectNotStorableException e) {
+                       System.out
+                                       .println("Error: com.db4o.ext.ObjectNotStorableException in createOffer");
                } finally {
                        db.close();
                }
        }
+       
 
        /**
         * This method creates a book with a corresponding parameters
@@ -195,20 +239,20 @@ public class DB4oManager {
        public Booking createBooking(RuralHouse ruralHouse, Date firstDate,
                        Date lastDate, String bookTelephoneNumber)
                        throws OfferCanNotBeBooked {
-               
+
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
                        openDB();
-               
+
                Booking bok = null;
-               
+
                try {
 
                        if (c.isDatabaseLocal() == false)
                                openSDB();
 
-                       RuralHouse proto = new RuralHouse(ruralHouse.getHouseNumber(),
+                       RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(),
                                        null, ruralHouse.getDescription(), ruralHouse.getTown(),
                                        null);
                        ObjectSet result = db.queryByExample(proto);
@@ -232,8 +276,9 @@ public class DB4oManager {
                                        .println("Error: com.db4o.ext.ObjectNotStorableException in createBooking");
                } catch (Exception exc) {
                        exc.printStackTrace();
+               } finally {
+                       db.close();
                }
-               
                return bok;
        }
 
@@ -262,14 +307,14 @@ public class DB4oManager {
 
        public Vector<RuralHouse> getAllRuralHouses() throws RemoteException,
                        Exception {
-               
+
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
                        openDB();
 
                try {
-                       RuralHouse proto = new RuralHouse(0, null, null, null, null);
+                       RuralHouse proto = new RuralHouse(null, null, null, null, null);
                        ObjectSet result = db.queryByExample(proto);
                        Vector<RuralHouse> ruralHouses = new Vector<RuralHouse>();
                        while (result.hasNext())
@@ -282,18 +327,17 @@ public class DB4oManager {
 
        public boolean existsOverlappingOffer(RuralHouse rh, Date firstDay,
                        Date lastDay) throws RemoteException, OverlappingOfferExists {
-               
+
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
                        openDB();
-               
+
                try {
-                       
 
                        RuralHouse rhn = (RuralHouse) db
                                        .queryByExample(
-                                                       new RuralHouse(rh.getHouseNumber(), null, null,
+                                                       new RuralHouse(rh.getHouseName(), null, null,
                                                                        null, null)).next();
                        if (rhn.overlapsWith(firstDay, lastDay) != null)
                                throw new OverlappingOfferExists();
@@ -326,12 +370,12 @@ public class DB4oManager {
         */
        public Vector<Account> getAccount(String usr, String pwd)
                        throws RemoteException, Exception {
-               
+
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
                        openDB();
-               
+
                try {
                        Account proto = new Account(usr, pwd, new Owner(null, null));
                        ObjectSet<Account> result = db.queryByExample(proto);
@@ -353,9 +397,9 @@ public class DB4oManager {
                        openSDB();
                else
                        openDB();
-               
+
                boolean stored = false;
-               RuralHouse house = new RuralHouse(rh.getHouseNumber(), null, null,
+               RuralHouse house = new RuralHouse(rh.getHouseName(), null, null,
                                null, null);
                try {
                        ObjectSet<Owner> result = db.queryByExample(house);
@@ -370,18 +414,19 @@ public class DB4oManager {
                return stored;
        }
 
-       public void removeHouse(int houseNumber) {
+
+       public void removeHouse(RuralHouse rh, Owner owner) {
 
                if (c.isDatabaseLocal() == false)
                        openSDB();
                else
-                       openDB();
-               
-               RuralHouse house = new RuralHouse(houseNumber, null, null, null, null);
+                       openDB();               
                try {
-                       ObjectSet<RuralHouse> result = db.queryByExample(house);
+                       ObjectSet<RuralHouse> result = db.queryByExample(rh);
                        if (!result.isEmpty()) {
                                RuralHouse found = (RuralHouse) result.get(0);
+//                             db.delete(found.getOwner());
+                               db.store(owner);
                                db.delete(found);
                                db.commit();
                        }
@@ -394,7 +439,26 @@ public class DB4oManager {
        }
        
        public Vector<RuralHouse> getRuralHousesByTown(String town){
-               RuralHouse rh = new RuralHouse(0,null,null,town,null);
+               RuralHouse rh = new RuralHouse(null,null,null,town,null);
+               
+               if (c.isDatabaseLocal() == false)
+                       openSDB();
+               else
+                       openDB();
+
+               try {
+                       ObjectSet<RuralHouse> result = db.queryByExample(rh);
+                       Vector<RuralHouse> ruralHouses = new Vector<RuralHouse>();
+                       while (result.hasNext())
+                               ruralHouses.add(result.next());
+                       return ruralHouses;
+               } finally {
+                       db.close();
+               }
+
+       }
+       public RuralHouse getRuralHouseByName(String name){
+               RuralHouse rh = new RuralHouse(name,null,null,null,null);
                
                if (c.isDatabaseLocal() == false)
                        openSDB();
@@ -406,10 +470,13 @@ public class DB4oManager {
                        Vector<RuralHouse> ruralHouses = new Vector<RuralHouse>();
                        while(result.hasNext())
                                ruralHouses.add(result.next());
-                       return ruralHouses;
-               }finally{
                        db.close();
+                       return ruralHouses.get(0);
+               } catch (NullPointerException e){
+                       return null;
                }
                
+               
+               
        }
 }