From fbb50f6a151c0ba91a7c88589f0d4ad30cc2e53d Mon Sep 17 00:00:00 2001
From: Nathan Perry <avaglir@gmail.com>
Date: Mon, 30 Apr 2018 02:29:07 -0400
Subject: maybe as far as we're going to go with clap

---
 src/db/mod.rs | 36 ------------------------------------
 1 file changed, 36 deletions(-)

(limited to 'src/db')

diff --git a/src/db/mod.rs b/src/db/mod.rs
index 9dff1ca..8657a4f 100644
--- a/src/db/mod.rs
+++ b/src/db/mod.rs
@@ -35,42 +35,6 @@ pub fn find_meme<T: AsRef<str>>(conn: &PgConnection, search: T) -> Result<Meme>
         .map_err(Error::from)
 }
 
-pub fn find_text<T: AsRef<str>>(conn: &PgConnection, search: T) -> Result<Meme> {
-    use diesel::dsl::sql;
-    use diesel::sql_types::Text;
-
-    let search = search.as_ref();
-    let format_search = format!("%{}%", search);
-
-    // TODO: check for injection
-    memes::table
-        .filter((memes::title.ilike(&format_search).or(sql("content ILIKE ").bind::<Text, _>(&format_search)))
-            .and(memes::content.is_not_null()))
-        .limit(1)
-        .first::<Meme>(conn)
-        .map_err(Error::from)
-}
-
-pub fn find_audio<T: AsRef<str>>(conn: &PgConnection, search: T) -> Result<Meme> {
-    let format_search = format!("%{}%", search.as_ref());
-
-    memes::table
-        .filter(memes::title.ilike(format_search).and(memes::audio_id.is_not_null()))
-        .limit(1)
-        .first::<Meme>(conn)
-        .map_err(Error::from)
-}
-
-pub fn find_image<T: AsRef<str>>(conn: &PgConnection, search: T) -> Result<Meme> {
-    let format_search = format!("%{}%", search.as_ref());
-
-    memes::table
-        .filter(memes::title.ilike(format_search).and(memes::image_id.is_not_null()))
-        .limit(1)
-        .first::<Meme>(conn)
-        .map_err(Error::from)
-}
-
 pub fn rand_text(conn: &PgConnection) -> Result<Meme> {
     memes::table
         .filter(memes::content.is_not_null())
-- 
cgit v1.3.1