thinkphp6.0封装数据库及缓存模型

项目中的thinkphp6.0appcommonModel.php

<?php
/**
 * 数据库及缓存模型
 */
namespace appcommon;

use appindexserverRedisServer;
use thinkdbBaseQuery;
use thinkfacadeDb;
use thinkfacadeLog;

class Model
{
    protected $name;

    /** 查询多条数据信息(批量查询方法), 缓存中未找到时去数据库查询
     * @param $ids
     * @return array
     */
    public function getCacheList($ids)
    {
        // 整理查询的数据, 并存入 $key
        $keys = [];
        foreach ($ids as $id) {
            if($id)
            {
                $keys[$id] = $id;
            }
        }
        if (empty($keys)) {
            return [];
        }

        // 准备结果集
        $result = [];


        /** 在Redis中查询数据
         * @var Redis $redis
         */
        $redis = Instance::getInstance(RedisServer::class);
        if ($redis) {
            //创建管道，批量获取
            $pip = $redis->pipeline();
            foreach ($keys as $id) {
                $pip->hGetAll(static::class . ':' . $id);
            }
            if ($caches = $pip->exec()) {
                foreach ($caches as $value) {
                    if ($value) {
                        // 在$key中删除掉已查询到的数据
                        unset($keys[$value['id']]);
                        $result[$value['id']] = $value;
                    }
                }
            }
        }

        // 如果 $keys 不为空, 则表示有数据未从缓存中查询到, 在 mysql 中进行查询并缓存到Redis
        if ($keys) {
            foreach ($this->query()->whereIn('id', array_values($keys))->cursor() as $item) {
                $redis->hMSet(static::class . ':' . $item['id'], $item);
                $redis->expire(static::class . ':' . $item['id'], 60); //有效期10分钟
                $result[$item['id']] = $item;
            }
        }
        return $result;
    }


    /** 查询单条数据信息, 缓存中未找到时去数据库查询
     * @param $id
     * @param null $showKey
     * @return mixed|null
     */
    public function getCacheInfo($id, $showKey = null)
    {
        $redis = Instance::getInstance(RedisServer::class);
        if ($redis) {
            if ($cache = $redis->hGetAll(static::class . ':' . $id)) {
                return $showKey ? $cache[$showKey] : $cache;
            }
        }
        $data = $this->query()->where('id', $id)->find();
        if ($data) {
            $redis->hMSet(static::class . ':' . $id, $data);
            $redis->expire(static::class . ':' . $id, 60); //有效期10分钟
            return $showKey ? $data[$showKey] : $data;
        }
        return null;
    }


    /** 查询多条数据信息, 缓存中未找到时去数据库查询
     * @param $ids
     * @return array
     */
    public function getCacheDataList($ids)
    {
        $result = [];
        foreach ($ids as $id) {
            $result[$id] = $this->getCacheInfo($id);
        }
        return $result;
    }


    /** 根据ID执行单条数据查询, 并存储到Redis
     * @param $id
     * @return null
     */
    public function setCacheInfo($id)
    {
        $redis = Instance::getInstance(RedisServer::class);
        $data = $this->query()->where('id', $id)->find();
        if ($data) {
            $redis->hMSet(static::class . ':' . $id, $data);
            $redis->expire(static::class . ':' . $id, 600); //有效期10分钟
            return $data;
        }
        return null;
    }



    /** 数据库中根据ID查询信息(不经过缓存)
     * @param $id
     * @param string $field
     * @return mixed
     */
    public function getById($id, $field = '*')
    {
        $where = [
            'id' => $id,
            'is_delete' => 0
        ];
        return $this->query()->where($where)->field($field)->find();
    }



    /** 数据库中根据ID查询用户信息(不经过缓存)
     * @param $id
     * @param string $field
     * @return mixed
     */
    public function getByUserId($userId)
    {
        $where = [
            'user_id' => $userId,
            'is_delete' => 0
        ];
        return $this->query()->where($where)->find();
    }

    /**
     * @return BaseQuery
     */
    public function query()
    {
        return Db::name($this->name);
    }



