Add schema for posts, and display them on index page.

6 files changed, 41 insertions, 4 deletions

diff --git a/migrations/2017-10-01-193613_create_posts/down.sql b/migrations/2017-10-01-193613_create_posts/down.sql
new file mode 100644
index 0000000..e1d6323
--- /dev/null
+++ b/migrations/2017-10-01-193613_create_posts/down.sql
@@ -0,0 +1,2 @@
+-- Drop posts table
+DROP TABLE posts
diff --git a/migrations/2017-10-01-193613_create_posts/up.sql b/migrations/2017-10-01-193613_create_posts/up.sql
new file mode 100644
index 0000000..c0c36e5
--- /dev/null
+++ b/migrations/2017-10-01-193613_create_posts/up.sql
@@ -0,0 +1,7 @@
+-- Create posts table
+CREATE TABLE posts (
+  id SERIAL PRIMARY KEY,
+  title VARCHAR NOT NULL,
+  body TEXT NOT NULL,
+  published BOOLEAN NOT NULL DEFAULT 'f'
+)
diff --git a/src/lib.rs b/src/lib.rs
index 0c2d440..8f51d10 100644
--- a/src/lib.rs
+++ b/src/lib.rs
@@ -1,7 +1,10 @@
 #[macro_use]
-extern crate diesel;
-#[macro_use]
 extern crate diesel_codegen;
+pub mod models;
+pub mod schema;
+
+#[macro_use]
+extern crate diesel;
 extern crate dotenv;
 extern crate r2d2_diesel;
 extern crate r2d2;
diff --git a/src/main.rs b/src/main.rs
index 711c343..622ac1c 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -4,9 +4,26 @@
 extern crate rocket;
 extern crate rocket_blog;
 
+extern crate diesel;
+use self::diesel::prelude::*;
+
 #[get("/")]
-fn index(conn: rocket_blog::DbConn) -> &'static str {
-    "Hallo, for faen!"
+fn index(conn: rocket_blog::DbConn) -> String {
+    use rocket_blog::schema::posts::dsl::*;
+    let results = posts.filter(published.eq(false))
+        .limit(5)
+        .load::<rocket_blog::models::Post>(&*conn)
+        .expect("Error loading posts");
+
+    let mut output = String::from("Hallo, for faen!\n\n");
+
+    for post in results {
+        output += &format!("{}\n", post.title);
+        output += "================\n";
+        output += &format!("{}\n", post.body);
+    }
+
+    output
 }
 
 fn main() {
diff --git a/src/models.rs b/src/models.rs
new file mode 100644
index 0000000..110cabe
--- /dev/null
+++ b/src/models.rs
@@ -0,0 +1,7 @@
+#[derive(Queryable)]
+pub struct Post {
+    pub id: i32,
+    pub title: String,
+    pub body: String,
+    pub published: bool,
+}
diff --git a/src/schema.rs b/src/schema.rs
new file mode 100644
index 0000000..236bbc9
--- /dev/null
+++ b/src/schema.rs
@@ -0,0 +1 @@
+infer_schema!("dotenv:DATABASE_URL");