hunt entity v2.1.0 released!
Brian
zoujiaqing at gmail.com
Wed Jan 9 11:28:58 UTC 2019
Hunt Entity is an object-relational mapping (ORM) framework for
dlang's database, support PostgreSQL / MySQL / SQLite.
This version added pagination for EQL's createQuery();
Example 1 for pagination:
```D
class User
{
mixin MakeModel;
@AutoIncrement
@PrimaryKey
int id;
string name;
}
auto query = em.createQuery!User("SELECT * FROM User", new
Pageable(0, 10));
auto page = query.getPageResult();
logDebug("Page NO: %s, size of Page: %s, Total Pages: %s, Total:
%s".format(page.getNumber(), page.getSize(),
page.getTotalPages(), page.getTotalElements()));
foreach (user; page.getContent())
{
logDebug("User[%s] is: %s".format(user.id, user.name));
}
```
Example 2 for limit && offset :
```D
class User
{
mixin MakeModel;
@AutoIncrement
@PrimaryKey
int id;
string name;
}
auto query = em.createQuery!User("SELECT * FROM
User").setFirstResult(10).setMaxResults(20);
foreach (user; query.getResultList())
{
logDebug("User[%s] is: %s".format(user.id, user.name));
}
```
More information about the Digitalmars-d-announce
mailing list