@Override public int bind(int position, SqlUpdate update, EntityBean bean) { Object value = getIdValue(bean); update.setParameter(position, value); return ++position; }
@Override public void bindElementValue(SqlUpdate insert, Object value) { insert.setNextParameter(value); }
public static Result deleteBar(String name) { SqlUpdate down = Ebean.createSqlUpdate("DELETE FROM bar WHERE name = :param1 "); down.setParameter("param1", name); int deletedCount = down.execute(); return ok("Deleted " + deletedCount + " record(s)"); }
int delete() { switch (queryType) { case QUERY: return ((Query) queryInstance).delete(); case UPDATE: return ((Update) queryInstance).execute(); case SQL_UPDATE: return ((SqlUpdate) queryInstance).execute(); default: throw new IllegalArgumentException("query not supported!"); } }
deleteById.setAutoTableMod(false); if (idList != null) { t.getEvent().addDeleteByIdList(descriptor, idList);
@Data @Entity @Table(name = "sessions") public class UserSession { @ManyToOne(fetch = EAGER) @JoinColumn(name = "uid") private User user; private String session; private Timestamp taken; public UserSession(User u, String sessionId) { user = u; session = sessionId; taken = new Timestamp(System.currentTimeMillis()); } public static UserSession getSession(String session) { return Ebean.find(UserSession.class).where().eq("session", session).findUnique(); } public void delete() { SqlUpdate deleteQuery = Ebean.createSqlUpdate("DELETE FROM sessions WHERE uid = :uid AND session = :session"); deleteQuery.setParameter("uid", user.id); deleteQuery.setParameter("session", session); deleteQuery.execute(); } }
int update() { switch (queryType) { case QUERY: return ((Query) queryInstance).update(); case UPDATE: return ((Update) queryInstance).execute(); case SQL_UPDATE: return ((SqlUpdate) queryInstance).execute(); default: throw new IllegalArgumentException("query not supported!"); } }
deleteById.setAutoTableMod(false); if (idList != null) { t.getEvent().addDeleteByIdList(descriptor, idList);
@Override public int bind(int position, SqlUpdate update, EntityBean bean) { int pos = position; EntityBean embedded = (EntityBean) foreignAssocOne.getValue(bean); for (ImportedIdSimple anImported : imported) { if (anImported.owner.isUpdateable()) { Object scalarValue = anImported.foreignProperty.getValue(embedded); update.setParameter(pos++, scalarValue); } } return pos; }
int update() { switch (queryType) { case QUERY: return ((Query) queryInstance).update(); case UPDATE: return ((Update) queryInstance).execute(); case SQL_UPDATE: return ((SqlUpdate) queryInstance).execute(); default: throw new IllegalArgumentException("query not supported!"); } }
@Override public void bindElementValue(SqlUpdate insert, Object value) { insert.setNextParameter(value); }
/** * Build and execute a SqlUpdate to set the importId value (as it will be available now). * <p> * This is executed later (deferred) until after JDBC batch flush or prior to commit. * </p> */ public void execute(SpiTransaction transaction) { String sql = beanDescriptor.getUpdateImportedIdSql(importedId); SqlUpdate sqlUpdate = ebeanServer.createSqlUpdate(sql); // bind the set clause for the importedId int pos = importedId.bind(1, sqlUpdate, assocBean); // bind the where clause for the bean Object[] idValues = beanDescriptor.getIdBinder().getIdValues(bean); for (int j = 0; j < idValues.length; j++) { sqlUpdate.setParameter(pos + j, idValues[j]); } ebeanServer.execute(sqlUpdate, transaction); } }
int delete() { switch (queryType) { case QUERY: return ((Query) queryInstance).delete(); case UPDATE: return ((Update) queryInstance).execute(); case SQL_UPDATE: return ((SqlUpdate) queryInstance).execute(); default: throw new IllegalArgumentException("query not supported!"); } }
/** * Bind all the property values to the SqlUpdate. */ public void bindElementValue(SqlUpdate insert, Object value) { EntityBean bean = (EntityBean) value; for (BeanProperty property : propertiesBaseScalar) { insert.setNextParameter(property.getValue(bean)); } }
SqlUpdate update = Ebean.createSqlUpdate("UPDATE post set likes = likes+1 where id = :id"); update.setParameter("id", post.id).execute();
private void deleteAll() { Ebean.execute(() -> { // Ebean.currentTransaction().setBatchMode(false); // orm update use bean name and bean properties // server.createUpdate(OrderShipment.class, "delete from orderShipment").execute(); server.createUpdate(OrderDetail.class, "delete from orderDetail").execute(); server.createUpdate(Order.class, "delete from order").execute(); server.createUpdate(Contact.class, "delete from contact").execute(); server.createUpdate(Customer.class, "delete from Customer").execute(); server.createUpdate(Address.class, "delete from address").execute(); // sql update uses table and column names server.createSqlUpdate("delete from country").execute(); server.createSqlUpdate("delete from product").execute(); }); }
@Override public void bindImport(SqlUpdate sql, EntityBean other) { Object value = getIdValue(other); if (value == null) { throw new PersistenceException("Foreign Key value null?"); } sql.setNextParameter(value); }
@Override public int bind(int position, SqlUpdate update, EntityBean bean) { Object value = getIdValue(bean); update.setParameter(position, value); return ++position; }