from models.product_dao import Product, Dimension

Dimension.add_dimension("item")
Dimension.add_dimension("box")
Dimension.add_dimension("package")

Product.add_product('apple', 'sweet apple', 1.5, 1)
Product.add_product('potato', 'ukrainian potato', 5.5, 2)
Product.add_product('apple', 'red apple', 10.0, 3)
Product.add_product('orange', 'tasty orange', 1.2, 1)
Product.add_product('banana', 'yellow banana', 7.0, 2)
Product.add_product('lemon', 'yellow lemon', 11.0, 3)
Product.add_product('tomato', 'red tomato', 2.5, 1)
Product.add_product('mango', 'ugly mango', 1.8, 1)
Product.add_product('apple', 'russian apple', 0.5, 1)
Product.add_product('orange', 'italian orange', 15.0, 3)
Product.add_product('apple', 'sweet apple', 11.3, 3)
Product.add_product('banana', 'brazilian banana', 12.1, 3)
Product.add_product('tomato', 'ukrainian tomato', 5.8, 2)
Product.add_product('mango', 'fresh mango', 7.5, 2)
Product.add_product('lemon', 'indian lemon', 4.4, 2)

# You can check, that all products and dimensions was added. You should comment text above, and uncomment below and run
# this script one more time.

#d = Dimension.get_all_dimensions()
#for i in d:
#    print i
#
#p = Product.get_all_products()
#for i in p:
from models.product_dao import Product, Dimension
from models.product_stock_dao import ProductStock
from models.region_dao import RegionDao
from models.role_dao import RoleDao
from models.user_dao import UserDao, UserLevel, Security
from models.order_dao import Order, OrderProduct, OrderStatus,DeliveryType
from models.product_stock_dao import ProductStock

from datetime import date

# This file can fill you DB store_db
# just run this file

Dimension.add_dimension("Items", 1)
Dimension.add_dimension("Box", 5)
Dimension.add_dimension("Package", 10)

Product.add_product('apple', 'sweet apple', 1.5)
Product.add_product('potato', 'ukrainian potato', 5.5)
Product.add_product('apple', 'red apple', 10.0)
Product.add_product('orange', 'tasty orange', 1.2)
Product.add_product('banana', 'yellow banana', 7.0)
Product.add_product('lemon', 'yellow lemon', 11.0)
Product.add_product('tomato', 'red tomato', 2.5)
Product.add_product('mango', 'ugly mango', 1.8)
Product.add_product('apple', 'russian apple', 0.5)
Product.add_product('orange', 'italian orange', 15.0)
Product.add_product('apple', 'sweet apple', 11.3)
Product.add_product('banana', 'brazilian banana', 12.1)
Product.add_product('tomato', 'ukrainian tomato', 5.8)
Product.add_product('mango', 'fresh mango', 7.5)
def create_dimension(name, id):
    validate_name(name)
    validate_dimension_id(id)
    Dimension.add_dimension(name, id)