@Override public int bind(int position, SqlUpdate update, EntityBean bean) { Object value = getIdValue(bean); update.setParameter(position, value); return ++position; }
@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; }
/** * 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); } }
SqlUpdate update = Ebean.createSqlUpdate("UPDATE post set likes = likes+1 where id = :id"); update.setParameter("id", post.id).execute();
@Override public int bind(int position, SqlUpdate update, EntityBean bean) { Object value = getIdValue(bean); update.setParameter(position, value); return ++position; }
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)"); }
@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(); } }
void setParameter(String name, Object value) { switch (queryType) { case QUERY: ((Query) queryInstance).setParameter(name, value); break; case UPDATE: ((Update) queryInstance).setParameter(name, value); break; case SQL_UPDATE: ((SqlUpdate) queryInstance).setParameter(name, value); break; default: throw new IllegalArgumentException("query not supported!"); } }
void setParameter(int position, Object value) { switch (queryType) { case QUERY: ((Query) queryInstance).setParameter(position, value); break; case UPDATE: ((Update) queryInstance).setParameter(position, value); break; case SQL_UPDATE: ((SqlUpdate) queryInstance).setParameter(position, value); break; default: throw new IllegalArgumentException("query not supported!"); } }
void setParameter(String name, Object value) { switch (queryType) { case QUERY: ((Query) queryInstance).setParameter(name, value); break; case UPDATE: ((Update) queryInstance).setParameter(name, value); break; case SQL_UPDATE: ((SqlUpdate) queryInstance).setParameter(name, value); break; default: throw new IllegalArgumentException("query not supported!"); } }
void setParameter(int position, Object value) { switch (queryType) { case QUERY: ((Query) queryInstance).setParameter(position, value); break; case UPDATE: ((Update) queryInstance).setParameter(position, value); break; case SQL_UPDATE: ((SqlUpdate) queryInstance).setParameter(position, value); break; default: throw new IllegalArgumentException("query not supported!"); } }
@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; }
/** * 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); } }