1 files changed, 9 insertions, 0 deletions
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 {