django数据库settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'crm',
        'USER': 'sm_log',
        'PASSWORD': 'vR49MNW7',
        'HOST': '182.254.128.241',
        'PORT': '4171'
    }
}

sql = “SELECT * FROM easy_log”
data = pd.read_sql(sql, engine_ht)

import pandas as pd
from sqlalchemy import create_engine
from sql_history.settings import DATABASES

engine_ht = create_engine("mysql+pymysql://{}:{}@{}:{}/{}".format(
    DATABASES['default']['USER'],
    DATABASES['default']['PASSWORD'],
    DATABASES['default']['HOST'],
    DATABASES['default']['PORT'],
    DATABASES['default']['NAME'],
), connect_args={"charset": "utf8"})

import pandas as pd
from sqlalchemy import create_engine

sql = "SELECT prod_id, prod_name FROM Products"
#engine_ht = create_engine("mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8".format("sm01", "y63TAftg", "58cb57c164977.sh.cdb.myqcloud.com", 4171, "stu"))
engine_ht = create_engine("mysql+pymysql://{}:{}@{}:{}/{}".format("sm01", "y63TAftg", "58cb57c164977.sh.cdb.myqcloud.com", 4171, "stu"), connect_args={"charset": "utf8"})


df = pd.read_sql(sql, engine_ht)
print(df)

# DATABASES = {
#     'default': {
#         'ENGINE': 'django.db.backends.mysql',
#         'NAME': 'stu', #数据库名，非表名和连接名
#         'USER': 'sm01',
#         'PASSWORD': 'y63TAftg',
#         'HOST': '58cb57c164977.sh.cdb.myqcloud.com',
#         'PORT': '4171'
#     }
# }
# engine_ht = create_engine("mysql+pymysql://{}:{}@{}:{}/{}".format(
#     DATABASES['default']['USER'],
#     DATABASES['default']['PASSWORD'],
#     DATABASES['default']['HOST'],
#     DATABASES['default']['PORT'],
#     DATABASES['default']['NAME'],
# ), connect_args={"charset": "utf8"})