Examples of com.avaje.ebean.SqlRow

com.avaje.ebean.SqlRow
Used to return raw SQL query results.
Refer to {@link SqlQuery} for examples.

There are convenience methods such as getInteger(), getBigDecimal() etc. The reason for these methods is that the values put into this map often come straight from the JDBC resultSet. Depending on the JDBC driver it may put a different type into a given property. For example an Integer, BigDecimal, Double could all be put into a property depending on the JDBC driver used. These convenience methods automatically convert the value as required returning the type you expect.

    Assert.assertTrue(qlList.size() == 1);


    SqlQuery q = Ebean.createSqlQuery("select * from e_basicenc where id = :id");
    q.setParameter("id", e.getId());


    SqlRow row = q.findUnique();
    String name = row.getString("name");
    Object desc = row.get("description");
    System.out.println("SqlRow: " + name + " " + desc);


    EBasicEncrypt e1 = Ebean.find(EBasicEncrypt.class, e.getId());


    String desc1 = e1.getDescription();

View Full Code Here

    Ebean.save(e);


    SqlQuery q = Ebean.createSqlQuery("select * from e_basicenc_bin where id = :id");
    q.setParameter("id", e.getId());


    SqlRow row = q.findUnique();
    String name = row.getString("name");
    Object data = row.get("data");
    Object someTimeData = row.get("some_time");
    System.out.println("SqlRow name:" + name + " data:" + data + " someTime:" + someTimeData);


    EBasicEncryptBinary e1 = Ebean.find(EBasicEncryptBinary.class, e.getId());


    Timestamp t1 = e1.getSomeTime();

View Full Code Here

    Ebean.save(b);


    SqlQuery q = Ebean.createSqlQuery("select * from e_basic_enum_id where status = :status");
    q.setParameter("status", b.getStatus());


    SqlRow sqlRow = q.findUnique();
    String strStatus = sqlRow.getString("status");


    Assert.assertEquals("N", strStatus);


    try {
      b = Ebean.find(EBasicEnumId.class, b.getStatus());

View Full Code Here


    Ebean.save(e);


    SqlQuery q = Ebean.createSqlQuery("select * from tuuid_entity where id = :id");
    q.setParameter("id", e.getId());
    SqlRow sqlRow = q.findUnique();


    UUID id = sqlRow.getUUID("id");


    Assert.assertNotNull(id);


    Boolean b = sqlRow.getBoolean("name");
    Assert.assertFalse(b);
  }

View Full Code Here

    Ebean.save(b);


    SqlQuery q = Ebean.createSqlQuery("select * from e_basic where id = :id");
    q.setParameter("id", b.getId());


    SqlRow sqlRow = q.findUnique();
    String strStatus = sqlRow.getString("status");


    Assert.assertEquals("N", strStatus);


    EBasic b2 = new EBasic();
    b2.setName("Apple");

View Full Code Here


      BeanCollectionWrapper wrapper = new BeanCollectionWrapper(request);
      boolean isMap = wrapper.isMap();
      String mapKey = query.getMapKey();
      
      SqlRow bean = null;
      
      while (rset.next()) {
        synchronized (query) {          
          // synchronise for query.cancel() support    
          if (!query.isCancelled()){
            bean = readRow(request, rset, propNames, estimateCapacity);
          }
        }
        if (bean != null){
          // bean can be null if query cancelled
          if (listener != null) {
            listener.process(bean);
  
          } else {
            if (isMap) {
              Object keyValue = bean.get(mapKey);
              wrapper.addToMap(bean, keyValue);
            } else {
              wrapper.addToCollection(bean);
            }
          }

View Full Code Here


    // by default a map will rehash on the 12th entry
    // it will be pretty common to have 12 or more entries so
    // to reduce rehashing I am trying to estimate a good
    // initial capacity for the MapBean to use.
    SqlRow bean = new DefaultSqlRow(initialCapacity, 0.75f, dbTrueValue);
    
    int index = 0;


    for (int i = 0; i < propNames.length; i++) {
      index++;
      Object value = rset.getObject(index);
      bean.set(propNames[i], value);
    }


    return bean;


  }

View Full Code Here

TOP

Related Classes of com.avaje.ebean.SqlRow

com.avaje.ebeaninternal.server.query.DefaultRelationalQueryEngine

com.avaje.tests.basic.encrypt.TestEncrypt

com.avaje.tests.basic.encrypt.TestEncryptBinary

com.avaje.tests.basic.type.TestEnumValueAnnotation

com.avaje.tests.basic.type.TestSqlRowUUID

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.