/*
    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::rooms,
};
use diesel::prelude::*;
use serde_derive::{Deserialize, Serialize};

#[derive(Deserialize, Identifiable, PartialEq, Serialize, Queryable)]
pub struct Room {
    pub id: i32,
    pub name: String,
}

pub fn get_all(db: &Connection) -> QueryResult<Vec<Room>> {
    use crate::schema::rooms::dsl::*;
    rooms.load::<Room>(&**db)
}

pub fn by_name(rname: &str, db: &Connection) -> QueryResult<Room> {
    use crate::schema::rooms::dsl::*;
    rooms
        .filter(name.eq(&rname))
        .get_result::<Room>(&**db)
}