From db334cd5c93c713bb657377e3d2a2413b4522b20 Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Sat, 22 Dec 2018 15:01:04 +0100 Subject: [PATCH] update vertica-snippets Signed-off-by: Andreas Gerler --- .../snippets/sql-interactive-mode/check_rle_overridden | 0 .../snippets/sql-interactive-mode/current_epoch | 0 .../snippets/sql-interactive-mode/errors | 0 .../snippets/sql-interactive-mode/external_table_details | 7 +++++++ .../snippets/sql-interactive-mode/get-partitions | 0 .../snippets/sql-interactive-mode/get-projections | 0 .../snippets/sql-interactive-mode/grants | 0 .../snippets/sql-interactive-mode/last-statement-timing | 0 .../snippets/sql-interactive-mode/list-backups | 7 +++++++ .../sql-interactive-mode/list-tables-row-count-size | 0 .../snippets/sql-interactive-mode/nodes | 0 .../snippets/sql-interactive-mode/pool_queues | 9 +++++++++ .../snippets/sql-interactive-mode/query-times | 0 .../snippets/sql-interactive-mode/rebalance_status | 0 .../snippets/sql-interactive-mode/resource-pool-move | 0 .../snippets/sql-interactive-mode/resource_pools | 7 +++++++ .../snippets/sql-interactive-mode/resources | 0 .../snippets/sql-interactive-mode/sessions | 0 .../snippets/sql-interactive-mode/storage-containers | 0 .../snippets/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 | 0 .../vertica-snippets-pkg.el | 2 +- .../vertica-snippets.el | 0 26 files changed, 31 insertions(+), 1 deletion(-) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/check_rle_overridden (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/current_epoch (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/errors (100%) create mode 100644 elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/external_table_details rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/get-partitions (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/get-projections (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/grants (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/last-statement-timing (100%) create mode 100644 elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/list-backups rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/list-tables-row-count-size (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/nodes (100%) create mode 100644 elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/pool_queues rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/query-times (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/rebalance_status (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/resource-pool-move (100%) create mode 100644 elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resource_pools rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/resources (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/sessions (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/storage-containers (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/storage-locations (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/user_sessions (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-interactive-mode/vertica_users (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/snippets/sql-mode/.yas-parents (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/vertica-snippets-autoloads.el (100%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/vertica-snippets-pkg.el (80%) rename elpa/{vertica-snippets-20181016.748 => vertica-snippets-20181211.1035}/vertica-snippets.el (100%) diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/check_rle_overridden similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/check_rle_overridden rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/check_rle_overridden diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/current_epoch similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/current_epoch diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/errors similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/errors diff --git a/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/external_table_details b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/external_table_details new file mode 100644 index 00000000..46846601 --- /dev/null +++ b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/external_table_details @@ -0,0 +1,7 @@ +# -*- mode: snippet -*- +# name: external_table_details +# key: etd_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT table_name, source_format, total_file_size_bytes FROM external_table_details;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/get-partitions similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/get-partitions diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/get-projections similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/get-projections diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/grants similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/grants diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/last-statement-timing b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/last-statement-timing similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/last-statement-timing rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/last-statement-timing diff --git a/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/list-backups b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/list-backups new file mode 100644 index 00000000..4798d737 --- /dev/null +++ b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/list-backups @@ -0,0 +1,7 @@ +# -*- mode: snippet -*- +# name: list-backups +# key: ls_backups +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT * FROM v_monitor.database_backups ORDER BY 1 DESC;$0 \ 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-20181211.1035/snippets/sql-interactive-mode/list-tables-row-count-size similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/list-tables-row-count-size rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/list-tables-row-count-size diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/nodes similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/nodes rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/pool_queues b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/pool_queues new file mode 100644 index 00000000..2c07685d --- /dev/null +++ b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/pool_queues @@ -0,0 +1,9 @@ +# -*- mode: snippet -*- +# name: pool_queues +# key: pq_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# https://www.vertica.com/blog/calculate-request-queue-length-quick-tip/?utm_campaign=00164962 +# https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/RESOURCE_ACQUISITIONS.htm +# -- +SELECT node_name, request_type, transaction_id, statement_id, pool_name, (acquisition_timestamp - queue_entry_timestamp) request_queue_length FROM v_monitor.resource_acquisitions WHERE pool_name = '${1:general}' ${2:AND (acquisition_timestamp - queue_entry_timestamp) > '1 second'} ORDER BY (acquisition_timestamp - queue_entry_timestamp) DESC ${3:LIMIT 42};$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/query-times b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/query-times similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/query-times rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/query-times diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/rebalance_status similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/rebalance_status diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resource-pool-move similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resource-pool-move diff --git a/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resource_pools b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resource_pools new file mode 100644 index 00000000..2138f59a --- /dev/null +++ b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resource_pools @@ -0,0 +1,7 @@ +# -*- mode: snippet -*- +# name: resource_pools +# key: pools_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT * FROM resource_pools;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resources similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/resources diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/sessions similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/sessions diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/storage-containers similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/storage-containers diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/storage-locations similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/storage-locations rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/storage-locations diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/user_sessions similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/user_sessions diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/vertica_users similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20181211.1035/snippets/sql-interactive-mode/vertica_users diff --git a/elpa/vertica-snippets-20181016.748/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20181211.1035/snippets/sql-mode/.yas-parents similarity index 100% rename from elpa/vertica-snippets-20181016.748/snippets/sql-mode/.yas-parents rename to elpa/vertica-snippets-20181211.1035/snippets/sql-mode/.yas-parents diff --git a/elpa/vertica-snippets-20181016.748/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20181211.1035/vertica-snippets-autoloads.el similarity index 100% rename from elpa/vertica-snippets-20181016.748/vertica-snippets-autoloads.el rename to elpa/vertica-snippets-20181211.1035/vertica-snippets-autoloads.el diff --git a/elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el b/elpa/vertica-snippets-20181211.1035/vertica-snippets-pkg.el similarity index 80% rename from elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el rename to elpa/vertica-snippets-20181211.1035/vertica-snippets-pkg.el index c7b48b09..d8ba55e4 100644 --- a/elpa/vertica-snippets-20181016.748/vertica-snippets-pkg.el +++ b/elpa/vertica-snippets-20181211.1035/vertica-snippets-pkg.el @@ -1,4 +1,4 @@ -(define-package "vertica-snippets" "20181016.748" "Yasnippets for Vertica" +(define-package "vertica-snippets" "20181211.1035" "Yasnippets for Vertica" '((yasnippet "0.6.1")) :keywords '("convenience" "snippets") diff --git a/elpa/vertica-snippets-20181016.748/vertica-snippets.el b/elpa/vertica-snippets-20181211.1035/vertica-snippets.el similarity index 100% rename from elpa/vertica-snippets-20181016.748/vertica-snippets.el rename to elpa/vertica-snippets-20181211.1035/vertica-snippets.el -- 2.47.3