def main():
# 获取明天的农历日期（农历2018年七月初一）
lu_date = LunarDate.tomorrow()
tom_day = f"{fix_zero(lu_date.month)}{fix_zero(lu_date.day)}"
# 查询数据
b_sql = f"select modify_time,name,relation,lunar_birth from birth where lunar_birth='{tom_day}'"
b_data = m_load_data(b_sql)
if len(b_data) > 0:
# 生成邮件
msg_root = MIMEMultipart('related')
msg_root['From'] = Header("Remind", 'utf-8')
msg_root['To'] = "Y.G"
subject = f'明日生日提醒-记得关注'
msg_root['Subject'] = Header(subject, 'utf-8')
msg_alternative = MIMEMultipart('alternative')
b_info = ""
for item in b_data:
b_info += "<tr>"
for var2 in range(0, 4):
b_info += f"<td>{item[var2]}</td>"
b_info += "</tr>"
mail_msg = f"""
{CSS_INFO}
<h2>这些小可爱明天要过生日了，记得送祝福哦！！！</h2>
<table class="pure-table pure-table-horizontal">
<thead>
<tr>
<th>-_-</th>
<th>Name</th>
<th>relation</th>
<th>birth</th>
</tr>
</thead>
<tbody>
{b_info}
</tbody>
</table>
<br/>
<hr size=1 color='gray' width='600' align='left'/>
"""
msg_alternative.attach(MIMEText(mail_msg, 'html', 'utf-8'))
msg_root.attach(msg_alternative)
# 发送邮件
send_email(msg_root)
else:
print("明天没有过生日的人")
def test_create_specific_dates(self):
today = LunarDate.today()
self.assertEqual(1, LCalendars.delta(LunarDate.tomorrow(), today))
self.assertEqual(-1, LCalendars.delta(LunarDate.yesterday(), today))
self.assertEqual(5, LCalendars.delta(today.after(5), today))
self.assertEqual(-5, LCalendars.delta(today.before(5), today))