: !/bin/sh

dodate="03/02/2010"

runisql <<SQLCMD0
	create temp table wbusertmp
	(
		dstamp datetime year to day,
		failed integer,
		good integer
	) with no log;
	insert into wbusertmp
	select dtstamp, 0, count(*) from wbuserlog
	where failed = 0
          and dtstamp >= (date("$dodate") - 31)
          and dtstamp <= (date("$dodate") + 1)
	group by 1;
	insert into wbusertmp
	select dtstamp, count(*), 0 from wbuserlog
	where failed != 0
          and dtstamp >= (date("$dodate") - 31)
          and dtstamp <= (date("$dodate") + 1)
	group by 1;
	select dstamp date, sum(failed) failed, sum(good) good from wbusertmp
	group by 1
	order by 1;
SQLCMD0