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!"); } }
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!"); } }
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!"); } }
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!"); } }
@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(); } }
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(); }); }