From 6109a230ca65cd9a113df72d36247235fe934de4 Mon Sep 17 00:00:00 2001
From: Harald Eilertsen <haraldei@anduin.net>
Date: Sat, 23 Dec 2017 13:00:14 +0100
Subject: Move get_posts function to models.

---
 src/models.rs | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'src/models.rs')

diff --git a/src/models.rs b/src/models.rs
index 67038f1..8bf933e 100644
--- a/src/models.rs
+++ b/src/models.rs
@@ -1,4 +1,5 @@
 use super::schema::posts;
+use diesel::prelude::*;
 
 #[derive(Serialize, Queryable)]
 pub struct Post {
@@ -8,6 +9,14 @@ pub struct Post {
     pub published: bool,
 }
 
+pub fn get_posts(conn: ::DbConn) -> Vec<Post> {
+    use super::schema::posts::dsl::*;
+    posts.filter(published.eq(false))
+        .limit(5)
+        .load::<Post>(&*conn)
+        .expect("Error loading posts")
+}
+
 #[derive(Default, FromForm, Insertable)]
 #[table_name="posts"]
 pub struct NewPost {
-- 
cgit v1.2.3