From 18e23bb10d7645b99419dd6bd3ac50a511b0f65e Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Tue, 2 Apr 2019 22:05:05 +0200 Subject: Add route to fetch films from database. --- src/models/film.rs | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 43 insertions(+) create mode 100644 src/models/film.rs (limited to 'src/models/film.rs') diff --git a/src/models/film.rs b/src/models/film.rs new file mode 100644 index 0000000..3926dd1 --- /dev/null +++ b/src/models/film.rs @@ -0,0 +1,43 @@ +/* + Social program for Ramaskrik. + Copyright (C) 2019 Harald Eilertsen + + This program is free software: you can redistribute it and/or modify + it under the terms of the GNU Affero General Public License as published by + the Free Software Foundation, either version 3 of the License, or + (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU Affero General Public License for more details. + + You should have received a copy of the GNU Affero General Public License + along with this program. If not, see . +*/ + +use crate::{ + db::Connection, + schema::films, +}; +use diesel::prelude::*; +use serde_derive::{Deserialize, Serialize}; + +#[derive(Deserialize, Identifiable, PartialEq, Serialize, Queryable)] +pub struct Film { + pub id: i32, + pub title: String, + pub url: Option, +} + +#[derive(Deserialize, Insertable)] +#[table_name = "films"] +pub struct NewFilm<'a> { + pub title: &'a str, + pub url: Option<&'a str>, +} + +pub fn get_all(db: &Connection) -> QueryResult> { + use crate::schema::films::dsl::*; + films.load::(&**db) +} -- cgit v1.2.3