12345678910111213141516171819202122232425262728 |
- import pymysql
- connection = pymysql.connect(
- host="rm-bp1k5853td1r25g3n690.mysql.rds.aliyuncs.com",# 数据库IP地址,内网地址
- # host="rm-bp1k5853td1r25g3ndo.mysql.rds.aliyuncs.com", # 数据库IP地址,外网地址
- port=3306, # 端口号
- user="crawler", # mysql用户名
- passwd="crawler123456@", # mysql用户登录密码
- db="piaoquan-crawler", # 数据库名
- # 如果数据库里面的文本是utf8编码的,charset指定是utf8
- charset="utf8mb4")
- m_con = connection.cursor(cursor=pymysql.cursors.DictCursor)
- sql = 'select * from crawler_config where id =6'
- a = m_con.execute(sql)
- data = m_con.fetchall()
- # 关闭数据库连接
- connection.close()
- n_data = data[0]
- emo = n_data['config']
- a = '😝'
- em = eval(emo)['emoji']
- if a in em:
- print(11111)
- else:
- print(222222)
|