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) != 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)