Skip to content

🚀New features and Enhancements release

Compare
Choose a tag to compare
@ota-meshi ota-meshi released this 11 Mar 01:54
· 136 commits to master since this release

Source diff: 0.10.1 -> 0.11.0

🎁 New Features

  • #152 Added extraction condition methods to SqlEntityQuery
  • #161 Changed to supports LimitClause using Oracle12

Dao Interface add extraction condition methods.

examples:

try (SqlAgent agent = config.agent()) {
  // where id = 1001
  agent.query(Department.class).equal("id", 1001).collect();

  // where id in (1001, 1002)
  agent.query(Department.class).in("id", 1001, 1002).collect();

  // where dept_name like '%HR%'
  agent.query(Department.class).contains("deptName", "HR").collect();

  // order by dept_name desc, id asc
  agent.query(Department.class).desc("deptName").asc("id").collect();

  // limit and offset ( When the Database supports limit and offset)
  agent.query(Department.class).offset(3).limit(5).collect();
}

For details of the added methods, please see #152

🌟 Enhancements

  • #160 Added two SqlAgent#delete overloads
    • int delete(Class entityType, Object... keys) ... Delete using the given primary keys
    • SqlEntityDelete delete(Class entityType) ... Deletes using the parameter given to SqlEntityDelete
  • #163 Changed to MapResultSetConverter to get the values using PropertyMapperManager.

⚠️ Breaking Changes!!

  • #163 Changed to MapResultSetConverter to get the values using PropertyMapperManager.
    The constructor of MapResultSetConverter has changed.

⚙️ Chores

  • Changed the version described in README.md to v0.11.0