Wiki
Clone wikiVimLabo / createSnippet
neosnippetとか、sublime_text用のテーブルをSQLで作る
snippet情報格納テーブル
create table snippet (
NAME VARCHAR2(255)
, CONTENT VARCHAR2(4000)
, ABBR VARCHAR2(255)
, DESCRIPTION VARCHAR2(255)
, tabTrigger VARCHAR2(100)
, scope VARCHAR2(100)
, options VARCHAR(100)
)
sublime_text用
create view sublime_snippet as
select
'<snippet>' || CHR(10)
|| '<content>' || CHR(10)
|| CONTENT || CHR(10)
|| '</content>' || CHR(10)
|| '<tabTrigger>' || tabTrigger || '</tabTrigger>' || CHR(10)
|| '<Scope>' || scope || '</scope>' || CHR(10)
|| '<DESCRIPTION>' || DESCRIPTION || '</DESCRIPTION>' || CHR(10)
|| '</SNIPPET>' AS sublime
FROM
snippet
neosnippt用
create view neosnippet_snippet as
select
'snippet ' || NAME || CHR(10)
|| 'abbr ' || ABBR || CHR(10)
|| 'options ' || options || CHR(10)
|| ' ' || content AS neosnippet
FROM
snippet
Updated