接口调试工具
Apipost
参数描述库内容添加
SELECT
distinct COLUMN_NAME,
table_name,
DATA_TYPE,
COLUMN_COMMENT,
CONCAT(COLUMN_NAME,':',COLUMN_COMMENT) as '参数描述库'
FROM
information_schema.COLUMNS
WHERE
table_schema = 'DBNAME' and COLUMN_COMMENT != ''
group by COLUMN_NAME
ORDER BY COLUMN_NAME
查询处参数描述库,导入到参数描述库中.
文档自动用参数库填充
Apifox
将数据库备注导入apifox常用参数
SELECT
distinct COLUMN_NAME,
table_name,
DATA_TYPE,
COLUMN_COMMENT,
CONCAT(COLUMN_NAME,',',COLUMN_COMMENT) as 'apifox常用参数'
FROM
information_schema.COLUMNS
WHERE
table_schema = 'DBNAME' and COLUMN_COMMENT != ''
group by COLUMN_NAME
ORDER BY COLUMN_NAME
将apifox常用参数导入到apifox设置中的常用参数。
在修改文档中使用时,选择返回响应,点击通过json生成。注释写入,选择中文即可。
如果这篇文章对你有用,可以关注本人微信公众号获取更多ヽ(^ω^)ノ ~
![微信公众号二维码](https://images.cnblogs.com/cnblogs_com/aeolian/1679458/o_wechat_gzh_qrcode.jpg)