Examples of org.exolab.castor.jdo.Database

org.exolab.castor.jdo.Database
a database and start a transaction db = jdo.getDatabase(); db.begin(); // Select all the products in a given group oql = db.getOQLQuery( "SELECT p FROM Product p WHERE group=$"); oql.bind( groupId ); results = oql.execute(); while ( results.hasMore() ) { // A 25% mark down for each product and mark as sale prod = (Product) results.next(); prod.markDown( 0.25 ); prod.setOnSale( true ); } // Commit all changes, close the database db.commit(); db.close(); @author Assaf Arkin @version $Revision: 7976 $ $Date: 2006-03-16 16:04:24 -0700 (Thu, 16 Mar 2006) $ @see JDOManager#getDatabase() @see Query

        
        database.close();
    }


    public void testLoadTruck() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        Truck truck = (Truck) database.load(Truck.class, new Integer(5));
        database.commit();
        
        assertNotNull(truck);
        assertEquals(5, truck.getId());
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testLoadCar() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        Object object = database.load(Car.class, new Integer(5));
        assertNotNull (object);
        assertEquals ("ctf.jdo.tc9x.Truck", object.getClass().getName());
        Truck truck = (Truck) object; 
        database.commit();
        
        assertNotNull(truck);
        assertEquals(5, truck.getId());
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testCreateAndLoadCar() throws Exception {
        Database database = _category.getDatabase();


        database.begin();
        Order order = new Order();
        order.setId(11);
        order.setName("order 11");
        database.create(order);
        database.commit();
        
        database.begin();
        ProductDetail detail = new ProductDetail();
        detail.setId(11);
        detail.setCategory("category 11");
        detail.setLocation("location 11");
        database.create(detail);
        database.commit();
        
        database.begin();
        Truck truck = new Truck();
        truck.setId(11);
        truck.setName("truck 11");
        truck.setKw(112);
        truck.setMake("Fiat");
        truck.setMaxWeight(3750);
        truck.setDetail((ProductDetail) 
                database.load(ProductDetail.class, new Integer(11)));
        database.create(truck);
        Collection orders = new LinkedList();
        orders.add(database.load(Order.class, new Integer(11)));
        truck.setOrders(orders);
        database.commit();
        
        database.begin();
        Object object = database.load(Car.class, new Integer(11));
        assertNotNull(object);
        assertEquals("ctf.jdo.tc9x.Truck", object.getClass().getName());
        Truck loadedTruck = (Truck) object; 
        database.commit();
        
        assertNotNull(loadedTruck);
        assertEquals(11, loadedTruck.getId());
        
        database.begin();
        database.remove(database.load (Car.class, new Integer(11)));
        database.remove(database.load (ProductDetail.class, new Integer(11)));
        database.remove(database.load(Order.class, new Integer(11)));
        database.commit();
        
        database.close();
    }

