From f1202a767a4b9674fa52341a03ee7aee6b0a38c5 Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Wed, 7 Feb 2018 15:16:27 +0100 Subject: [PATCH] vertica-snippets update. Signed-off-by: Andreas Gerler --- .../sql-interactive-mode/check_rle_overridden | 0 .../sql-interactive-mode/current_epoch | 0 .../snippets/sql-interactive-mode/errors | 0 .../sql-interactive-mode/get-partitions | 0 .../sql-interactive-mode/get-projections | 0 .../snippets/sql-interactive-mode/grants | 0 .../snippets/sql-interactive-mode/nodes | 0 .../snippets/sql-interactive-mode/query-times | 27 +++++++++++++++++++ .../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 .../sql-interactive-mode/user_sessions | 0 .../sql-interactive-mode/vertica_users | 0 .../snippets/sql-mode/.yas-parents | 0 .../vertica-snippets-autoloads.el | 8 +++--- .../vertica-snippets-pkg.el | 2 +- .../vertica-snippets.el | 0 20 files changed, 32 insertions(+), 5 deletions(-) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/check_rle_overridden (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/current_epoch (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/errors (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/get-partitions (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/get-projections (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/grants (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/nodes (100%) create mode 100644 elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/query-times rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/rebalance_status (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/resource-pool-move (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/resources (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/sessions (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/storage-containers (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/storage-locations (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/user_sessions (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-interactive-mode/vertica_users (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/snippets/sql-mode/.yas-parents (100%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/vertica-snippets-autoloads.el (84%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/vertica-snippets-pkg.el (69%) rename elpa/{vertica-snippets-20180122.44 => vertica-snippets-20180207.453}/vertica-snippets.el (100%) diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/check_rle_overridden similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/check_rle_overridden rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/check_rle_overridden diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/current_epoch similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/current_epoch diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/errors similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/errors diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-partitions similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-partitions diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-projections similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/get-projections diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/grants similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/grants diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/nodes similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/nodes rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/query-times b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/query-times new file mode 100644 index 00000000..be328687 --- /dev/null +++ b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/query-times @@ -0,0 +1,27 @@ +# -*- mode: snippet -*- +# name: query-times +# key: qt_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT DISTINCT theday, + user_name, + (min_dat / 1000) AS min_sec, + (max_dat / 1000) AS max_sec, + (avg_dat / 1000) AS avg_sec, + (median_dat / 1000) AS median_sec, + query_cnt +FROM + (SELECT date(end_timestamp::TIMESTAMP) AS theday, + user_name, + min(request_duration_ms) over(partition BY date(end_timestamp::TIMESTAMP), user_name) min_dat, + max(request_duration_ms) over(partition BY date(end_timestamp::TIMESTAMP), user_name) max_dat, + avg(request_duration_ms) over(partition BY date(end_timestamp::TIMESTAMP), user_name) avg_dat, + median(request_duration_ms) over(partition BY date(end_timestamp::TIMESTAMP), user_name) median_dat, + count(*) over(partition BY date(end_timestamp::TIMESTAMP), user_name) AS query_cnt + FROM query_requests + WHERE is_executing IS FALSE + AND request ILIKE '%table%' + AND NOT (request LIKE 'SELECT * FROM columns%' + OR request LIKE '%query_requests%') ) my_alias +ORDER BY 1, 2 DESC; \ No newline at end of file diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/rebalance_status similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/rebalance_status diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resource-pool-move similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resource-pool-move diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resources similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/resources diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/sessions similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/sessions diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-containers similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-containers diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-locations similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/storage-locations rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/storage-locations diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/user_sessions similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/user_sessions diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/vertica_users similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20180207.453/snippets/sql-interactive-mode/vertica_users diff --git a/elpa/vertica-snippets-20180122.44/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20180207.453/snippets/sql-mode/.yas-parents similarity index 100% rename from elpa/vertica-snippets-20180122.44/snippets/sql-mode/.yas-parents rename to elpa/vertica-snippets-20180207.453/snippets/sql-mode/.yas-parents diff --git a/elpa/vertica-snippets-20180122.44/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20180207.453/vertica-snippets-autoloads.el similarity index 84% rename from elpa/vertica-snippets-20180122.44/vertica-snippets-autoloads.el rename to elpa/vertica-snippets-20180207.453/vertica-snippets-autoloads.el index cba7932b..8bfa011e 100644 --- a/elpa/vertica-snippets-20180122.44/vertica-snippets-autoloads.el +++ b/elpa/vertica-snippets-20180207.453/vertica-snippets-autoloads.el @@ -3,8 +3,8 @@ ;;; Code: (add-to-list 'load-path (directory-file-name (or (file-name-directory #$) (car load-path)))) -;;;### (autoloads nil "vertica-snippets" "vertica-snippets.el" (23142 -;;;;;; 1522 96098 505000)) +;;;### (autoloads nil "vertica-snippets" "vertica-snippets.el" (23163 +;;;;;; 2511 68580 344000)) ;;; Generated autoloads from vertica-snippets.el (autoload 'vertica-snippets-initialize "vertica-snippets" "\ @@ -16,8 +16,8 @@ Add snippet dir to yas-snippet-dirs and load it. ;;;*** -;;;### (autoloads nil nil ("vertica-snippets-pkg.el") (23142 1522 -;;;;;; 93766 839000)) +;;;### (autoloads nil nil ("vertica-snippets-pkg.el") (23163 2511 +;;;;;; 67083 188000)) ;;;*** diff --git a/elpa/vertica-snippets-20180122.44/vertica-snippets-pkg.el b/elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el similarity index 69% rename from elpa/vertica-snippets-20180122.44/vertica-snippets-pkg.el rename to elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el index 16fa0f5a..dbf3b5f4 100644 --- a/elpa/vertica-snippets-20180122.44/vertica-snippets-pkg.el +++ b/elpa/vertica-snippets-20180207.453/vertica-snippets-pkg.el @@ -1,4 +1,4 @@ -(define-package "vertica-snippets" "20180122.44" "Yasnippets for Vertica" +(define-package "vertica-snippets" "20180207.453" "Yasnippets for Vertica" '((yasnippet "0.6.1")) :url "https://github.com/baron42bba/vertica-snippets" :keywords '("convenience" "snippets")) diff --git a/elpa/vertica-snippets-20180122.44/vertica-snippets.el b/elpa/vertica-snippets-20180207.453/vertica-snippets.el similarity index 100% rename from elpa/vertica-snippets-20180122.44/vertica-snippets.el rename to elpa/vertica-snippets-20180207.453/vertica-snippets.el -- 2.47.3