/*
    Social program for Ramaskrik.
    Copyright (C) 2019  Harald Eilertsen <haraldei@anduin.net>

    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 <https://www.gnu.org/licenses/>.
*/

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<String>,
}

#[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<Vec<Film>> {
    use crate::schema::films::dsl::*;
    films.load::<Film>(&**db)
}