#!/usr/bin/python

from os import system
from mitsfs import dexdb

def main():
    d=dexdb()

    (n,) = d.cursor.execute("select count(generation) from log where stamp > (timestamp 'now' - interval '5 minutes')")

    if not n:
        dexnames = d.save()
        titles = tuple(d.cursor.execute('select count(distinct title_id) from title natural join book where not withdrawn'))
        books = tuple(d.cursor.execute('select count(distinct book_id) from book where not withdrawn'))
        
        if dexnames:
            system('diff -U 0 %s %s'
                   ' | zwrite -n -d -q -c mitsfs-auto -i pinkdex'
                   ' -O AUTO -s "%d titles, %d books saved"'
                   % (dexnames + titles + books))


if __name__ == '__main__':
    main()