View Full Code Here

    /**
     * Test method.
     * @throws Exception For any exception thrown.
     */
    public void testQuerySortedCollection() throws Exception {
        Database db = _category.getDatabase();
        db.begin();
        
        OQLQuery query = db.getOQLQuery("SELECT c FROM "
                + SortedContainer.class.getName() + " c WHERE id = $1");
        query.bind(new Integer(1));
        QueryResults results = query.execute();
        
        SortedContainer entity = null;
        
        entity = (SortedContainer) results.next();
        assertNotNull(entity);
        assertEquals(new Integer(1), entity.getId());
        assertNotNull (entity.getTwos());
        assertEquals(2, entity.getTwos().size());
 
        SortedSet twos = entity.getTwos();
        Iterator iterator = twos.iterator();
        
        SortedContainerItem two = null;
        int i = 1;
        while (iterator.hasNext()) {
            two = (SortedContainerItem) iterator.next();
            LOG.error(two);
            assertNotNull(two);
            assertEquals(new Integer(i), two.getId());
            i++;
        }


        db.commit();
        db.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testLoadOwner() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        Owner owner = (Owner) database.load(Owner.class, new Integer(1));
        database.commit();
        
        assertNotNull(owner);
        assertEquals(1, owner.getId().intValue());
        assertEquals("owner 1", owner.getName());
        
        Product product = owner.getProduct();
        assertNotNull(product);
        assertEquals(1, product.getId());
        assertEquals("ctf.jdo.tc9x.Laptop", product.getClass().getName());
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }
   
    public void testLoadM() throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        M m = (M) database.load(M.class, new Integer(1));
        database.commit();
        
        assertNotNull(m);
        assertEquals(1, m.getId());
        assertEquals("m1", m.getName());
        
        Collection ns = m.getNs();
        assertNotNull(ns);
        assertEquals(2, ns.size());
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testQueryOwner () throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        OQLQuery query = database.getOQLQuery("select owner from "
                + Owner.class.getName() + " as owner");
        QueryResults results = query.execute();
        
        if (results.hasMore()) {
            int counter = 1;
            while (results.hasMore()) {
                Owner owner = (Owner) results.next();
                assertNotNull(owner);
                assertEquals(counter, owner.getId().intValue());
                
                counter += 1;
            }
        } else {
            fail("Query does not return any Computer instances.");
        }
        database.commit();
        
        database.close();
    }

View Full Code Here

                "ctf.jdo.tc9x.Laptop",
                "ctf.jdo.tc9x.Server",
                "ctf.jdo.tc9x.Server"
        };
        
        Database database = _category.getDatabase();
        
        database.begin();
        OQLQuery query = database.getOQLQuery("select computer from "
                + Computer.class.getName() + " as computer order by computer.id");
        QueryResults results = query.execute();
        
        if (results.hasMore()) {
            int counter = 1;
            while (results.hasMore()) {
                Computer computer = (Computer) results.next();
                assertNotNull(computer);
                assertEquals(counter, computer.getId());
                assertEquals(classNames[counter - 1], computer.getClass().getName());
                
                counter += 1;
            }
        } else {
            fail("Query does not return any Computer instances.");
        }
        database.commit();
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }


    public void testQueryLaptops () throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        OQLQuery query = database.getOQLQuery("select l from "
                + Laptop.class.getName() + " as l order by l.id");
        QueryResults results = query.execute();
        
        if (results.hasMore()) {
            int counter = 1;
            Laptop laptop = null;
            while (results.hasMore()) {
                laptop = (Laptop) results.next();
                assertNotNull(laptop);
                assertEquals(counter, laptop.getId());
                
                counter += 1;
            }
        } else {
            fail("Query does not return any Laptop instances.");
        }
        database.commit();
        
        database.close();
    }

View Full Code Here

        
        database.close();
    }
    
    public void testQueryServers () throws Exception {
        Database database = _category.getDatabase();
        
        database.begin();
        OQLQuery query = database.getOQLQuery("select s from "
                + Server.class.getName() + " as s order by s.id");
        QueryResults results = query.execute();
        
        if (results.hasMore()) {
            int counter = 3;
            while (results.hasMore()) {
                Server server = (Server) results.next();
                assertNotNull(server);
                assertEquals(counter, server.getId());
                
                counter += 1;
            }
        } else {
            fail("Query does not return any Server instances.");
        }
        database.commit();
        
        database.close();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.exolab.castor.jdo.Database

com.frovi.ss.Tree.BaseNodeSupplier

ctf.jdo.tc20x.TestSelfRelation

ctf.jdo.tc20x.TestSelfRelationExtend

ctf.jdo.tc20x.TestTimezone

ctf.jdo.tc3x.TestNamedQueries

ctf.jdo.tc7x.TestAutostore

ctf.jdo.tc7x.TestAutostoreMany

ctf.jdo.tc7x.TestExpireManyToMany

ctf.jdo.tc8x.TestEnum

ctf.jdo.tc8x.TestIdentityPerFieldMapping

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.