def main():
try:
# parse command line arguments
filename_catalog, filename_sales = _parse_command_line_parameters()
# print(filename_catalog, filename_sales)
# load sales data
sales = load_sales_data(filename_sales)
catalog_by_item_id = load_catalog_by_item_id(filename_catalog)
# calculate and print summaries
print_summary(sales)
print_sales_amount_by_city(sales)
print_sales_amount_by_category(sales, catalog_by_item_id)
return 0
except Exception as e:
print("Error: " + str(e))
raise
def main():
if len(sys.argv) < 4:
print("Usage: {} <catalog-file.csv> <sales-file.csv> <output.db>".format(sys.argv[0]))
return 2
# TODO: check if files exist and are readable
catalog_by_item_id = load_catalog_by_item_id(sys.argv[1])
sales = load_sales_data(sys.argv[2])
db_filename = sys.argv[3]
with sqlite3.connect(db_filename, isolation_level=None) as connection:
print("Connection opened")
create_tables(connection)
print("Tables created")
import_catalog_into_db(catalog_by_item_id, connection)
print("Catalog imported")
import_sales_into_db(sales, connection)
def main():
try:
# parse command line arguments
filename_catalog, filename_sales = _parse_command_line_parameters()
print(filename_catalog, filename_sales)
# load sales data
sales = load_sales_data(filename_sales)
catalog_by_item_id = load_catalog_by_item_id(filename_catalog)
# calculate and print summaries
print_summary(sales)
print_sales_amount_by_city(sales)
print_sales_amount_by_categories(sales, catalog_by_item_id)
return 0
except Exception as e:
print("Error: " + str(e))
raise
def main():
if len(sys.argv) < 4:
print(
"Usage: {} <catalog-file.csv> <sales-file.csv> <output.db>".format(
sys.argv[0]))
return 2
# TODO: check if files exist and are readable
catalog_by_item_id = load_catalog_by_item_id(sys.argv[1])
sales = load_sales_data(sys.argv[2])
db_filename = sys.argv[3]
with sqlite3.connect(db_filename, isolation_level=None) as connection:
print("Connection opened")
create_tables(connection)
print("Tables created")
import_catalog_into_db(catalog_by_item_id, connection)
print("Catalog imported")
import_sales_into_db(sales, connection)
def main():
try:
file_catalog, file_sales = _parse_cmd_line_arg()
sales = load_sale_data(file_sales)
print_summary(sales)
catalog_by_item_id = load_catalog_by_item_id(file_catalog)
# TODO: calculate and print sales report per category
print_category_report(catalog_by_item_id, sales)
# TODO: calculate and print sale report per city
print_city_report(sales)
# TODO: calculate and print sales report per date-hour
print_date_hour_report(sales)
return 0
except Exception as e:
print("Error: " + str(e))
return 1
def main():
try:
file_catalog, file_sales, db_filename = _parse_cmd_line_arg()
sales = load_sale_data(file_sales)
catalog_by_item_id = load_catalog_by_item_id(file_catalog)
with sqlite3.connect(db_filename, isolation_level=None) as connection:
cursor = connection.cursor()
cursor.execute("pragma foreign_keys=on;")
print("Connection opened")
create_tables(connection)
print("Tables created")
import_catalog_into_db(catalog_by_item_id, connection)
print("Catalog imported")
import_sales_into_db(sales, connection)
print("Sales imported")
return 0
except Exception as e:
print("Error: " + str(e))
return 1
