function resetCache()
{
@unlink(RUNTIME_ROOT . '/cache/access_token.json.php');
@unlink(RUNTIME_ROOT . '/cache/jsapi_ticket.json.php');
@unlink(RUNTIME_ROOT . '/cache/config.json.php');
support\DbDeployer::resetMysql();
include_once DIR_ROOT . '/wlight/library/core/support/Deployer.class.php';
support\Deployer::initConfig();
}
// Create table
try {
$link->exec("CREATE TABLE IF NOT EXISTS `{$tag}` (\n `date` date COLLATE {$collation} NOT NULL COMMENT '日期',\n PRIMARY KEY(`date`)\n ) COMMENT='功能统计'");
$link->exec("CREATE TABLE IF NOT EXISTS `{$message}` (\n `wechat_id` char(30) COLLATE {$collation} NOT NULL COMMENT 'FromUserName',\n `create_time` timestamp NOT NULL DEFAULT 0 COMMENT 'CreateTime',\n `msgType` varchar(10) COLLATE {$collation} NOT NULL DEFAULT 'text' COMMENT 'MsgType',\n `content` text COLLATE {$collation} NOT NULL DEFAULT '' COMMENT '留言消息',\n `extra` text COLLATE {$collation} NOT NULL DEFAULT '' COMMENT '额外信息',\n PRIMARY KEY(`wechat_id`, `create_time`)\n ) COMMENT='留言统计'");
$link->exec("CREATE TABLE IF NOT EXISTS `{$cacheMsg}` (\n `key` varchar(50) COLLATE {$collation} NOT NULL COMMENT '关键字',\n `target` varchar(50) COLLATE {$collation} NOT NULL COMMENT '搜索对象',\n `type` char(10) COLLATE {$collation} NOT NULL COMMENT '消息类型',\n `priority` int NOT NULL DEFAULT 0 COMMENT '优先级',\n PRIMARY KEY(`key`, `type`)\n ) COMMENT='消息缓存'");
$link->exec("CREATE TABLE IF NOT EXISTS `{$cacheRetry}` (\n `key` char(40) COLLATE {$collation} NOT NULL COMMENT '重排key',\n `reply` text COLLATE {$collation} NOT NULL DEFAULT '' COMMENT '回复内容',\n `priority` int NOT NULL DEFAULT 0 COMMENT '优先级',\n PRIMARY KEY(`key`)\n ) COMMENT='重试缓存'");
$link->exec("CREATE TABLE IF NOT EXISTS `{$cacheOauth}` (\n `id` char(10) COLLATE {$collation} NOT NULL COMMENT '编号',\n `url` text COLLATE {$collation} NOT NULL DEFAULT '' COMMENT '重定向url',\n `extra` text COLLATE {$collation} NOT NULL DEFAULT '' COMMENT '额外信息',\n `result` text COLLATE {$collation} NOT NULL DEFAULT '' COMMENT '查询响应缓存',\n `priority` int NOT NULL DEFAULT 0 COMMENT '优先级',\n PRIMARY KEY(`id`)\n ) COMMENT='Oauth缓存'");
$link = null;
return true;
} catch (\PDOException $e) {
$link = null;
$msg = $e->getMessage();
echo "Permission denied in creating tables.({$msg})";
return false;
}
}
public static function resetMysql()
{
$cacheMsg = self::$cacheMsg;
$cacheRetry = self::$cacheRetry;
$cacheOauth = self::$cacheOauth;
$helper = new DbHelper();
$helper->set(DbHelper::TYPE, 'mysql');
$link = $helper->getConnector();
$link->exec("DELETE FROM `{$cacheMsg}` WHERE 1");
$link->exec("DELETE FROM `{$cacheRetry}` WHERE 1");
$link->exec("DELETE FROM `{$cacheOauth}` WHERE 1");
}
}
DbDeployer::init();
