From 2b0c368ba5c34e108fa25af9294a1857a77d2b82 Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Fri, 12 Jan 2018 15:16:57 +0100 Subject: [PATCH] Add package vertica-snippets move yasnippet collection for vertica into it's own package. Signed-off-by: Andreas Gerler --- .../sql-interactive-mode/check_rle_overridden | 21 +++++++ .../sql-interactive-mode/current_epoch | 2 + .../snippets}/sql-interactive-mode/errors | 2 + .../sql-interactive-mode/get-partitions | 2 + .../sql-interactive-mode/get-projections | 2 + .../snippets}/sql-interactive-mode/grants | 2 + .../snippets/sql-interactive-mode/nodes | 7 +++ .../sql-interactive-mode/rebalance_status | 2 + .../sql-interactive-mode/resource-pool-move | 2 + .../snippets}/sql-interactive-mode/resources | 2 + .../snippets}/sql-interactive-mode/sessions | 2 + .../sql-interactive-mode/storage-containers | 2 + .../sql-interactive-mode/storage-locations | 7 +++ .../sql-interactive-mode/user_sessions | 2 + .../sql-interactive-mode/vertica_users | 2 + .../snippets/sql-mode/.yas-parents | 1 + .../vertica-snippets-autoloads.el | 29 ++++++++++ .../vertica-snippets-pkg.el | 12 ++++ .../vertica-snippets.el | 55 +++++++++++++++++++ snippets/sql-interactive-mode/nodes | 5 -- 20 files changed, 156 insertions(+), 5 deletions(-) create mode 100644 elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/check_rle_overridden rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/current_epoch (65%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/errors (68%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/get-partitions (69%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/get-projections (58%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/grants (79%) create mode 100644 elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/nodes rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/rebalance_status (90%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/resource-pool-move (66%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/resources (74%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/sessions (53%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/storage-containers (87%) create mode 100644 elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-locations rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/user_sessions (68%) rename {snippets => elpa/vertica-snippets-20180112.1202/snippets}/sql-interactive-mode/vertica_users (66%) create mode 100644 elpa/vertica-snippets-20180112.1202/snippets/sql-mode/.yas-parents create mode 100644 elpa/vertica-snippets-20180112.1202/vertica-snippets-autoloads.el create mode 100644 elpa/vertica-snippets-20180112.1202/vertica-snippets-pkg.el create mode 100644 elpa/vertica-snippets-20180112.1202/vertica-snippets.el delete mode 100644 snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/check_rle_overridden new file mode 100644 index 00000000..962da6a9 --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/check_rle_overridden @@ -0,0 +1,21 @@ +# -*- mode: snippet -*- +# name: check_rle_overridden +# key: rle_check_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +select + qe.user_name, + count(*) +from + v_monitor.query_events qe + join v_monitor.query_requests qr + on qr.transaction_id = qe.transaction_id + and qr.statement_id = qe.statement_id +where + qr.request_type = 'QUERY' + and qe.event_type = 'RLE_OVERRIDDEN' + and to_char(event_timestamp, 'YYYY-MM-DD') = '${1:`(format-time-string "%Y-%m-%d")`}' +group by + 1 +; \ No newline at end of file diff --git a/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/current_epoch similarity index 65% rename from snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/current_epoch index b0148e70..cd4550fb 100644 --- a/snippets/sql-interactive-mode/current_epoch +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/current_epoch @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: current_epoch # key: epo_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT current_epoch, ahm_epoch, last_good_epoch FROM v_monitor.system; \ No newline at end of file diff --git a/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/errors similarity index 68% rename from snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/errors index f5044323..f5629f08 100644 --- a/snippets/sql-interactive-mode/errors +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/errors @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: errors # key: errors_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT DISTINCT error_level, message FROM error_messages $0WHERE message ILIKE 'Vertica suggests%'; diff --git a/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/get-partitions similarity index 69% rename from snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/get-partitions index 99230b71..dadd295e 100644 --- a/snippets/sql-interactive-mode/get-partitions +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/get-partitions @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: get-partitions # key: get-part +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT * FROM v_monitor.partitions WHERE table_schema = '$1' AND projection_name LIKE '%$2%';$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/get-projections similarity index 58% rename from snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/get-projections index 1dc0ff92..c4457800 100644 --- a/snippets/sql-interactive-mode/get-projections +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/get-projections @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: get-projections # key: get-proj +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT GET_PROJECTIONS('$1');$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/grants similarity index 79% rename from snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/grants index e770e3f9..96d0003b 100644 --- a/snippets/sql-interactive-mode/grants +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/grants @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: grants # key: grants_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT grantee, object_name, privileges_description FROM v_catalog.grants WHERE object_type = '${1:$$(yas-choose-value '("RESOURCEPOOL" "ROLE" "SCHEMA" "TABLE" "VIEW" "STORAGELOCATION"))}' ORDER BY grantee $0LIMIT 50; \ No newline at end of file diff --git a/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/nodes new file mode 100644 index 00000000..7ef2cc9c --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/nodes @@ -0,0 +1,7 @@ +# -*- mode: snippet -*- +# name: show nodes +# key: nodes_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT * FROM nodes; \ No newline at end of file diff --git a/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/rebalance_status similarity index 90% rename from snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/rebalance_status index acee6924..9c014ca2 100644 --- a/snippets/sql-interactive-mode/rebalance_status +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/rebalance_status @@ -1,6 +1,8 @@ # -*- mode: snippet -*- # name: rebalance_status # key: rebalance_status_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT rebalance_method rebalance_method, status, diff --git a/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/resource-pool-move similarity index 66% rename from snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/resource-pool-move index 918bf43b..5486fe9c 100644 --- a/snippets/sql-interactive-mode/resource-pool-move +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/resource-pool-move @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: resource-pool-move # key: rpmv +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT * FROM resource_pool_move ORDER BY move_timestamp DESC LIMIT 40;$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/resources similarity index 74% rename from snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/resources index ba97ac8f..16474d2d 100644 --- a/snippets/sql-interactive-mode/resources +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/resources @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: resources # key: res_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT * FROM ${1:$$(yas-choose-value '("resource_pool_status" "resource_pool_move" "resource_rejections" "resource_rejection_details ORDER BY 1"))};$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/sessions similarity index 53% rename from snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/sessions index 8f17fe7e..529f7a6b 100644 --- a/snippets/sql-interactive-mode/sessions +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/sessions @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: sessions # key: sess_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT * FROM sessions;$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-containers similarity index 87% rename from snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-containers index ee82f79c..5bb25bb8 100644 --- a/snippets/sql-interactive-mode/storage-containers +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-containers @@ -1,6 +1,8 @@ # -*- mode: snippet -*- # name: storage-containers # key: storage-containers +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT s.node_name, p.table_schema, diff --git a/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-locations new file mode 100644 index 00000000..291fa405 --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/storage-locations @@ -0,0 +1,7 @@ +# -*- mode: snippet -*- +# name: storage-locations +# key: storage-locations +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT * FROM v_catalog.grants gra, storage_locations loc WHERE gra.object_id = loc.location_id;$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/user_sessions similarity index 68% rename from snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/user_sessions index c924efc5..29444569 100644 --- a/snippets/sql-interactive-mode/user_sessions +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/user_sessions @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: user_sessions # key: ussess_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT session_id, transaction_start FROM sessions WHERE user_name = '$1' ORDER BY 2 desc;$0 \ No newline at end of file diff --git a/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/vertica_users similarity index 66% rename from snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/vertica_users index 030a4455..73414e02 100644 --- a/snippets/sql-interactive-mode/vertica_users +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-interactive-mode/vertica_users @@ -1,5 +1,7 @@ # -*- mode: snippet -*- # name: vertica_users # key: vertu_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) # -- SELECT user_name,resource_pool,default_roles FROM v_catalog.users ORDER BY 1; \ No newline at end of file diff --git a/elpa/vertica-snippets-20180112.1202/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20180112.1202/snippets/sql-mode/.yas-parents new file mode 100644 index 00000000..a20f5c60 --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/snippets/sql-mode/.yas-parents @@ -0,0 +1 @@ +sql-interactive-mode diff --git a/elpa/vertica-snippets-20180112.1202/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20180112.1202/vertica-snippets-autoloads.el new file mode 100644 index 00000000..12d3e9aa --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/vertica-snippets-autoloads.el @@ -0,0 +1,29 @@ +;;; vertica-snippets-autoloads.el --- automatically extracted autoloads +;; +;;; Code: +(add-to-list 'load-path (directory-file-name (or (file-name-directory #$) (car load-path)))) + +;;;### (autoloads nil "vertica-snippets" "vertica-snippets.el" (23128 +;;;;;; 38466 776630 477000)) +;;; Generated autoloads from vertica-snippets.el + +(autoload 'vertica-snippets-initialize "vertica-snippets" "\ +Add snippet dir to yas-snippet-dirs and load it. + +\(fn)" nil nil) + +(eval-after-load 'yasnippet '(vertica-snippets-initialize)) + +;;;*** + +;;;### (autoloads nil nil ("vertica-snippets-pkg.el") (23128 38466 +;;;;;; 775088 24000)) + +;;;*** + +;; Local Variables: +;; version-control: never +;; no-byte-compile: t +;; no-update-autoloads: t +;; End: +;;; vertica-snippets-autoloads.el ends here diff --git a/elpa/vertica-snippets-20180112.1202/vertica-snippets-pkg.el b/elpa/vertica-snippets-20180112.1202/vertica-snippets-pkg.el new file mode 100644 index 00000000..33f3d745 --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/vertica-snippets-pkg.el @@ -0,0 +1,12 @@ +(define-package "vertica-snippets" "20180112.1202" "Yasnippets for AWS" + '((yasnippet "0.6.1")) + :keywords + '("convenience" "snippets") + :authors + '(("Andreas Gerler" . "baron@bundesbrandschatzamt.de")) + :maintainer + '("Andreas Gerler" . "baron@bundesbrandschatzamt.de") + :url "https://github.com/baron42bba/vertica-snippets") +;; Local Variables: +;; no-byte-compile: t +;; End: diff --git a/elpa/vertica-snippets-20180112.1202/vertica-snippets.el b/elpa/vertica-snippets-20180112.1202/vertica-snippets.el new file mode 100644 index 00000000..0faa2304 --- /dev/null +++ b/elpa/vertica-snippets-20180112.1202/vertica-snippets.el @@ -0,0 +1,55 @@ +;;; vertica-snippets.el --- Yasnippets for AWS + +;; Copyright (C) 2018 Andreas Gerler +;; keywords: convenience,snippets +;; Version: 0.1.0 +;; Package-Requires: ((yasnippet "0.6.1")) + +;; Author: Andreas Gerler +;; Maintainer: Andreas Gerler + +;; URL: https://github.com/baron42bba/vertica-snippets + +;; Permission is hereby granted, free of charge, to any person obtaining +;; a copy of this software and associated documentation files (the +;; "Software"), to deal in the Software without restriction, including +;; without limitation the rights to use, copy, modify, merge, publish, +;; distribute, sublicense, and/or sell copies of the Software, and to +;; permit persons to whom the Software is furnished to do so, subject to +;; the following conditions: + +;; The above copyright notice and this permission notice shall be +;; included in all copies or substantial portions of the Software. + +;; THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, +;; EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF +;; MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND +;; NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE +;; LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION +;; OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION +;; WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. + +;;; Commentary: + +;; A collection of yasnippet snippets to be used with the Vertica Analytics Platform + +;;; Code: + +(require 'yasnippet) + +(defvar vertica-snippets-dir (file-name-directory (or (buffer-file-name) + load-file-name))) + +;;;###autoload +(defun vertica-snippets-initialize () + "Add snippet dir to yas-snippet-dirs and load it." + (let ((snip-dir (expand-file-name "snippets" vertica-snippets-dir))) + (add-to-list 'yas-snippet-dirs snip-dir t) + (yas-load-directory snip-dir))) + +;;;###autoload +(eval-after-load 'yasnippet + '(vertica-snippets-initialize)) + +(provide 'vertica-snippets) +;;; vertica-snippets.el ends here diff --git a/snippets/sql-interactive-mode/nodes b/snippets/sql-interactive-mode/nodes deleted file mode 100644 index 77160e3c..00000000 --- a/snippets/sql-interactive-mode/nodes +++ /dev/null @@ -1,5 +0,0 @@ -# -*- mode: snippet -*- -# name: nodes -# key: nodes_ -# -- -SELECT * FROM nodes; \ No newline at end of file -- 2.47.3