def get_jd_total():
jd_comments_summary = CommentSummary.get(CommentSummary.source == '京东')
jd_total = jd_comments_summary.default_good + jd_comments_summary.star_one + jd_comments_summary.star_two + \
jd_comments_summary.star_three + jd_comments_summary.star_four + jd_comments_summary.star_five
jd_good_count = jd_comments_summary.star_four + jd_comments_summary.star_five
jd_general_cont = jd_comments_summary.star_two + jd_comments_summary.star_three
jd_bad_count = jd_comments_summary.star_one
jd_cal_total = jd_comments_summary.star_one + jd_comments_summary.star_two + jd_comments_summary.star_three + \
jd_comments_summary.star_four + jd_comments_summary.star_five
jd_good_rate = calculate_percentage(jd_cal_total, jd_good_count)
jd_models_total = 0
for ms in ModelSummary.select().where(ModelSummary.source == '京东'):
jd_models_total += ms.default_good + ms.star_one + ms.star_two + ms.star_three + ms.star_four + ms.star_five
Total.create(
source='京东',
total=jd_total,
all_models_total=jd_models_total,
good_rate=jd_good_rate,
default_good=jd_comments_summary.default_good,
good_count=jd_good_count,
general_count=jd_general_cont,
bad_count=jd_bad_count,
star_one=jd_comments_summary.star_one,
star_two=jd_comments_summary.star_two,
star_three=jd_comments_summary.star_three,
star_four=jd_comments_summary.star_four,
star_five=jd_comments_summary.star_five
)
def insert_jd_comment_summary(comment_summary: dict, shop: Shop):
try:
cs = CommentSummary.get(source=shop.source,
is_official=shop.is_official)
update_jd_summary_data(cs, comment_summary)
except CommentSummary.DoesNotExist:
CommentSummary.create(source=shop.source,
is_official=shop.is_official,
total=parse_jd_count_str(
comment_summary['commentCountStr']),
good_rate=str(comment_summary['goodRate'] * 100),
default_good=parse_jd_count_str(
comment_summary['defaultGoodCountStr']),
star_one=comment_summary['score1Count'],
star_two=comment_summary['score2Count'],
star_three=comment_summary['score3Count'],
star_four=comment_summary['score4Count'],
star_five=comment_summary['score5Count'])
def get_mishop_total():
mishop_comments_summary = CommentSummary.get(CommentSummary.source == '小米商城')
mishop_good_count = mishop_comments_summary.star_three + mishop_comments_summary.star_four + \
mishop_comments_summary.star_five
mishop_general_cont = mishop_comments_summary.star_two
mishop_bad_count = mishop_comments_summary.star_one
Total.create(
source='小米商城',
total=mishop_comments_summary.total,
all_models_total=mishop_comments_summary.total,
good_rate=mishop_comments_summary.good_rate,
default_good=mishop_comments_summary.default_good,
good_count=mishop_good_count,
general_count=mishop_general_cont,
bad_count=mishop_bad_count,
star_one=mishop_comments_summary.star_one,
star_two=mishop_comments_summary.star_two,
star_three=mishop_comments_summary.star_three,
star_four=mishop_comments_summary.star_four,
star_five=mishop_comments_summary.star_five
)
def get_sn_total():
sn_comments_summary = CommentSummary.get(CommentSummary.source == '苏宁')
sn_good_count = sn_comments_summary.star_four + sn_comments_summary.star_five
sn_general_cont = sn_comments_summary.star_two + sn_comments_summary.star_three
sn_bad_count = sn_comments_summary.star_one
sn_models_total = 0
for ms in ModelSummary.select().where(ModelSummary.source == '苏宁'):
sn_models_total += ms.total
Total.create(
source='苏宁',
total=sn_comments_summary.total,
all_models_total=sn_models_total,
good_rate=sn_comments_summary.good_rate,
default_good=sn_comments_summary.default_good,
good_count=sn_good_count,
general_count=sn_general_cont,
bad_count=sn_bad_count,
star_one=sn_comments_summary.star_one,
star_two=sn_comments_summary.star_two,
star_three=sn_comments_summary.star_three,
star_four=sn_comments_summary.star_four,
star_five=sn_comments_summary.star_five
)