def main():
global conn
all_tables = dict((x.name, x) for x in model.Base.metadata.sorted_tables)
all_tablenames = sorted(all_tables.iterkeys())
opts, args = parser.parse_args()
common.init_logging(opts.sql)
if opts.list_tables:
list_tables(all_tablenames)
return
if len(args) == 0:
parser.error("which database?")
if len(args) > 1:
parser.error("too many command-line arguments")
dburl = args[0]
engine = sa.create_engine(dburl)
conn = engine.connect()
if opts.create_all:
create_all(all_tables)
if opts.create_tables:
create_tables(opts.create_tables, all_tables)
if opts.monthly:
monthly(opts.year, opts.month)
if (opts.year or opts.month) and not opts.monthly:
parser.error("must pass --monthly when using --year and --month")
if opts.delete_access:
delete_old_records(model.Access.__table__, opts.delete_access,
"--delete-access")
if opts.delete_referer:
delete_old_records(model.Referer.__table__, opts.delete_referer,
"--delete-referer")
def main():
global conn
all_tables = dict((x.name, x)
for x in model.Base.metadata.sorted_tables)
all_tablenames = sorted(all_tables.iterkeys())
opts, args = parser.parse_args()
common.init_logging(opts.sql)
if opts.list_tables:
list_tables(all_tablenames)
return
if len(args) == 0:
parser.error("which database?")
if len(args) > 1:
parser.error("too many command-line arguments")
dburl = args[0]
engine = sa.create_engine(dburl)
conn = engine.connect()
if opts.create_all:
create_all(all_tables)
if opts.create_tables:
create_tables(opts.create_tables, all_tables)
if opts.monthly:
monthly(opts.year, opts.month)
if (opts.year or opts.month) and not opts.monthly:
parser.error(
"must pass --monthly when using --year and --month")
if opts.delete_access:
delete_old_records(model.Access.__table__, opts.delete_access,
"--delete-access")
if opts.delete_referer:
delete_old_records(model.Referer.__table__, opts.delete_referer,
"--delete-referer")
def main():
global conn
opts, args = parser.parse_args()
common.init_logging(opts.log_sql)
if opts.debug:
log.setLevel(logging.DEBUG)
if len(args) != 1:
parser.error("wrong number of command-line arguments")
dburl = args[0]
engine = sa.create_engine(dburl)
log.debug("Starting")
conn = engine.connect()
check_table(model.Access.__table__)
if opts.legacy:
log.debug("Checking LegacyAccess table")
check_table(model.LegacyAccess.__table__)
def main():
global conn
opts, args = parser.parse_args()
common.init_logging(opts.log_sql)
if opts.debug:
log.setLevel(logging.DEBUG)
if len(args) != 1:
parser.error("wrong number of command-line arguments")
dburl = args[0]
engine = sa.create_engine(dburl)
log.debug("Starting")
conn = engine.connect()
check_table(model.Access.__table__)
if opts.legacy:
log.debug("Checking LegacyAccess table")
check_table(model.LegacyAccess.__table__)
def main():
global conn
opts, args = parser.parse_args()
common.init_logging(opts.log_sql)
if opts.debug:
log.setLevel(logging.DEBUG)
if len(args) != 3:
parser.error("wrong number of command-line arguments")
site, dburl, output_dir = args
engine = sa.create_engine(dburl)
log.debug("Starting")
conn = engine.connect()
output_dir = Path(output_dir)
output_dir.mkdir()
output_raw_referers(site, conn, output_dir, True)
output_raw_referers(site, conn, output_dir, False)
output_search_terms(site, conn, output_dir)
def main():
global conn
opts, args = parser.parse_args()
common.init_logging(opts.log_sql)
if opts.debug:
log.setLevel(logging.DEBUG)
if len(args) != 3:
parser.error("wrong number of command-line arguments")
site, dburl, output_dir = args
engine = sa.create_engine(dburl)
log.debug("Starting")
conn = engine.connect()
output_dir = Path(output_dir)
output_dir.mkdir()
output_raw_referers(site, conn, output_dir, True)
output_raw_referers(site, conn, output_dir, False)
output_search_terms(site, conn, output_dir)
def main():
global conn
opts, args = parser.parse_args()
common.init_logging(opts.log_sql)
if len(args) != 2:
parser.error("wrong number of command-line arguments")
site = args[0]
dburl = args[1]
engine = sa.create_engine(dburl)
conn = engine.connect()
if opts.year and opts.month:
date = datetime.date(opts.year, opts.month, 1)
summarize_month(site, date)
elif opts.year or opts.month:
parser.error("must specify both --year and --month or neither")
else:
current = today.replace(day=1)
previous = current - relativedelta(months=1)
summarize_month(site, current)
summarize_month(site, previous)
def main():
global conn
opts, args = parser.parse_args()
common.init_logging(opts.log_sql)
if len(args) != 2:
parser.error("wrong number of command-line arguments")
site = args[0]
dburl = args[1]
engine = sa.create_engine(dburl)
conn = engine.connect()
if opts.year and opts.month:
date = datetime.date(opts.year, opts.month, 1)
summarize_month(site, date)
elif opts.year or opts.month:
parser.error("must specify both --year and --month or neither")
else:
current = today.replace(day=1)
previous = current - relativedelta(months=1)
summarize_month(site, current)
summarize_month(site, previous)
