Back-end script to handle the database

[karastoyanov]

Python script which manages some basic operations:

• Creates new category/subcategory
• Insert new products

[karastoyanov]

Changes to the database:

• New column added in subcategories --> parent_category

322ef3d

[karastoyanov]

Changes to the database:

• products table updated with:
  alter table products add column total_value numeric(10, 2) generated always as (single_price * quantity) stored;

• in products table colums single_price and quantity changed to numeric value

462cf1b

[karastoyanov]

Minor issues fixed with 299d073

[karastoyanov]

Last update: d6fe7f3

Commit is pushed in development branch

• Comments re-format
• Integrated init functionality, based on user input

"""INIT THE OPERATION"""
create_new_subcategory()

print("What are you going to do?\n")
print("1.Create a new category\n2.Create a new subcategory\n3.Create a new item\n")
user_input = int(input())


if user_input == 1:
    create_new_category()
elif user_input == 2:
    create_new_subcategory()
elif user_input == 3:
    create_new_items()