1 files changed, 7 insertions, 0 deletions
diff --git a/src/models/room.rs b/src/models/room.rs
index 2ec3c7f..6360c88 100644
--- a/src/models/room.rs
+++ b/src/models/room.rs
@@ -33,3 +33,10 @@ 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)
+}