From 26584b1cffa33eab6660c1673b6d87239402ab9e Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Sat, 10 Nov 2018 01:08:59 -0500 Subject: add some views --- src/db.rs | 12 ++++++++++++ 1 file changed, 12 insertions(+) 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 { -- cgit v1.2.3