summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJesse Luehrs <doy@tozt.net>2018-11-10 01:08:59 -0500
committerJesse Luehrs <doy@tozt.net>2018-11-10 01:08:59 -0500
commit26584b1cffa33eab6660c1673b6d87239402ab9e (patch)
tree09844a6faf0e350d48df367f56e4b8406bfa0b1f
parentbd1e965f936c9fe652bd940c1f12e3327f06a222 (diff)
downloadlastfm-query-26584b1cffa33eab6660c1673b6d87239402ab9e.tar.gz
lastfm-query-26584b1cffa33eab6660c1673b6d87239402ab9e.zip
add some views
-rw-r--r--src/db.rs12
1 files changed, 12 insertions, 0 deletions
diff --git a/src/db.rs b/src/db.rs
index 97522d9..efc1a88 100644
--- a/src/db.rs
+++ b/src/db.rs
@@ -9,6 +9,18 @@ const SCHEMA: &'static str = "
name varchar(1024) NOT NULL,
timestamp integer(11) NOT NULL
);
+ CREATE VIEW `yearly_tracks` as
+ SELECT *
+ FROM tracks
+ WHERE strftime('%s') - timestamp < 60*60*24*365;
+ CREATE VIEW `monthly_tracks` as
+ SELECT *
+ FROM tracks
+ WHERE strftime('%s') - timestamp < 60*60*24*30;
+ CREATE VIEW `weekly_tracks` as
+ SELECT *
+ FROM tracks
+ WHERE strftime('%s') - timestamp < 60*60*24*7;
";
pub struct DB {