白沙黎族自治县网站建设_网站建设公司_百度智能云_seo优化

espanso

官网：https://espanso.org/

（1）

config是配置文件目录

match是放补全规则的地方

（2）

先在match文件夹建补全规则

注意文件名以下划线开头，代表这个文件默认不生效

matches: - trigger: "sf " replace: "select * from " - trigger: "asd " replace: "select count(*) from " - trigger: "for " replace: "for update" - trigger: "like " replace: "like '%%'" - trigger: "dis " replace: "distinct" - trigger: "yy " replace: "'yyyy-mm-dd hh24:mi:ss'" - trigger: "yyy " replace: "to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')" - trigger: "rn1 " replace: "select t.* from (select a.*, ROW_NUMBER() OVER (PARTITION BY 分组列 ORDER BY 组内排序列 DESC) rn_001 from 表名 a) t where t.rn_001 = 1" - trigger: "ord " replace: "order by " - trigger: "orde " replace: "order by create_time desc" - trigger: "grou " replace: "select count(*) from 表名 group by 字段 order by count(*) desc" - trigger: "agg " replace: "listagg( 字段 , ',' ) within group ( order by 字段 )" - trigger: "lista " replace: "listagg( 字段 , ',' ) within group ( order by 字段 )" - trigger: "listagg " replace: "listagg( 字段 , ',' ) within group ( order by 字段 )"

（3）

再到config文件夹建一个配置文件

filter_exec使用正则，匹配生效的应用

extra_includes指定生效的补全规则

filter_exec: "navicat|idea64|pycharm64" extra_includes: - "../match/_sql.yml"