test.py 927 B

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