数据库和缓存的封装12-4

import  pymysql
from configgg.conf import MYSQL_INFO,log
import redis
class MysqlUtil:#整个类加载在内存里，一种操作
  def __init__(self):
      self.connection=pymysql.connect(**MYSQL_INFO)
      self.cursor=self.get_mysql_cursor()#游标从连接里面来的
      #获取连接
  def get_mysql_cursor(self):
      return self.__connection.cursor()
  def execute(self,sql):
      return self.cursor.execute(sql)
  def fetchall(self):
      return self.cursor.fetchall()
  def fechone(self):
      return self.cursor.fetchone()
  def fechmany(self):
      return self.cursor.fetmany()
  def __del__(self):
      self.cursor.close()
      self.__connection.close()

class Redis:
    def __init__(self):
        self.redis=redis.Redis(**REDIS_INFO)
        #string 这个场景唯一，不会出现key相同重复的场景
        #hash KEY、field、value
    def get(self,key):
        pass
    def set(self,key,value):
        pass
    def hget(self,key,field):
        pass
    def hset(self,key,field,value):
        pass