def new_voucher():
voucher = Voucher('LUO20')
voucher.product_id = 1
voucher.discount_fixed_amount = 8.00
voucher.max_redemptions = 2
voucher.no_of_redemptions = 1
voucher.redeem_by = datetime.strptime('8-8-2020', '%d-%m-%Y')
return voucher
def member_order(new_product):
order = Order()
first_order_item = OrderItem()
first_order_item.quantity = 1
first_order_item.product_id = 2
first_order_item.variation_id = 3
first_order_item.start_date = datetime.strptime('1-4-2020', '%d-%m-%Y')
first_order_item.end_date = datetime.strptime('8-4-2020', '%d-%m-%Y')
second_order_item = OrderItem()
second_order_item.quantity = 1
second_order_item.product_id = 3
second_order_item.variation_id = 2
second_order_item.start_date = datetime.strptime('1-4-2020', '%d-%m-%Y')
second_order_item.end_date = datetime.strptime('8-4-2020', '%d-%m-%Y')
third_order_item = OrderItem()
third_order_item.quantity = 1
third_order_item.product_id = 4
third_order_item.variation_id = 2
third_order_item.start_date = datetime.strptime('1-4-2020', '%d-%m-%Y')
third_order_item.end_date = datetime.strptime('8-4-2020', '%d-%m-%Y')
voucher = Voucher('LUO20')
voucher.product_id = 1
voucher.discount_fixed_amount = 8.00
order.order_items = []
order.vouchers = []
order.user_id = 2
order.id = 43
order.order_items.append(first_order_item)
order.order_items.append(second_order_item)
order.order_items.append(third_order_item)
order.vouchers.append(voucher)
return order
def member_order():
order = Order()
first_order_item = OrderItem()
first_order_item.quantity = 1
first_order_item.product_id = 2
first_order_item.variation_id = 3
first_order_item.start_date = datetime.datetime.strptime(
'2020-8-1 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
first_order_item.end_date = datetime.datetime.strptime(
'2020-8-8 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
second_order_item = OrderItem()
second_order_item.quantity = 1
second_order_item.product_id = 5
second_order_item.variation_id = 2
second_order_item.start_date = datetime.datetime.strptime(
'2020-8-1 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
second_order_item.end_date = datetime.datetime.strptime(
'2020-8-8 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
third_order_item = OrderItem()
third_order_item.quantity = 1
third_order_item.product_id = 4
third_order_item.variation_id = 2
third_order_item.start_date = datetime.datetime.strptime(
'2020-8-1 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
third_order_item.end_date = datetime.datetime.strptime(
'2020-8-8 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
fourth_order_item = OrderItem()
fourth_order_item.variation_id = 2
fourth_order_item.product_id = 3
fourth_order_item.quantity = 1
fourth_order_item.start_date = datetime.datetime.strptime(
'2020-8-1 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
fourth_order_item.end_date = datetime.datetime.strptime(
'2020-8-8 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
fifth_order_item = OrderItem()
fifth_order_item.variation_id = 2
fifth_order_item.product_id = 6
fifth_order_item.quantity = 1
fifth_order_item.start_date = datetime.datetime.strptime(
'2020-8-1 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
fifth_order_item.end_date = datetime.datetime.strptime(
'2020-8-8 00:00:00', '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
voucher = Voucher('HAO20')
voucher.product_id = 3
order.order_items = []
order.vouchers = []
order.user_id = 2
order.id = 43
order.order_items.append(first_order_item)
order.order_items.append(second_order_item)
order.order_items.append(third_order_item)
order.order_items.append(fourth_order_item)
order.order_items.append(fifth_order_item)
order.vouchers.append(voucher)
return order
variation1 = Variation('M')
variation1.product_id = x
variation1.price = 20
variation1.retail_price = variation1.price * 3
variation1.stock = 1
variation2 = Variation('L')
variation2.product_id = x
variation2.price = 30
variation2.retail_price = variation2.price * 3
variation2.stock = 1
variation3 = Variation('XL')
variation3.product_id = x
variation3.price = 40
variation3.retail_price = variation3.price * 3
variation3.stock = 1
db.session.add(variation)
db.session.add(variation1)
db.session.add(variation2)
db.session.add(variation3)
voucher = Voucher('HAO20')
voucher.discount_fixed_amount = 5
voucher.product_id = 1
voucher.redeem_by = datetime.strptime('13-4-2020', '%d-%m-%Y')
voucher2 = Voucher('LUO20')
voucher2.discount_fixed_amount = 20
voucher2.product_id = 2
voucher2.redeem_by = datetime.strptime('18-4-2020', '%d-%m-%Y')
db.session.add(voucher)
db.session.add(voucher2)
db.session.commit()
variation1.stock = 1
variation2 = Variation('L')
variation2.product_id = x
variation2.price = 30
variation2.stock = 1
variation3 = Variation('XL')
variation3.product_id = x
variation3.price = 40
variation3.stock = 1
db.session.add(variation)
db.session.add(variation1)
db.session.add(variation2)
db.session.add(variation3)
voucher = Voucher('HAO20')
voucher.discount_fixed_amount = 5
voucher.product_id = 3
voucher.redeem_by = datetime.strptime('13-4-2020', '%d-%m-%Y')
voucher2 = Voucher('LUO20')
voucher2.discount_fixed_amount = 20
voucher2.product_id = 5
voucher2.redeem_by = datetime.strptime('18-4-2020', '%d-%m-%Y')
subtype = SubscriptionType(duration=1, price=10)
subtype2 = SubscriptionType(duration=6, price=40)
usersubscription = UserSubscription()
usersubscription.user_id = 2
usersubscription.start_date = datetime.now()
usersubscription.end_date = datetime.strptime('06-02-2020 05:58:00',
'%d-%m-%Y %H:%M:%S')
usersubscription.subscription_type = subtype
db.session.add(max_no_products_per_order)
db.session.add(min_duration_of_rental)
def init_database():
db = AC().db
# Create the database and the database table
db.create_all()
member = Role("member")
admin = Role("admin")
user = User("*****@*****.**", "1q2w3e4r")
user.email_confirmed = True
user2 = User("*****@*****.**", "1q2w3e4r")
user3 = User("*****@*****.**", "1q2w3e4r")
user4 = User("*****@*****.**", "1q2w3e4r")
user.role = admin
user2.email_confirmed = True
user2.subscribed = True
user3.email_confirmed = True
user3.subscribed = True
user4.email_confirmed = False
max_no_products_per_month = ConfigValues('max_no_products_per_month', 20)
max_no_free_products_adayalite_user = ConfigValues(
'max_no_free_products_adayalite_user', 4)
max_no_of_items_per_order_adayalifestyle = ConfigValues(
'max_no_of_items_per_order_adayalifestyle', 4)
max_no_products_per_order = ConfigValues('max_no_products_per_order', 4)
min_duration_of_rental = ConfigValues('min_duration_of_rental', 4)
max_duration_of_rental = ConfigValues('max_duration_of_rental', 7)
max_no_of_vouchers = ConfigValues('max_no_of_vouchers', 2)
MAIL_USERNAME = ConfigValues('MAIL_USERNAME', '*****@*****.**')
MAIL_PASSWORD = ConfigValues('MAIL_PASSWORD', 'adaya1234')
MAIL_SERVER = ConfigValues('MAIL_SERVER', 'smtp.gmail.com')
MAIL_PORT = ConfigValues('MAIL_PORT', 465)
MAIL_DEFAULT_SENDER = ConfigValues('MAIL_DEFAULT_SENDER',
'*****@*****.**')
EMAIL_PASSWORD_RESET_SECRET_KEY = ConfigValues(
'EMAIL_PASSWORD_RESET_SECRET_KEY', 'Thisisasecret!')
SIB_KEY = ConfigValues('SIB_KEY', 'gzryVUPZHa1GW7n6')
subtype = SubscriptionType(plan='Adaya Lite', price=10)
subtype2 = SubscriptionType(plan='Adaya Premium', price=40)
usersubscription = UserSubscription()
usersubscription.user_id = 2
usersubscription.current_start_date = datetime.now()
usersubscription.current_end_date = datetime.strptime(
'2020-09-06 05:58:00', '%Y-%m-%d %H:%M:%S')
usersubscription.subscription_type = subtype
usersubscription2 = UserSubscription()
usersubscription2.user_id = 3
usersubscription2.current_start_date = datetime.now()
usersubscription2.current_end_date = datetime.strptime(
'2020-08-06 05:58:00', '%Y-%m-%d %H:%M:%S')
usersubscription2.subscription_type = subtype2
voucher = Voucher('HAO20')
voucher.discount_fixed_amount = 100
voucher.product_id = 3
voucher.redeem_by = datetime.strptime('2020-8-13 00:00:00',
'%Y-%m-%d %H:%M:%S')
voucher2 = Voucher('LUO20')
voucher2.discount_fixed_amount = 8.00
voucher2.product_id = 1
voucher2.redeem_by = datetime.strptime('2020-8-13 00:00:00',
'%Y-%m-%d %H:%M:%S')
for x in range(1, 11):
variation = Variation('S')
variation.product_id = x
variation.price = 10
variation.stock = 1
variation1 = Variation('M')
variation1.product_id = x
variation1.price = 20
variation1.stock = 1
variation2 = Variation('L')
variation2.product_id = x
variation2.price = 30
variation2.stock = 1
variation3 = Variation('XL')
variation3.product_id = x
variation3.price = 40
variation3.stock = 1
db.session.add(variation)
db.session.add(variation1)
db.session.add(variation2)
db.session.add(variation3)
db.session.add(max_no_products_per_order)
db.session.add(max_no_products_per_month)
db.session.add(max_no_free_products_adayalite_user)
db.session.add(max_no_of_items_per_order_adayalifestyle)
db.session.add(min_duration_of_rental)
db.session.add(max_duration_of_rental)
db.session.add(max_no_of_vouchers)
db.session.add(MAIL_USERNAME)
db.session.add(MAIL_PASSWORD)
db.session.add(MAIL_SERVER)
db.session.add(MAIL_PORT)
db.session.add(MAIL_DEFAULT_SENDER)
db.session.add(EMAIL_PASSWORD_RESET_SECRET_KEY)
db.session.add(SIB_KEY)
db.session.add(voucher)
db.session.add(voucher2)
db.session.add(member)
db.session.add(user)
db.session.add(user2)
db.session.add(user3)
db.session.add(user4)
db.session.add(subtype)
db.session.add(subtype2)
db.session.add(usersubscription)
db.session.add(usersubscription2)
food_category = ProductCategory('food')
clothes_category = ProductCategory('cloth')
food_article = ArticleCategory('food-article')
clothes_article = ArticleCategory('cloth-article')
status = ArticleStatus('draft')
order_status = OrderStatus('completed')
db.session.add(order_status)
db.session.add(food_article)
db.session.add(clothes_article)
db.session.add(food_category)
db.session.add(clothes_category)
for x in range(10):
product = Product('Haoluo')
article = Article(randomString(10))
order = Order()
order_item = OrderItem()
order_item.quantity = 1
order_item.variation_id = 2
order_item.start_date = datetime.strptime('2020-4-1 00:00:00',
'%Y-%m-%d %H:%M:%S')
order_item.end_date = datetime.strptime('2020-4-8 00:00:00',
'%Y-%m-%d %H:%M:%S')
order.order_items = []
order.order_items.append(order_item)
article_category = food_article
category = food_category
if x % 2 == 0:
category = clothes_category
article_category = clothes_article
product.category = category
article.category = article_category
article.status = status
db.session.add(order)
db.session.add(product)
db.session.add(order_item)
db.session.add(article)
db.session.commit()
yield db
db.drop_all()
