Examples of com.avaje.ebeaninternal.server.core.DefaultSqlUpdate

Package com.avaje.ebeaninternal.server.core

Examples of com.avaje.ebeaninternal.server.core.DefaultSqlUpdate

com.avaje.ebeaninternal.server.core.DefaultSqlUpdate
ng sql = "update f_topic set post_count = :count where id = :topicId"; SqlUpdate update = new SqlUpdate(sql); update.setParameter("count", 1); update.setParameter("topicId", 50); int modifiedCount = Ebean.execute(update);
Note that when the SqlUpdate is executed via Ebean.execute() the sql is parsed to determine if it is an update, delete or insert. In addition the table modified is deduced. If isAutoTableMod() is true, then this is then added to the TransactionEvent and cache invalidation etc is maintained. This means you don't need to use the Ebean.externalModification() method as this has already been done.

You can sql.setAutoTableMod(false); to stop the automatic table modification

EXAMPLE: Using JDBC batching with SqlUpdate
```
 String data = "This is a simple test of the batch processing" + " mode and the transaction execute batch method"; String[] da = data.split(" "); String sql = "insert into junk (word) values (?)"; SqlUpdate sqlUpdate = Ebean.createSqlUpdate(sql); Transaction t = Ebean.beginTransaction(); t.setBatchMode(true); t.setBatchSize(3); try { for (int i = 0; i < da.length; i++) { sqlUpdate.setParameter(1, da[i]); sqlUpdate.execute(); } // NB: commit implicitly flushes the batch  Ebean.commitTransaction(); } finally { Ebean.endTransaction(); } 
```
@see com.avaje.ebean.CallableSql @see com.avaje.ebean.Ebean#execute(SqlUpdate)

        return delete;
    }
    
    private SqlUpdate deleteByParentId(Object parentId) {
        
        DefaultSqlUpdate delete = new DefaultSqlUpdate(deleteByParentIdSql);
        if (exportedProperties.length == 1){
            delete.addParameter(parentId);
        } else {
            targetDescriptor.getIdBinder().bindId(delete, parentId);
        }
        return delete;
    }

View Full Code Here

      return deleteByParentIdList(parentIdist);
    }
  }


  private SqlUpdate deleteByParentId(Object parentId) {
    DefaultSqlUpdate sqlDelete = new DefaultSqlUpdate(deleteByParentIdSql);
    bindWhereParendId(sqlDelete, parentId);
    return sqlDelete;
  }

View Full Code Here

    sb.append(deleteByParentIdInSql);


    String inClause = buildInClauseBinding(parentIdist.size(), exportedPropertyBindProto);
    sb.append(inClause);


    DefaultSqlUpdate delete = new DefaultSqlUpdate(sb.toString());
    for (int i = 0; i < parentIdist.size(); i++) {
      bindWhereParendId(delete, parentIdist.get(i));
    }


    return delete;

View Full Code Here


    StringBuilder sb = new StringBuilder(deleteByIdInSql);
    String inClause = idBinder.getIdInValueExprDelete(idList.size());
    sb.append(inClause);


    DefaultSqlUpdate delete = new DefaultSqlUpdate(sb.toString());
    for (int i = 0; i < idList.size(); i++) {
      idBinder.bindId(delete, idList.get(i));
    }
    return delete;
  }

View Full Code Here

   * Return SQL that can be used to delete by Id without any optimistic
   * concurrency checking.
   */
  private SqlUpdate deleteById(Object id) {


    DefaultSqlUpdate sqlDelete = new DefaultSqlUpdate(deleteByIdSql);


    Object[] bindValues = idBinder.getBindValues(id);
    for (int i = 0; i < bindValues.length; i++) {
      sqlDelete.addParameter(bindValues[i]);
    }


    return sqlDelete;
  }

View Full Code Here

        sb.append(deleteByParentIdInSql);
        
        String inClause = targetIdBinder.getIdInValueExpr(parentIdist.size());
        sb.append(inClause);
        
        DefaultSqlUpdate delete = new DefaultSqlUpdate(sb.toString());
        for (int i = 0; i < parentIdist.size(); i++) {            
            targetIdBinder.bindId(delete, parentIdist.get(i));
        }
        
        return delete;

View Full Code Here

      }
      sb.append("?");
    }
    sb.append(")");


    return new DefaultSqlUpdate(server, sb.toString(), bindParams);
  }

View Full Code Here

      for (int i = 0; i < bindValues.size(); i++) {
        bindParams.setParameter(++count, bindValues.get(i));
      }
    }


    return new DefaultSqlUpdate(server, sb.toString(), bindParams);
  }

View Full Code Here

      sb.append(" = ?");


      bindParams.setParameter(count, entry.getValue());
    }


    return new DefaultSqlUpdate(server, sb.toString(), bindParams);
  }

View Full Code Here

TOP

Related Classes of com.avaje.ebeaninternal.server.core.DefaultSqlUpdate

com.avaje.ebeaninternal.api.BindParams

com.avaje.ebeaninternal.server.deploy.BeanDescriptor

com.avaje.ebeaninternal.server.deploy.BeanPropertyAssocMany

com.avaje.ebeaninternal.server.deploy.BeanPropertyAssocOne

com.avaje.ebeaninternal.server.deploy.IntersectionRow

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.