1 ! Copyright (C) 2009 Doug Coleman.
2 ! See http://factorcode.org/license.txt for BSD license.
3 USING: accessors continuations db db.sqlite db.tuples db.types
4 io.directories io.files.temp kernel io.streams.string calendar
5 debugger combinators.smart sequences ;
8 TUPLE: account account-id account-name email ;
10 : <account> ( account-name -- account )
15 { "account-name" "ACCOUNT_NAME" VARCHAR +user-assigned-id+ }
16 { "email" "EMAIL" VARCHAR }
19 TUPLE: site site-id url up? changed? last-up error last-error ;
21 : <site> ( url -- site )
26 { "site-id" "SITE_ID" INTEGER +db-assigned-id+ }
27 { "url" "URL" VARCHAR }
28 { "up?" "UP" BOOLEAN }
29 { "changed?" "CHANGED" BOOLEAN }
30 { "last-up" "LAST_UP" TIMESTAMP }
31 { "error" "ERROR" VARCHAR }
32 { "last-error" "LAST_ERROR" TIMESTAMP }
35 TUPLE: watching-site account-name site-id ;
37 : <watching-site> ( account-name site-id -- watching-site )
42 watching-site "WATCHING_SITE" {
43 { "account-name" "ACCOUNT_NAME" VARCHAR +user-assigned-id+ }
44 { "site-id" "SITE_ID" INTEGER +user-assigned-id+ }
47 TUPLE: reporting-site email url up? changed? last-up? error last-error ;
51 : set-notify-site-watchers ( site new-up? -- site )
52 [ over up?>> = [ t >>changed? ] unless ] keep >>up? ;
54 : site-good ( site -- )
55 t set-notify-site-watchers
61 : site-bad ( site error -- )
62 [ error. ] with-string-writer >>error
63 f set-notify-site-watchers
67 : sites-to-report ( -- seq )
68 "select account.email, site.url, site.up, site.changed, site.last_up, site.error, site.last_error from account, site, watching_site where account.account_name = watching_site.account_name and site.site_id = watching_site.site_id and site.changed = '1'" sql-query
69 [ [ reporting-site boa ] input<sequence ] map
70 "update site set changed = 'f';" sql-command ;
72 : insert-site ( url -- site )
73 <site> dup select-tuple [ ] [ dup t >>up? insert-tuple ] ?if ;
75 : insert-account ( account-name -- ) <account> insert-tuple ;
77 : find-sites ( -- seq ) f <site> select-tuples ;
79 : select-account/site ( username url -- account site )
80 insert-site site-id>> ;
84 : watch-site ( username url -- )
85 select-account/site <watching-site> insert-tuple ;
87 : unwatch-site ( username url -- )
88 select-account/site <watching-site> delete-tuples ;
90 : watching-sites ( username -- sites )
91 f <watching-site> select-tuples
92 [ site-id>> site new swap >>site-id select-tuple ] map ;