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"
