import smtplib, ssl
import Utils.configuration_file_service as config_service
#Gmail password saved locally
password = config_service.getProperty(
section_name=config_service.GMAIL_SECTION_NAME,
property_name=config_service.GM_PASSWORD_NAME)
port = 465 # For SSL
smtp_server = "smtp.gmail.com"
sender_email = "*****@*****.**" # Enter your address
receiver_email_1 = "*****@*****.**"
receiver_email_2 = "*****@*****.**"
message = """\
Subject: Crius update
Hi Yuan,
Password is now protected. Please use below to update your local properties section.
Thanks
Crius autotrade terminal
"""
context = ssl.create_default_context()
with smtplib.SMTP_SSL(smtp_server, port, context=context) as server:
server.login(sender_email, password)
" is correct")
elif db_data_size + suspend_day_count > standard_size:
logger.error("Data duplicate for " + code + " between date " +
str(start_date) + " and " + str(end_date))
except Exception as e:
logger.error(e)
logger.error("fetching " + code + " for table " + base_name + " " +
str(start_date) + " " + str(end_date) + " failed.")
logger = logging_util.get_logger("data_integrity_check",
file_name="data_integrity_check")
logger.setLevel(logging.DEBUG)
engine = create_engine(config_service.getDefaultDB())
token = config_service.getProperty(
section_name=config_service.TOKEN_SECTION_NAME,
property_name=config_service.TS_TOKEN_NAME)
pro = ts.pro_api(token)
# 956-917
# get_suspended_day_count(pro,'000001.SZ','19900101','19941231')
# check_integrity_worker("daily","daily_1995_1999","000062.SZ","19950101","19991231",engine=engine)
check_integrity_daily_data_table("daily",
engine=engine,
pro=pro,
skipping_year_start=[1990])
# df = pro.daily(trade_date='19910411',ts_code='000001.SZ',fields='ts_code,trade_date')
# print(df)
def test_getProperty(self):
self.assertIsNotNone(
config_service.getProperty(
section_name=config_service.TOKEN_SECTION_NAME,
property_name=config_service.TS_TOKEN_NAME))
