def init_products():
# 判斷資料庫是否存在
result = init_db()
if result:
init_data = [Products(name='芒果炒雞柳',
product_image_url='https://i.imgur.com/SBDmHrJ.jpg',
price=300,
description='炒雞柳好吃!'),
Products(name='東坡肉',
product_image_url='https://i.imgur.com/JCBXVEq.jpg',
price=310,
description='東坡肉好吃！'),
Products(name='嫩煎牛排',
product_image_url='https://i.imgur.com/gGhxvM6.jpg',
price=320,
description='牛排好吃！'),
Products(name='蒜泥白玉蒸蝦',
product_image_url='https://i.imgur.com/MhAb8nA.jpg',
price=330,
description='蝦子好吃！'),
Products(name='橙汁魚排',
product_image_url='https://i.imgur.com/t1svMMN.png',
price=290,
description='魚排好吃！'),
Products(name='蒜苗炒松阪牛',
product_image_url='https://i.imgur.com/JZssJkM.jpg',
price=340,
description='松阪牛好吃！')
]
db_session.bulk_save_objects(init_data)
db_session.commit()
def create_and_save_with_names(model: Union[Type[Client], Type[ProductArea]], names: List[str]) -> None:
new_instances = []
for name in names:
if model.query.filter(model.name == name).count() == 0:
new_instances.append(model(name=name))
db_session.bulk_save_objects(new_instances)
db_session.commit()
def resort_feature_requests(new_priority: int, client_id: int) -> int:
client_feature_requests: List[
FeatureRequest] = get_all_feature_requests_by_client_id(client_id)
if len(client_feature_requests) == 0:
return 1
if new_priority > client_feature_requests[-1].client_priority:
return client_feature_requests[-1].client_priority + 1
else:
for feature_request in client_feature_requests:
if feature_request.client_priority >= new_priority:
feature_request.client_priority += 1
db_session.bulk_save_objects(client_feature_requests)
db_session.commit()
return new_priority
def init_products():
# init db
result = init_db()
if result:
init_data = [
Products(name='Coffee',
product_image_url='https://i.imgur.com/DKzbk3l.jpg',
price=150,
description=
'nascetur ridiculus mus. Donec quam felis, ultricies'),
Products(
name='Tea',
product_image_url='https://i.imgur.com/PRTxyhq.jpg',
price=120,
description='adipiscing elit. Aenean commodo ligula eget dolor'
),
Products(name='Cake',
price=180,
product_image_url='https://i.imgur.com/PRm22i8.jpg',
description='Aenean massa. Cum sociis natoque penatibus')
]
db_session.bulk_save_objects(init_data)
db_session.commit()
def create_and_save_fake_feature_requests() -> None:
if FeatureRequest.query.count() > 0:
return
new_feature_requests: List[FeatureRequest] = []
client_ids: List[int] = [c.id for c in Client.query.all()]
product_area_ids: List[int] = [pa.id for pa in ProductArea.query.all()]
development_provider = mimesis.Development()
datetime_provider = mimesis.Datetime()
for counter in range(1, 5):
for client_id in client_ids:
new_feature_requests.append(FeatureRequest(
title=f"{development_provider.database()} {random.choice(('problem', 'optimization', 'feature'))}",
description=development_provider.software_license(),
client_id=client_id,
client_priority=counter,
target_date=datetime.datetime.strptime(datetime_provider.date(2019, 2021), "%m/%d/%Y").date(),
product_area_id=random.choice(product_area_ids)
))
db_session.bulk_save_objects(new_feature_requests)
db_session.commit()