{"action":"created","issue":{"url":"https://api.github.com/repos/top-think/framework/issues/373","repository_url":"https://api.github.com/repos/top-think/framework","labels_url":"https://api.github.com/repos/top-think/framework/issues/373/labels{/name}","comments_url":"https://api.github.com/repos/top-think/framework/issues/373/comments","events_url":"https://api.github.com/repos/top-think/framework/issues/373/events","html_url":"https://github.com/top-think/framework/issues/373","id":191836174,"number":373,"title":"好多坑，数据库驱动","user":{"login":"jackboys000","id":10386560,"avatar_url":"https://avatars.githubusercontent.com/u/10386560?v=3","gravatar_id":"","url":"https://api.github.com/users/jackboys000","html_url":"https://github.com/jackboys000","followers_url":"https://api.github.com/users/jackboys000/followers","following_url":"https://api.github.com/users/jackboys000/following{/other_user}","gists_url":"https://api.github.com/users/jackboys000/gists{/gist_id}","starred_url":"https://api.github.com/users/jackboys000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jackboys000/subscriptions","organizations_url":"https://api.github.com/users/jackboys000/orgs","repos_url":"https://api.github.com/users/jackboys000/repos","events_url":"https://api.github.com/users/jackboys000/events{/privacy}","received_events_url":"https://api.github.com/users/jackboys000/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":12,"created_at":"2016-11-27T01:23:54Z","updated_at":"2016-12-10T12:06:10Z","closed_at":null,"body":"查询字段为数据库关键字的时候比如字段为group，model就会出错，组装sql语句的时候不会加上  `   引号"},"comment":{"url":"https://api.github.com/repos/top-think/framework/issues/comments/266203412","html_url":"https://github.com/top-think/framework/issues/373#issuecomment-266203412","issue_url":"https://api.github.com/repos/top-think/framework/issues/373","id":266203412,"user":{"login":"jackboys000","id":10386560,"avatar_url":"https://avatars.githubusercontent.com/u/10386560?v=3","gravatar_id":"","url":"https://api.github.com/users/jackboys000","html_url":"https://github.com/jackboys000","followers_url":"https://api.github.com/users/jackboys000/followers","following_url":"https://api.github.com/users/jackboys000/following{/other_user}","gists_url":"https://api.github.com/users/jackboys000/gists{/gist_id}","starred_url":"https://api.github.com/users/jackboys000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jackboys000/subscriptions","organizations_url":"https://api.github.com/users/jackboys000/orgs","repos_url":"https://api.github.com/users/jackboys000/repos","events_url":"https://api.github.com/users/jackboys000/events{/privacy}","received_events_url":"https://api.github.com/users/jackboys000/received_events","type":"User","site_admin":false},"created_at":"2016-12-10T12:06:10Z","updated_at":"2016-12-10T12:06:10Z","body":"@liu21st \r\n我不知道有没有人用sqlite做开发，是sqlite不是mysql，问题反馈，不知道你们有没有试过。\r\nmysql 的语句会带反引号，sqlite生成的语句不会带反引号\r\n另外，上面这个方法\r\n```\r\n$data = Request::instance()->post();\r\n$data['`group`']=$data['group'];\r\nunset($data['group']);\r\n```\r\n这样根本不行\r\ndatabase.php\r\n```\r\n<?php\r\n// +----------------------------------------------------------------------\r\n// | ThinkPHP [ WE CAN DO IT JUST THINK ]\r\n// +----------------------------------------------------------------------\r\n// | Copyright (c) 2006~2016 http://thinkphp.cn All rights reserved.\r\n// +----------------------------------------------------------------------\r\n// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )\r\n// +----------------------------------------------------------------------\r\n// | Author: liu21st <liu21st@gmail.com>\r\n// +----------------------------------------------------------------------\r\n\r\nreturn [\r\n    // 数据库类型\r\n    'type'           => 'sqlite',\r\n    // 服务器地址\r\n    'hostname'       => '',\r\n    // 数据库名\r\n    'database'       => ROOT_PATH . 'application' . DS . '#%73d8898c319532a4.db',\r\n    // 用户名\r\n    'username'       => '',\r\n    // 密码\r\n    'password'       => '',\r\n    // 端口\r\n    'hostport'       => '',\r\n    // 连接dsn\r\n    'dsn'            => '',\r\n    // 数据库连接参数\r\n    'params'         => [],\r\n    // 数据库编码默认采用utf8\r\n    'charset'        => 'utf8',\r\n    // 数据库表前缀\r\n    'prefix'         => '',\r\n    // 数据库调试模式\r\n    'debug'          => true,\r\n    // 数据库部署方式:0 集中式(单一服务器),1 分布式(主从服务器)\r\n    'deploy'         => 0,\r\n    // 数据库读写是否分离 主从式有效\r\n    'rw_separate'    => false,\r\n    // 读写分离后 主服务器数量\r\n    'master_num'     => 1,\r\n    // 指定从服务器序号\r\n    'slave_no'       => '',\r\n    // 是否严格检查字段是否存在\r\n    'fields_strict'  => false,\r\n    // 数据集返回类型 array 数组 collection Collection对象\r\n    'resultset_type' => 'array',\r\n    // 是否自动写入时间戳字段\r\n    'auto_timestamp' => true,\r\n    // 是否需要进行SQL性能分析\r\n    'sql_explain'    => false,\r\n];\r\n```\r\ntp版本，就是现在github上的\r\n用法sql语句字段没有反引号，反正我的电脑公司电脑一个样不行"}}
{"actor":{"display_login":"jackboys000"}}