#include <stdio.h>

##include "books.qh"

##struct book tmpbook ;

main()
{
##ingres "tcc_admin"

/* get the important stuff from the books database */
##retrieve (tmpbook.email=books.email, tmpbook.borrower=books.borrower,
##          tmpbook.title=books.title, tmpbook.borrowed=books.borrowed,
##          tmpbook.tcc_cn=books.tcc_cn, tmpbook.due=books.due)
##  where books.due <= date("today")
##{
    /* we only watn LATE books */
    if ( strncmp(tmpbook.borrowed, tmpbook.due, 11) != 0 )
    {
        printf("TITLE %s\t\n", tmpbook.title) ;
        printf("TCC_CN %d\t\n", tmpbook.tcc_cn) ;
        printf("NAME %s\t\n", tmpbook.borrower) ;
        printf("EMAIL %s\t\n", tmpbook.email) ;
        printf("BORROWED %s\t\n", tmpbook.borrowed) ;
        printf("DUE %s\t\n", tmpbook.due) ;
        printf("\n") ;
    }
##}

##exit
}