    /** 创建$query对象
     * @return 	hinkModel
     */
    public static function createQuery($field = '*', $where = null, $order = null)
    {
        $query = Instance::getInstance(static::class)->query()->field($field);
        if ($where) {
            $query->where($where);
        }
        if ($order) {
            $query->order($order);
        }
        return $query;
    }


    /** 创建查询$query 并添加查询条件, (where, order, limit, field)
     * 不直接调用, 只通过该类下的 select等方法调用
     * @param null $where
     * @param array $order
     * @param null $limit
     * @param null $field
     * @return BaseQuery
     */
    public function createSelect($where = null, $order = [], $limit = null, $field = null)
    {
        $query = $this->query();
        if ($where) {
            $query->where($where);
        }
        if ($field) {
            $query->field($field);
        }
        if ($order) {
            foreach ($order as $key => $value) {
                $query->order($key, $value);
            }
        }
        if ($limit) {
            if (is_integer($limit)) {
                $query->limit($limit);
            } else {
                $query->limit($limit[0], $limit[1]);
            }
        }
        return $query;
    }


    /** 多条数据查询方法
     * @param null $where
     * @param array $order
     * @param null $limit
     * @param null $format
     * @param null $field
     * @return array
     */
    public function select($where = null, $order = [], $limit = null, $format = null, $field = null)
    {
        $result = [];
        $query = $this->createSelect($where, $order, $limit, $field);
        if ($dataList = $query->select()) {
            foreach ($dataList as $value) {
                $result[] = $format ? call_user_func_array($format, [$value]) : $value;
            }
        }
        return $result;
    }


    /** 单条数据查询方法
     * @param null $where
     * @param array $order
     * @param null $limit
     * @param null $field
     * @return mixed
     */
    public function find($where = null, $order = [], $limit = null, $field = null)
    {
        return $this->createSelect($where, $order, $limit, $field)->find();
    }

    public function selectIndex($where = null, $order = [], $limit = null, $format = null, $field = null)
    {
        $result = [];
        $query = $this->createSelect($where, $order, $limit, $field);
        if ($dataList = $query->select()) {
            foreach ($dataList as $value) {
                $result[$value['id']] = $format ? call_user_func_array($format, [$value]) : $value;
            }
        }
        return $result;
    }


    /** 根据ID删除数据(软删除)
     * @param $id
     * @return mixed
     */
    public function deleteById($id)
    {
        return $this->query()->where(['id' => $id])->update(['is_delete' => 1]);
    }


    /** 根据where条件删除数据
     * @param $where
     * @return mixed
     */
    public function deleteByWhere($where)
    {
        return $this->query()->where($where)->delete();
    }


    /** 插入数据
     * 自动条件创建时间和更新时间
     * @param $data
     * @param array $exception
     * @return false
     * @throws Exception
     */
    public function create($data, $exception = [])
    {
        try {
            $data['create_time'] = time();
            $data['update_time'] = time();
            $id = $this->query()->insertGetId($data);

            if ($id) {
                $data['id'] = $id;
                return $data;
            } else {
                return false;
            }
        } catch (Exception $e) {
            Log::record(Db::getLastSql(), 'SQL-ERROR');
            Log::record($e->getMessage(), 'SQL-ERROR');
            if ($exception) {
                throw new Exception($exception);
            }
            return false;
        }
    }

    /**
     * 根据数组和key 获取ids
     * @param array $arr
     * @param null $key
     * @return bool|string
     */
    public function getIds($arr = [], $key = null)
    {
        if (empty($arr) || empty($key)) {
            return false;
        }
        $res = [];
        foreach ($arr as $k => $v) {
            $res[] = $v[$key];
        }
        $res = implode(',', $res);
        return $res;
    }


    /** 更新数据信息
     * 自动添加更新时间
     * @param $where
     * @param $data
     * @param array $exception
     * @return false
     * @throws Exception
     */
    public function update($where, $data, $exception = [])
    {
        try {
            if (!is_array($where)) {
                $where = [
                    'id' => $where
                ];
            }
            $data['update_time'] = time();
            return $this->query()->where($where)->update($data);
        } catch (Exception $e) {
            Log::record(Db::getLastSql(), 'SQL-ERROR');
            Log::record($e->getMessage(), 'SQL-ERROR');
            if ($exception) {
                throw new Exception($exception);
            }
            return false;
        }
    }

}