From 8406bbb1ec137434524d4719b182015afff4c73c Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Tue, 13 Nov 2018 10:53:36 +0100 Subject: [PATCH] update vertica-snippets. Signed-off-by: Andreas Gerler --- .../vertica-snippets-pkg.el | 7 ------- .../sql-interactive-mode/check_rle_overridden | 0 .../snippets/sql-interactive-mode/current_epoch | 0 .../snippets/sql-interactive-mode/errors | 0 .../snippets/sql-interactive-mode/get-partitions | 0 .../snippets/sql-interactive-mode/get-projections | 0 .../snippets/sql-interactive-mode/grants | 0 .../sql-interactive-mode/last-statement-timing | 8 ++++++++ .../list-tables-row-count-size | 15 +++++++++++++++ .../snippets/sql-interactive-mode/nodes | 0 .../snippets/sql-interactive-mode/query-times | 0 .../sql-interactive-mode/rebalance_status | 0 .../sql-interactive-mode/resource-pool-move | 0 .../snippets/sql-interactive-mode/resources | 0 .../snippets/sql-interactive-mode/sessions | 0 .../sql-interactive-mode/storage-containers | 0 .../sql-interactive-mode/storage-locations | 0 .../snippets/sql-interactive-mode/user_sessions | 0 .../snippets/sql-interactive-mode/vertica_users | 0 .../snippets/sql-mode/.yas-parents | 0 .../vertica-snippets-autoloads.el | 15 ++++++++++----- .../vertica-snippets-pkg.el | 12 ++++++++++++ .../vertica-snippets.el | 0 23 files changed, 45 insertions(+), 12 deletions(-) delete mode 100644 elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/check_rle_overridden (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/current_epoch (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/errors (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/get-partitions (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/get-projections (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/grants (100%) create mode 100644 elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/last-statement-timing create mode 100644 elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/list-tables-row-count-size rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/nodes (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/query-times (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/rebalance_status (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/resource-pool-move (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/resources (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/sessions (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/storage-containers (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/storage-locations (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/user_sessions (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-interactive-mode/vertica_users (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/snippets/sql-mode/.yas-parents (100%) rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/vertica-snippets-autoloads.el (61%) create mode 100644 elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el rename elpa/{vertica-snippets-20180207.453 => vertica-snippets-20181016.748}/vertica-snippets.el (100%) diff --git a/elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el b/elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el deleted file mode 100644 index dbf3b5f4..00000000 --- a/elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el +++ /dev/null @@ -1,7 +0,0 @@ -(define-package "vertica-snippets" "20180207.453" "Yasnippets for Vertica" - '((yasnippet "0.6.1")) - :url "https://github.com/baron42bba/vertica-snippets" :keywords - '("convenience" "snippets")) -;; Local Variables: -;; no-byte-compile: t -;; End: diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/check_rle_overridden similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/check_rle_overridden rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/check_rle_overridden diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/current_epoch similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/current_epoch diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/errors similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/errors diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-partitions similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-partitions diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-projections similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-projections diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/grants similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/grants diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/last-statement-timing b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/last-statement-timing new file mode 100644 index 00000000..c598f2ef --- /dev/null +++ b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/last-statement-timing @@ -0,0 +1,8 @@ +# -*- mode: snippet -*- +# name: last-statement-timing +# key: lst_ +# group: vertica +# -- +SELECT last_statement, + last_statement_duration_us / 1000000.0 last_statement_duration_seconds +FROM current_session; \ No newline at end of file diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/list-tables-row-count-size b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/list-tables-row-count-size new file mode 100644 index 00000000..6cc9169c --- /dev/null +++ b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/list-tables-row-count-size @@ -0,0 +1,15 @@ +# -*- mode: snippet -*- +# name: list-tables-row-count-size +# key: ls-tables +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT tbl.table_schema AS "Schema Name", + tbl.table_name AS "Table Name", + to_char(sum(prs.ros_row_count)/count(DISTINCT prs.projection_name), '999G999G999G999') AS "No Of Rows", + to_char(sum(prs.ros_used_bytes)/count(DISTINCT prs.projection_name), '999G999G999G999G999') AS "Size In Bytes" +FROM TABLES tbl +JOIN projections prj ON tbl.table_id = prj.anchor_table_id +JOIN projection_storage prs ON prj.projection_name = prs.projection_name +GROUP BY 1, 2 +ORDER BY 1, 2;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/nodes similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/nodes rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/query-times b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/query-times similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/query-times rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/query-times diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/rebalance_status similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/rebalance_status diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resource-pool-move similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resource-pool-move diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resources similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resources diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/sessions similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/sessions diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-containers similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-containers diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-locations similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-locations rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-locations diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/user_sessions similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/user_sessions diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/vertica_users similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/vertica_users diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20181016.748/snippets/sql-mode/.yas-parents similarity index 100% rename from elpa/vertica-snippets-20180207.453/snippets/sql-mode/.yas-parents rename to elpa/vertica-snippets-20181016.748/snippets/sql-mode/.yas-parents diff --git a/elpa/vertica-snippets-20180207.453/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20181016.748/vertica-snippets-autoloads.el similarity index 61% rename from elpa/vertica-snippets-20180207.453/vertica-snippets-autoloads.el rename to elpa/vertica-snippets-20181016.748/vertica-snippets-autoloads.el index 8bfa011e..756a1bef 100644 --- a/elpa/vertica-snippets-20180207.453/vertica-snippets-autoloads.el +++ b/elpa/vertica-snippets-20181016.748/vertica-snippets-autoloads.el @@ -1,10 +1,13 @@ ;;; vertica-snippets-autoloads.el --- automatically extracted autoloads ;; ;;; Code: -(add-to-list 'load-path (directory-file-name (or (file-name-directory #$) (car load-path)))) + +(add-to-list 'load-path (directory-file-name + (or (file-name-directory #$) (car load-path)))) + -;;;### (autoloads nil "vertica-snippets" "vertica-snippets.el" (23163 -;;;;;; 2511 68580 344000)) +;;;### (autoloads nil "vertica-snippets" "vertica-snippets.el" (0 +;;;;;; 0 0 0)) ;;; Generated autoloads from vertica-snippets.el (autoload 'vertica-snippets-initialize "vertica-snippets" "\ @@ -14,10 +17,11 @@ Add snippet dir to yas-snippet-dirs and load it. (eval-after-load 'yasnippet '(vertica-snippets-initialize)) +(if (fboundp 'register-definition-prefixes) (register-definition-prefixes "vertica-snippets" '("vertica-snippets-dir"))) + ;;;*** -;;;### (autoloads nil nil ("vertica-snippets-pkg.el") (23163 2511 -;;;;;; 67083 188000)) +;;;### (autoloads nil nil ("vertica-snippets-pkg.el") (0 0 0 0)) ;;;*** @@ -25,5 +29,6 @@ Add snippet dir to yas-snippet-dirs and load it. ;; version-control: never ;; no-byte-compile: t ;; no-update-autoloads: t +;; coding: utf-8 ;; End: ;;; vertica-snippets-autoloads.el ends here diff --git a/elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el b/elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el new file mode 100644 index 00000000..c7b48b09 --- /dev/null +++ b/elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el @@ -0,0 +1,12 @@ +(define-package "vertica-snippets" "20181016.748" "Yasnippets for Vertica" + '((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-20180207.453/vertica-snippets.el b/elpa/vertica-snippets-20181016.748/vertica-snippets.el similarity index 100% rename from elpa/vertica-snippets-20180207.453/vertica-snippets.el rename to elpa/vertica-snippets-20181016.748/vertica-snippets.el -- 2.47.3