diff options
| author | Alexander Sulfrian <alexander@sulfrian.net> | 2012-04-24 23:29:38 +0200 |
|---|---|---|
| committer | Alexander Sulfrian <alexander@sulfrian.net> | 2012-04-24 23:29:38 +0200 |
| commit | 7a6bb0f05e349068b0a89514f1da33d6d7de30a9 (patch) | |
| tree | c202b81dfaf524e71e881c15aa509c45445a64b3 /emacs.d/lisp/yasnippet/snippets/sql-mode | |
| parent | 66b95ab46d870f41c12c489eb21c9c82846d6112 (diff) | |
| download | dotfiles-7a6bb0f05e349068b0a89514f1da33d6d7de30a9.tar.gz dotfiles-7a6bb0f05e349068b0a89514f1da33d6d7de30a9.tar.xz dotfiles-7a6bb0f05e349068b0a89514f1da33d6d7de30a9.zip | |
emacs.d/lisp/yasnippet: added yasnippet
Diffstat (limited to '')
7 files changed, 39 insertions, 0 deletions
diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents b/emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents new file mode 100644 index 0000000..eed5b44 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents @@ -0,0 +1 @@ +text-mode diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/column b/emacs.d/lisp/yasnippet/snippets/sql-mode/column new file mode 100644 index 0000000..90e4963 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/column @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : , ColumnName ColumnType NOT NULL... +# -- + , ${1:Name} ${2:Type} ${3:NOT NULL} diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint new file mode 100644 index 0000000..989e508 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : CONSTRAINT [..] PRIMARY KEY ... +# -- +CONSTRAINT [${1:PK_Name}] PRIMARY KEY ${2:CLUSTERED} ([${3:ColumnName}]) diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.1 b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.1 new file mode 100644 index 0000000..98d89f0 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.1 @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : CONSTRAINT [..] FOREIGN KEY ... +# -- +CONSTRAINT [${1:FK_Name}] FOREIGN KEY ${2:CLUSTERED} ([${3:ColumnName}]) diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/create b/emacs.d/lisp/yasnippet/snippets/sql-mode/create new file mode 100644 index 0000000..a34624d --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/create @@ -0,0 +1,10 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : create table ... +# -- +CREATE TABLE [${1:dbo}].[${2:TableName}] +( + ${3:Id} ${4:INT IDENTITY(1,1)} ${5:NOT NULL} +$0 + CONSTRAINT [${6:PK_}] PRIMARY KEY ${7:CLUSTERED} ([$3]) +) +GO diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 b/emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 new file mode 100644 index 0000000..1323daf --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 @@ -0,0 +1,12 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : create procedure ... +# -- +CREATE PROCEDURE [${1:dbo}].[${2:Name}] +( + $3 $4 = ${5:NULL} ${6:OUTPUT} +) +AS +BEGIN +$0 +END +GO diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/references b/emacs.d/lisp/yasnippet/snippets/sql-mode/references new file mode 100644 index 0000000..f2e4eab --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/references @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : REFERENCES ... +# -- +REFERENCES ${1:TableName}([${2:ColumnName}]) |