parms.add_argument('--outfile', dest='outfile', default='springforward.html')
parms.add_argument('--csvfile', dest='csvfile', default='springforward.csv')
# Do global setup
globals.setup(parms)
curs = globals.curs
conn = globals.conn
# See if we have the data needed to run and build the base part of the query
if parms.basedate.upper().startswith('M'):
basemonth = int(parms.basedate[1:])
if not isMonthFinal(basemonth, curs):
sys.exit(1)
basepart = 'monthstart = "%s" AND entrytype = "M"' % getMonthStart(basemonth, curs)
friendlybase = 'New Members on %s' % neaten(getMonthEnd(basemonth))
msgdate = datetime.date(globals.today.year, basemonth+1, 1)
if basemonth == 12:
msgdate = datetime.date(globals.today.year, 1, 1)
else:
basedate = cleandate(parms.basedate)
if not haveDataFor(basedate, curs):
sys.exit(1)
basepart = 'asof = "%s"' % basedate
msgdate = datetime.datetime.strptime(basedate, '%Y-%m-%d')
friendlybase = 'New Members on %s' % neaten(msgdate)
msgbase = dateAsWords(msgdate)
# Figure out the end date and build that part of the query
yesterday = cleandate('yesterday')
if parms.finaldate.upper().startswith('M'):
dest='csvfile',
default='springforward.csv')
# Do global setup
globals.setup(parms)
curs = globals.curs
conn = globals.conn
# See if we have the data needed to run and build the base part of the query
if parms.basedate.upper().startswith('M'):
basemonth = int(parms.basedate[1:])
if not isMonthFinal(basemonth, curs):
sys.exit(1)
basepart = 'monthstart = "%s" AND entrytype = "M"' % getMonthStart(
basemonth, curs)
friendlybase = 'New Members on %s' % neaten(getMonthEnd(basemonth))
msgdate = datetime.date(globals.today.year, basemonth + 1, 1)
if basemonth == 12:
msgdate = datetime.date(globals.today.year, 1, 1)
else:
basedate = cleandate(parms.basedate)
if not haveDataFor(basedate, curs):
sys.exit(1)
basepart = 'asof = "%s"' % basedate
msgdate = datetime.datetime.strptime(basedate, '%Y-%m-%d')
friendlybase = 'New Members on %s' % neaten(msgdate)
msgbase = dateAsWords(msgdate)
# Figure out the end date and build that part of the query
yesterday = cleandate('yesterday')
if parms.finaldate.upper().startswith('M'):
# Handle parameters
parms = tmparms.tmparms()
parms.parser.add_argument("--basedate", dest='basedate', default='M5')
parms.parser.add_argument("--finaldate", dest='finaldate', default='M6')
parms.parse()
conn = dbconn.dbconn(parms.dbhost, parms.dbuser, parms.dbpass, parms.dbname)
curs = conn.cursor()
# See if we have the data needed to run and build the base part of the query
if parms.basedate.upper().startswith('M'):
basemonth = int(parms.basedate[1:])
if not isMonthFinal(basemonth, curs):
sys.exit(1)
basepart = 'monthstart = "%s" AND entrytype = "M"' % getMonthStart(basemonth, curs)
msgdate = getMonthEnd(basemonth)
friendlybase = 'New Members on %s' % neaten(msgdate)
else:
basedate = cleandate(parms.basedate)
if not haveDataFor(basedate, curs):
sys.exit(1)
basepart = 'asof = "%s"' % basedate
msgdate = datetime.datetime.strptime(basedate, '%Y-%m-%d')
friendlybase = 'New Members on %s' % neaten(msgdate)
msgbase = dateAsWords(msgdate)
# Figure out the end date and build that part of the query
yesterday = cleandate('yesterday')
if parms.finaldate.upper().startswith('M'):
finalmonth = int(parms.finaldate[1:])
msgdate = getMonthEnd(finalmonth)