diff options
author | Jesse Luehrs <doy@tozt.net> | 2018-11-10 01:08:59 -0500 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2018-11-10 01:08:59 -0500 |
commit | 26584b1cffa33eab6660c1673b6d87239402ab9e (patch) | |
tree | 09844a6faf0e350d48df367f56e4b8406bfa0b1f /src/db.rs | |
parent | bd1e965f936c9fe652bd940c1f12e3327f06a222 (diff) | |
download | lastfm-query-26584b1cffa33eab6660c1673b6d87239402ab9e.tar.gz lastfm-query-26584b1cffa33eab6660c1673b6d87239402ab9e.zip |
add some views
Diffstat (limited to 'src/db.rs')
-rw-r--r-- | src/db.rs | 12 |
1 files changed, 12 insertions, 0 deletions
@@ -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 { |