前后端分离 接口管理神器——Rap本地搭建
我这里要用做mockserver的就是rap了，rap结合了团队管理，项目管理，文档编写、Mock.js、可视化、接口过渡、文档历史版本（赞）、mock插件（线上线下切换就只需要注释一句代码就OK），支持本地部署。
由于官网讲解的太模糊了 ，而且图也不配一个 让人觉得好寒蝉啊！
展示地址：http://rap.taobao.org/org/index.do 感觉如果担心数据接口安全问题，那么就需要走下一步了，搭建属于自己团队的服务器！
参考搭建地址1：http://blog.csdn.net/xinxin19881112/article/details/52279778 （这个讲解的比较全了 虽然有几处是不完善的，待我给他补上）
参考搭建地址2：http://www.cnblogs.com/dothin/p/5361883.html （这个讲解的比较全了 虽然有几处是不完善的，待我给他补上）
感觉是不是天下文章一大抄的感觉，不过也不影响我们的进程。
我把用到的安装包统一放到百度云盘中，文件名称：rap搭建所需要的工具包
接下来该我补充上面文章中所欠缺说明的东西！
我先秀一下自己的本地成果先：
这是需要本地启动的三个服务；
本地访问的界面效果
自己小测试了一下下
以下说明全部补充的是：参考搭建地址1
1。当链接好本地数据库后需要执行一段脚本，创建本地的数据库！
CREATE DATABASE IF NOT EXISTS rap_db DEFAULT CHARSET utf8 COLLATE utf8_general_ci; USE rap_db; /************************************************** * * * account module * * * **************************************************/ /** * user table */ CREATE TABLE tb_user ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, account VARCHAR(32) NOT NULL COMMENT '账户名 account name', password VARCHAR(128) NOT NULL COMMENT '密码 password', name VARCHAR(256) NOT NULL COMMENT '名字/昵称 name/nickname', email VARCHAR(256) NOT NULL COMMENT 'email', create_date TIMESTAMP NOT NULL COMMENT '创建日期 create date' DEFAULT now(), is_locked_out INT(1) NOT NULL COMMENT '用户是否锁定 is the user locked out' DEFAULT 0, is_hint_enabled INT(1) NOT NULL COMMENT '是否开启新手引导 is user hint enabled' DEFAULT 1, last_login_date DATETIME NOT NULL COMMENT '最近登录 last login date', incorrect_login_attempt INT(10) NOT NULL COMMENT '错误登录次数，登录成功后会重置为0 count of incorrect login attempts, will be set to 0 after any succesful login' DEFAULT 0, realname VARCHAR(128) NOT NULL COMMENT '真实姓名' DEFAULT '', emp_id VARCHAR(45) NULL COMMENT '工号，可选', mock_num INT(10) NOT NULL COMMENT 'mock次数，用于记录该用户所创建的接口被调用的mock次数。 mock num, used for record mock API invokation count' DEFAULT 0 ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * role table * roles instruction: * user - every registered shuold have this role * rd - research and development engineering * qa - quality engineering * pm - project manager * op - operation manager * admin - administrator * god - super admin */ CREATE TABLE tb_role ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(16) NOT NULL COMMENT '角色名称 role name' ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * user role table */ CREATE TABLE tb_role_and_user ( user_id INT(10) NOT NULL, role_id INT(10) NOT NULL, PRIMARY KEY (user_id, role_id), FOREIGN KEY (user_id) REFERENCES tb_user (id), FOREIGN KEY (role_id) REFERENCES tb_role (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /************************************************** * * * project module * * * **************************************************/ /** * parameter table */ CREATE TABLE tb_parameter ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(256) NULL COMMENT '参数含义 parameter name', identifier VARCHAR(256) NULL COMMENT '变量名/参数标识符 parameter identifier', data_type VARCHAR(32) NULL COMMENT '数据类型 data type', remark TEXT NULL COMMENT '备注/mock数据等 remark/mock data', expression VARCHAR(128) NULL COMMENT '备用字段：表达式 backup column:expression', mock_data TEXT NULL COMMENT '备用字段:mock数据 backup column:mock data' ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * project table * workspace_mode 1-vss(default) 2-svn * stage 1-design 2-developing 3-debug */ CREATE TABLE tb_project ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, `version` VARCHAR(128) NOT NULL COMMENT '版本号 version no.' DEFAULT '0.0.0.1', name VARCHAR(128) NOT NULL COMMENT '项目名称 project name', create_date TIMESTAMP NOT NULL COMMENT '创建日期 create date' DEFAULT now(), user_id INT(10) NOT NULL COMMENT '创建人ID, project author id', introduction TEXT NULL COMMENT '项目描述 project introduction', workspace_mode INT(10) NOT NULL COMMENT '工作区提交模式(类VSS or SVN)，暂时弃用了。 Workspace submit mode, deprecated.' DEFAULT 1, stage INT(10) NOT NULL COMMENT '项目阶段，暂时废弃;project stage, temply deprecated. 1-design 2-developing 3-debug' DEFAULT 1, project_data LONGTEXT NULL COMMENT '项目JSON数据，存放当前最新的版本。 project JSON data, saved the newest version of the project', group_id INT(10) NULL COMMENT '分组ID group id', related_ids VARCHAR(128) NOT NULL COMMENT '路由ID，用于指定与哪些项目共享mock数据; router id, used for specify sharing data with which projects.' DEFAULT '', update_time DATETIME NOT NULL COMMENT '更新时间 update time', mock_num INT NOT NULL COMMENT 'mock次数 mock num' DEFAULT 0, access_type TINYINT NOT NULL COMMENT '权限控制, 10普通, 0私有' DEFAULT 10, FOREIGN KEY (user_id) REFERENCES tb_user (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * user list and user table * used for creating multiple to multiple mapping * access_level: * 1 - read * 2 - read&write * 3 - read&write&manage */ CREATE TABLE tb_project_and_user ( project_id INT(10) NOT NULL, user_id INT(10) NOT NULL, access_level INT NOT NULL DEFAULT 1, PRIMARY KEY (project_id, user_id), FOREIGN KEY (project_id) REFERENCES tb_project (id), FOREIGN KEY (user_id) REFERENCES tb_user (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * module table */ CREATE TABLE tb_module ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, project_id INT(10) NOT NULL, name VARCHAR(256) NOT NULL, introduction VARCHAR(128) NULL, FOREIGN KEY (project_id) REFERENCES tb_project (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * page table */ CREATE TABLE tb_page ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(56) NOT NULL, module_id INT(10) NOT NULL, introduction TEXT NULL, template VARCHAR(128) NULL, FOREIGN KEY (module_id) REFERENCES tb_module (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * action table * request_type: * 1 - get * 2 - post * 3 - ajax get * 4 - ajax post */ CREATE TABLE tb_action ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(256) NOT NULL, description TEXT NULL, /* request block */ request_type INT NOT NULL COMMENT '请求类型get/post/put/delete等等 request type' DEFAULT 1, /** request_type = 99, mount type **/ request_url TEXT NULL, disable_cache TINYINT NOT NULL COMMENT '禁用Mock缓存 disable mock cache' DEFAULT 0, /* response block */ response_template TEXT NULL COMMENT '响应模板地址, 暂时弃用。 response template address, temply deprecated.' ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * action and page table * used for creating multiple to multiple mapping */ CREATE TABLE tb_action_and_page ( action_id INT(10) NOT NULL, page_id INT(10) NOT NULL, FOREIGN KEY (action_id) REFERENCES tb_action (id), FOREIGN KEY (page_id) REFERENCES tb_page (id), PRIMARY KEY (action_id, page_id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * parameter and parameter mapping * complex_parameter has so many parameters(List<Map> or Map) */ CREATE TABLE tb_complex_parameter_list_mapping ( complex_parameter_id INT(10) NOT NULL, parameter_id INT(10) NOT NULL, PRIMARY KEY (complex_parameter_id, parameter_id), FOREIGN KEY (complex_parameter_id) REFERENCES tb_parameter (id), FOREIGN KEY (parameter_id) REFERENCES tb_parameter (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * parameter and action's request mapping */ CREATE TABLE tb_request_parameter_list_mapping ( action_id INT(10) NOT NULL, parameter_id INT(10) NOT NULL, PRIMARY KEY (action_id, parameter_id), FOREIGN KEY (action_id) REFERENCES tb_action (id), FOREIGN KEY (parameter_id) REFERENCES tb_parameter (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * parameter and action's response mapping */ CREATE TABLE tb_response_parameter_list_mapping ( action_id INT(10) NOT NULL, parameter_id INT(10) NOT NULL, PRIMARY KEY (action_id, parameter_id), FOREIGN KEY (action_id) REFERENCES tb_action (id), FOREIGN KEY (parameter_id) REFERENCES tb_parameter (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /************************************************** * * * workspace module * * * **************************************************/ /** * workspace, deprecated 工作区，暂时未使用 */ CREATE TABLE tb_workspace ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, project_id INT(10) NOT NULL, user_id INT NOT NULL, create_date TIMESTAMP NOT NULL DEFAULT now(), update_date DATETIME NOT NULL, project_data LONGTEXT NOT NULL, project_data_original LONGTEXT NOT NULL, FOREIGN KEY (project_id) REFERENCES tb_project (id), FOREIGN KEY (user_id) REFERENCES tb_user (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * workspace save, deprecated 工作区保存草稿，暂时未使用 */ CREATE TABLE tb_workspace_save ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, workspace_id INT(10) NOT NULL, update_date DATETIME NOT NULL, project_data LONGTEXT NOT NULL, FOREIGN KEY (workspace_id) REFERENCES tb_workspace (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * check in table * every API document submit saved here, used for version control. * 每一次提交记录在这里，用于版本管理和回滚控制 * workspaceMode 1-VSS 2-SVN */ CREATE TABLE tb_check_in ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, create_date TIMESTAMP NOT NULL DEFAULT now(), tag VARCHAR(128) NULL COMMENT 'tag标签 暂时未使用 deprecated', user_id INT(10) NOT NULL COMMENT '提交人 submit user id', project_id INT(10) NOT NULL COMMENT '提交的项目ID submit project id', description TEXT NULL COMMENT '提交描述 submit description', version VARCHAR(128) NOT NULL COMMENT '版本号 version no.', project_data LONGTEXT NOT NULL COMMENT '项目JSON数据 project json data', workspace_mode INT(10) NOT NULL COMMENT '工作区模式(弃用) workspace mode(deprecated)', log TEXT NULL COMMENT '更新日志，用于存储与最近一个版本的对比差异。暂时未使用。update log, used for calculate versions differences. Deprecated.', FOREIGN KEY (user_id) REFERENCES tb_user (id), FOREIGN KEY (project_id) REFERENCES tb_project (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * user settings table * 用户配置表 */ CREATE TABLE tb_user_settings ( user_id INT(10) NOT NULL, `key` VARCHAR(128) NOT NULL COMMENT '配置KEY config key', `value` VARCHAR(128) NOT NULL COMMENT '配置VALUE config value', PRIMARY KEY (user_id, `key`), FOREIGN KEY (user_id) REFERENCES tb_user (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * user notification table * 用户通知表 */ CREATE TABLE tb_notification ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, user_id INT(10) NOT NULL COMMENT '接受通知的用户id; user id to be notified.', target_user_id INT(10) NOT NULL COMMENT '上下文用户id; context user id', type_id SMALLINT NOT NULL COMMENT '1-文档修改,2-被加入新项目', param1 VARCHAR(128) NULL COMMENT '1,2-项目id', param2 VARCHAR(128) NULL COMMENT ' 1,2-项目名称', param3 TEXT NULL COMMENT '备用预留 reserved', create_time TIMESTAMP NOT NULL COMMENT '创建时间 create time' DEFAULT now(), is_read SMALLINT NOT NULL COMMENT '是否已读 is notification read' DEFAULT 0, FOREIGN KEY (user_id) REFERENCES tb_user (id), FOREIGN KEY (target_user_id) REFERENCES tb_user (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * corporation table * 公司表 */ CREATE TABLE tb_corporation ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(256) NOT NULL, logo_url VARCHAR(256) NULL, user_id INT(10) NULL, access_type TINYINT NOT NULL COMMENT '权限控制, 10普通, 20公开' DEFAULT 10, `desc` TEXT NOT NULL COMMENT '备注', FOREIGN KEY (user_id) REFERENCES tb_user (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * product line table * 生产线表 */ CREATE TABLE tb_production_line ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(256) NOT NULL, project_num INT(10) NOT NULL DEFAULT 0, corporation_id INT(10) NOT NULL, user_id INT(10) NOT NULL, FOREIGN KEY (user_id) REFERENCES tb_user (id), FOREIGN KEY (corporation_id) REFERENCES tb_corporation (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * project group table * 项目分组表 */ CREATE TABLE tb_group ( id INT(10) AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(256) NOT NULL, production_line_id INT(10) NOT NULL, user_id INT(10) NOT NULL, FOREIGN KEY (user_id) REFERENCES tb_user (id), FOREIGN KEY (production_line_id) REFERENCES tb_production_line (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /** * 规则表，存储通过Open API设置的Mock规则 * Stored mock rules set by Open API */ CREATE TABLE tb_rule ( action_id INT(10) NOT NULL PRIMARY KEY, rules TEXT NOT NULL, -- JSON规则 update_time DATETIME NOT NULL DEFAULT NOW(), -- 最近更新时间 FOREIGN KEY (action_id) REFERENCES tb_action (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; CREATE TABLE tb_corporation_and_user ( user_id INT(10) NOT NULL, corporation_id INT(10) NOT NULL, role_id INT(10) NOT NULL, PRIMARY KEY (user_id, corporation_id), FOREIGN KEY (user_id) REFERENCES tb_user (id), FOREIGN KEY (corporation_id) REFERENCES tb_corporation (id), FOREIGN KEY (role_id) REFERENCES tb_role (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; -- required base data INSERT INTO tb_role (name) VALUES ('god'); INSERT INTO tb_role (name) VALUES ('admin'); INSERT INTO tb_role (name) VALUES ('user'); -- removed unused qa/pm/rd roles INSERT INTO tb_user (account, password, email, create_date, last_login_date, name) VALUES ('admin', 'RESERVED', 'admin@example.com', NOW(), NOW(), 'admin'); INSERT INTO tb_role_and_user (user_id, role_id) VALUES (1, 1); -- INSERT INTO tb_corporation (name, logo_url, user_id) VALUES ('MyTeam', 'empty', 1); -- 新版RAP可以自建团队，不需要插入默认团队了。 -- RAP v0.11.5+ users can create teams by their own, so there's no need to set default team.
然后再执行一下下面这句
SET @@global.sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION';
好 看看本地数据是否有了对应的表接口如图：
2 里面说的安装redis 地址就是坑有没有呢？
下载地址：https://github.com/dmajkic/redis/downloads （下载好对应的文件 进行解压后 把比如我的电脑是64位的那把这个文件拷贝到D:盘的一个新文件夹中）
然后作者应该是笔误了 关于执行路径写错了 下图应该是第二个执行命令 注意顺序（在自己的文件夹中去执行对应的命令）
最后三个服务一起启动好了，如果登陆不成功 很正常重新注册一个用户，然后验证有点小坑 不过不影响大局给！
最后的最后 希望大家安装愉快！
工具包集合：百度云盘下载地址
链接：http://pan.baidu.com/s/1i5scmKP 密码：uzhm
