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