Examples of com.avaje.ebean.SqlUpdate.execute()

com.avaje.ebean.SqlUpdate.execute()
Execute the update returning the number of rows modified.
After you have executed the SqlUpdate you can bind new variables using {@link #setParameter(String,Object)} etc and then execute the SqlUpdateagain.

For JDBC batch processing refer to {@link Transaction#setBatchMode(boolean)} and{@link Transaction#setBatchSize(int)}.
@see com.avaje.ebean.Ebean#execute(SqlUpdate)

        .createSqlUpdate("update o_country set name = :name where code = :code");
    sqlUpdate.setParameter("name", "Aotearoa");
    sqlUpdate.setParameter("code", "NZ");


    // this should just clear the entire country cache
    int rows = sqlUpdate.execute();
    Assert.assertEquals(1, rows);
    Assert.assertEquals(0, countryCache.size());


    // set it back...
    sqlUpdate.setParameter("name", "New Zealand");

View Full Code Here

    Assert.assertEquals(0, countryCache.size());


    // set it back...
    sqlUpdate.setParameter("name", "New Zealand");
    sqlUpdate.setParameter("code", "NZ");
    rows = sqlUpdate.execute();
    Assert.assertEquals(1, rows);
  }
}

View Full Code Here

    SqlUpdate sqlUpdate = Ebean.createSqlUpdate(sql);
    sqlUpdate.setParameter(1, 10000);
    sqlUpdate.setParameter(2, "hello");
    sqlUpdate.setParameter(3, "rob");


    sqlUpdate.execute();


  }
}

View Full Code Here

      String sql;
      SqlUpdate delete;


      sql = "delete from td_child";
      delete = Ebean.createSqlUpdate(sql);
      delete.execute();


      sql = "delete from td_parent";
      delete = Ebean.createSqlUpdate(sql);
      delete.execute();

View Full Code Here

      delete = Ebean.createSqlUpdate(sql);
      delete.execute();


      sql = "delete from td_parent";
      delete = Ebean.createSqlUpdate(sql);
      delete.execute();


      EdParent parent = new EdParent();
      parent.setName("MyComputer");


      EdChild child = new EdChild();

View Full Code Here

    final String updateModDml = "update audit_log set modified_description = :desc";
    
    SqlUpdate sqlUpdate = Ebean.createSqlUpdate(updateDml);
    sqlUpdate.setParameter("desc", "foo2");
    sqlUpdate.setParameter("id", id);
    sqlUpdate.execute();
    
    SqlUpdate updateMod = Ebean.createSqlUpdate(  updateModDml ) ;
    updateMod.setParameter("desc", "mod0");
    updateMod.execute();

View Full Code Here

    sqlUpdate.setParameter("id", id);
    sqlUpdate.execute();
    
    SqlUpdate updateMod = Ebean.createSqlUpdate(  updateModDml ) ;
    updateMod.setParameter("desc", "mod0");
    updateMod.execute();
    
    AuditLog log3 = Ebean.find(AuditLog.class, log.getId());
    Assert.assertEquals("foo2", log3.getDescription());
    Assert.assertEquals("mod0", log3.getModifiedDescription());

View Full Code Here

    Ebean.execute(new TxRunnable() {  
      public void run() {  
        SqlUpdate update = Ebean.createSqlUpdate(  updateDml ) ;
        update.setParameter("desc", "foo3");
        update.setParameter("id", id);
        update.execute();


        SqlUpdate updateMod = Ebean.createSqlUpdate(  updateModDml ) ;
        updateMod.setParameter("desc", "mod1");
        updateMod.execute();
      }

View Full Code Here

        update.setParameter("id", id);
        update.execute();


        SqlUpdate updateMod = Ebean.createSqlUpdate(  updateModDml ) ;
        updateMod.setParameter("desc", "mod1");
        updateMod.execute();
      }  
    });


    AuditLog log4 = Ebean.find(AuditLog.class, log.getId());
    Assert.assertEquals("foo3", log4.getDescription());

View Full Code Here

    Ebean.beginTransaction();
    
    SqlUpdate update = Ebean.createSqlUpdate( updateDml) ;
    update.setParameter("desc", "foo4");
    update.setParameter("id", id);
    update.execute();


    updateMod = Ebean.createSqlUpdate(  updateModDml ) ;
    updateMod.setParameter("desc", "mod2");
    updateMod.execute();

View Full Code Here

TOP

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.