Wiki

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