diff options
Diffstat (limited to 'src/db/mod.rs')
| -rw-r--r-- | src/db/mod.rs | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/src/db/mod.rs b/src/db/mod.rs index a331ead..6cc09b4 100644 --- a/src/db/mod.rs +++ b/src/db/mod.rs @@ -272,6 +272,9 @@ pub struct Stats { pub most_popular_named_meme: String, pub most_popular_named_meme_count: usize, + pub most_popular_random_meme: String, + pub most_popular_random_meme_count: usize, + pub most_popular_meme_overall: String, pub most_popular_meme_overall_count: usize, } @@ -407,6 +410,20 @@ pub fn stats(conn: &PgConnection) -> Result<Stats> { let rows = raw_conn.query(r#" SELECT memes.title, COUNT(*) FROM invocation_records INNER JOIN memes ON meme_id = memes.id + WHERE random IS TRUE + GROUP BY memes.title + ORDER BY COUNT(*) DESC + LIMIT 1; + "#, &[])?; + + let row = rows.get(0); + + let most_random_meme = row.get(0); + let most_random_meme_count: i64 = row.get(1); + + let rows = raw_conn.query(r#" + SELECT memes.title, COUNT(*) FROM invocation_records + INNER JOIN memes ON meme_id = memes.id GROUP BY memes.title ORDER BY COUNT(*) DESC LIMIT 1; @@ -439,6 +456,9 @@ pub fn stats(conn: &PgConnection) -> Result<Stats> { most_popular_named_meme: most_requested_meme, most_popular_named_meme_count: most_requested_meme_count as usize, + most_popular_random_meme: most_random_meme, + most_popular_random_meme_count: most_random_meme_count as usize, + most_popular_meme_overall: most_invoked_meme, most_popular_meme_overall_count: most_invoked_meme_count as usize, }) |