Example usage for org.apache.ibatis.mapping FetchType EAGER

Introduction

In this page you can find the example usage for org.apache.ibatis.mapping FetchType EAGER.

Prototype

FetchType EAGER

To view the source code for org.apache.ibatis.mapping FetchType EAGER.

Click Source Link

Usage

From source file:shionn.blog.db.dao.adm.PostAdmDao.java

License:GNU General Public License

@Select("SELECT p.*, c.title AS cat_title FROM post AS p " + "LEFT JOIN category AS c ON p.category = c.id "
        + "WHERE p.id = #{id}")
@Results({ @Result(column = "id", property = "id"), @Result(column = "category", property = "category.id"),
        @Result(column = "cat_title", property = "category.title"),
        @Result(column = "id", property = "tags", many = @Many(select = "readTags", fetchType = FetchType.EAGER)) })
Post get(int id);

---

From source file:shionn.blog.db.dao.CategoryDao.java

License:GNU General Public License

@Select("SELECT p.id, p.url, p.title, p.published, p.content, p.logo, "
        + "u.name, count(c.id) AS comment_count, " + "cat.url AS cat_url, cat.title AS cat_title "
        + "FROM post AS p " + "LEFT JOIN user AS u ON p.author = u.id "
        + "LEFT JOIN comment AS c ON c.post = p.id " + "LEFT JOIN category AS cat ON cat.id = p.category "
        + "WHERE p.type = 'post' " + "AND p.status = 'publish' " + "AND p.published < NOW() "
        + "AND cat.url = #{url} " + "GROUP BY p.id " + "ORDER BY p.published DESC " + "LIMIT 5")
@Results({ @Result(column = "id", property = "id"), @Result(column = "u.name", property = "author.name"),
        @Result(column = "cat_title", property = "category.title"),
        @Result(column = "cat_url", property = "category.url"),
        @Result(column = "id", property = "tags", many = @Many(select = "readTags", fetchType = FetchType.EAGER)) })
public List<Post> readPosts(String url);

---

From source file:shionn.blog.db.dao.frag.MenuDao.java

License:GNU General Public License

@Select("SELECT id, parent, title, url FROM menu WHERE id=#{id} order by position")
@Results({ @Result(column = "id", property = "id"),
        @Result(column = "id", property = "items", many = @Many(fetchType = FetchType.EAGER, select = "readChildsMenu")) })
public Menu readMenu(@Param("id") int id);

---

From source file:shionn.blog.db.dao.frag.MenuDao.java

License:GNU General Public License

@Select("SELECT id, parent, title, url FROM menu WHERE parent=#{parent} order by position")
@Results({ @Result(column = "id", property = "id"),
        @Result(column = "id", property = "items", many = @Many(fetchType = FetchType.EAGER, select = "readChildsMenu")) })
public List<Menu> readChildsMenu(@Param("parent") int id);

---

From source file:shionn.blog.db.dao.HomeDao.java

License:GNU General Public License

@Select("SELECT p.id, p.url, p.title, p.published, p.content, p.logo, "
        + "u.name, count(c.id) AS comment_count, " + "cat.url AS cat_url, cat.title AS cat_title "
        + "FROM post AS p " + "LEFT JOIN user AS u ON p.author = u.id "
        + "LEFT JOIN comment AS c ON c.post = p.id " + "LEFT JOIN category AS cat ON cat.id = p.category "
        + "WHERE p.type = 'post' " + "AND p.status = 'publish' " + "AND p.published < NOW() " + "GROUP BY p.id "
        + "ORDER BY p.published DESC " + "LIMIT 5")
@Results({ @Result(column = "id", property = "id"), @Result(column = "u.name", property = "author.name"),
        @Result(column = "cat_title", property = "category.title"),
        @Result(column = "cat_url", property = "category.url"),
        @Result(column = "id", property = "tags", many = @Many(select = "readTags", fetchType = FetchType.EAGER)) })
public List<Post> readPosts();

---

From source file:shionn.blog.db.dao.PostDao.java

License:GNU General Public License

@Select("SELECT p.id, p.url, p.title, p.published, p.updated, p.content, p.logo, "
        + "u.name as author_name, count(c.id) AS comment_count, "
        + "cat.url AS cat_url, cat.title AS cat_title " + "FROM post AS p "
        + "LEFT JOIN user AS u ON p.author = u.id " + "LEFT JOIN category AS cat ON cat.id = p.category "
        + "LEFT JOIN comment AS c ON c.post = p.id " + "WHERE p.url = #{url} " + "GROUP BY p.id ")
@Results({ @Result(column = "id", property = "id"), @Result(column = "author_name", property = "author.name"),
        @Result(column = "cat_title", property = "category.title"),
        @Result(column = "cat_url", property = "category.url"),
        @Result(column = "id", property = "tags", many = @Many(select = "readTags", fetchType = FetchType.EAGER)),
        @Result(column = "id", property = "comments", many = @Many(select = "readComments", fetchType = FetchType.EAGER)), })
Post readPost(String url);// w ww  .ja  v  a 2 s  .c  o m

---

From source file:shionn.blog.db.dao.TagDao.java

License:GNU General Public License

@Select("SELECT p.id, p.url, p.title, p.published, p.content, p.logo, "
        + "u.name, count(c.id) AS comment_count, " + "cat.url AS cat_url, cat.title AS cat_title "
        + "FROM post AS p " + "LEFT JOIN user AS u ON p.author = u.id "
        + "LEFT JOIN comment AS c ON c.post = p.id " + "LEFT JOIN category AS cat ON cat.id = p.category "
        + "LEFT JOIN posttags AS pt ON p.id = pt.post " + "LEFT JOIN tag AS t ON pt.tag = t.id "
        + "WHERE p.type = 'post' " + "AND p.status = 'publish' " + "AND p.published < NOW() "
        + "AND t.url = #{url} " + "GROUP BY p.id " + "ORDER BY p.published DESC " + "LIMIT 5")
@Results({ @Result(column = "id", property = "id"), @Result(column = "u.name", property = "author.name"),
        @Result(column = "cat_title", property = "category.title"),
        @Result(column = "cat_url", property = "category.url"),
        @Result(column = "id", property = "tags", many = @Many(select = "readTags", fetchType = FetchType.EAGER)) })
public List<Post> readPosts(String url);

---