From 244b23df3ecab07cd9e453af2a4e872156136cde Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Tue, 3 Aug 2021 17:57:57 +0200 Subject: [PATCH] update vertica-snippets --- .../sql-interactive-mode/resource_pool_status2 | 14 -------------- .../snippets/sql-interactive-mode/.dir-locals.el | 0 .../snippets/sql-interactive-mode/busy-hours | 0 .../sql-interactive-mode/check_rle_overridden | 0 .../snippets/sql-interactive-mode/config-changes | 0 .../snippets/sql-interactive-mode/current_epoch | 0 .../snippets/sql-interactive-mode/errors | 0 .../sql-interactive-mode/external_table_details | 0 .../snippets/sql-interactive-mode/format_numbers | 2 +- .../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 | 0 .../sql-interactive-mode/last-vertica-updates | 0 .../snippets/sql-interactive-mode/licence-history | 0 .../snippets/sql-interactive-mode/list-backups | 0 .../list-tables-row-count-size | 0 .../snippets/sql-interactive-mode/nodes | 0 .../snippets/sql-interactive-mode/pool_queues | 0 .../sql-interactive-mode/projection_storage | 0 .../snippets/sql-interactive-mode/pset_footer | 0 .../sql-interactive-mode/query-acquisition-queue | 0 .../sql-interactive-mode/query-event-issues | 0 .../sql-interactive-mode/query-long-acquisitions | 0 .../snippets/sql-interactive-mode/query-requests | 0 .../sql-interactive-mode/query-requests-expensive | 0 .../sql-interactive-mode/query-requests-overview | 0 .../snippets/sql-interactive-mode/query-times | 0 .../rebalance_projection_status | 0 .../sql-interactive-mode/rebalance_status | 0 .../snippets/sql-interactive-mode/rebalance_times | 0 .../sql-interactive-mode/resource-pool-move | 0 .../sql-interactive-mode/resource_pool_status | 0 .../sql-interactive-mode/resource_pool_status2 | 15 +++++++++++++++ .../snippets/sql-interactive-mode/resource_pools | 0 .../snippets/sql-interactive-mode/resources | 0 .../snippets/sql-interactive-mode/ros_count | 0 .../sql-interactive-mode/segmentation-islands1 | 0 .../sql-interactive-mode/segmentation-islands2 | 0 .../snippets/sql-interactive-mode/sessions | 0 .../sql-interactive-mode/storage-containers | 0 .../sql-interactive-mode/storage-locations | 0 .../snippets/sql-interactive-mode/table_locks | 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 | 4 +--- .../vertica-snippets-pkg.el | 8 ++++---- .../vertica-snippets.el | 0 49 files changed, 21 insertions(+), 22 deletions(-) delete mode 100644 elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pool_status2 rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/.dir-locals.el (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/busy-hours (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/check_rle_overridden (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/config-changes (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/current_epoch (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/errors (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/external_table_details (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/format_numbers (83%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/get-partitions (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/get-projections (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/grants (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/last-statement-timing (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/last-vertica-updates (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/licence-history (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/list-backups (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/list-tables-row-count-size (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/nodes (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/pool_queues (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/projection_storage (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/pset_footer (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-acquisition-queue (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-event-issues (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-long-acquisitions (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-requests (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-requests-expensive (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-requests-overview (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/query-times (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/rebalance_projection_status (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/rebalance_status (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/rebalance_times (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/resource-pool-move (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/resource_pool_status (100%) create mode 100644 elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status2 rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/resource_pools (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/resources (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/ros_count (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/segmentation-islands1 (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/segmentation-islands2 (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/sessions (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/storage-containers (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/storage-locations (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/table_locks (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/user_sessions (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-interactive-mode/vertica_users (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/snippets/sql-mode/.yas-parents (100%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/vertica-snippets-autoloads.el (92%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/vertica-snippets-pkg.el (71%) rename elpa/{vertica-snippets-20191213.1109 => vertica-snippets-20200423.1200}/vertica-snippets.el (100%) diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pool_status2 b/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pool_status2 deleted file mode 100644 index 4d56047c..00000000 --- a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pool_status2 +++ /dev/null @@ -1,14 +0,0 @@ -# -*- mode: snippet -*- -# name: resource_pool_status2 -# key: rps2_ -# group: vertica -# condition: (if (string-equal sql-product 'vertica)t) -# -- -SELECT sysdate AS CURRENT_TIME, - node_name, - pool_name, - TO_CHAR( memory_inuse_kb / 1024, '999g999g999g999') AS memory_inuse_mb, - TO_CHAR( general_memory_borrowed_kb / 1024, '999g999g999g999') AS general_memory_borrowed_mb, - running_query_count - FROM resource_pool_status -ORDER BY 1,3,2;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/.dir-locals.el b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/.dir-locals.el similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/.dir-locals.el rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/.dir-locals.el diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/busy-hours b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/busy-hours similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/busy-hours rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/busy-hours diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/check_rle_overridden similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/check_rle_overridden rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/check_rle_overridden diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/config-changes b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/config-changes similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/config-changes rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/config-changes diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/current_epoch similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/current_epoch diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/errors similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/errors diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/external_table_details b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/external_table_details similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/external_table_details rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/external_table_details diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/format_numbers b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/format_numbers similarity index 83% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/format_numbers rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/format_numbers index 302d2329..379eac4c 100644 --- a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/format_numbers +++ b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/format_numbers @@ -5,4 +5,4 @@ # condition: (if (string-equal sql-product 'vertica)t) # expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) # -- -TO_CHAR( $0, '999g999g999g999') AS \ No newline at end of file +TO_CHAR( $1, '999g999g999g990d99') AS $0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-partitions similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-partitions diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-projections similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/get-projections diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/grants similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/grants diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/last-statement-timing b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-statement-timing similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/last-statement-timing rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-statement-timing diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/last-vertica-updates b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-vertica-updates similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/last-vertica-updates rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/last-vertica-updates diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/licence-history b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/licence-history similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/licence-history rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/licence-history diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/list-backups b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-backups similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/list-backups rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-backups diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/list-tables-row-count-size b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-tables-row-count-size similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/list-tables-row-count-size rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/list-tables-row-count-size diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/nodes similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/nodes rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/pool_queues b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pool_queues similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/pool_queues rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pool_queues diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/projection_storage b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/projection_storage similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/projection_storage rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/projection_storage diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/pset_footer b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pset_footer similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/pset_footer rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/pset_footer diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-acquisition-queue b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-acquisition-queue similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-acquisition-queue rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-acquisition-queue diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-event-issues b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-event-issues similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-event-issues rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-event-issues diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-long-acquisitions b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-long-acquisitions similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-long-acquisitions rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-long-acquisitions diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-requests b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-requests rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-requests-expensive b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-expensive similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-requests-expensive rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-expensive diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-requests-overview b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-overview similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-requests-overview rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-requests-overview diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-times b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-times similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/query-times rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/query-times diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/rebalance_projection_status b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_projection_status similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/rebalance_projection_status rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_projection_status diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_status similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_status diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/rebalance_times b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_times similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/rebalance_times rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/rebalance_times diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource-pool-move similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource-pool-move diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pool_status b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pool_status rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status diff --git a/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status2 b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status2 new file mode 100644 index 00000000..2dffc908 --- /dev/null +++ b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pool_status2 @@ -0,0 +1,15 @@ +# -*- mode: snippet -*- +# name: resource_pool_status2 +# key: rps2_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT sysdate AS CURRENT_TIME, + node_name, + pool_name, + TO_CHAR( memory_inuse_kb / 1024 / 1024, '999g999g999g990d99') AS memory_inuse_gb, + TO_CHAR( general_memory_borrowed_kb / 1024 / 1024, '999g999g999g990d99') AS general_memory_borrowed_gb, + running_query_count, + max_concurrency + FROM resource_pool_status +WHERE running_query_count > 0;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pools b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pools similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resource_pools rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resource_pools diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resources similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/resources diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/ros_count b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/ros_count similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/ros_count rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/ros_count diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/segmentation-islands1 b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands1 similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/segmentation-islands1 rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands1 diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/segmentation-islands2 b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands2 similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/segmentation-islands2 rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/segmentation-islands2 diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/sessions similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/sessions diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-containers similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-containers diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-locations similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/storage-locations rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/storage-locations diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/table_locks b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/table_locks similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/table_locks rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/table_locks diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/user_sessions similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/user_sessions diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/vertica_users similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20200423.1200/snippets/sql-interactive-mode/vertica_users diff --git a/elpa/vertica-snippets-20191213.1109/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20200423.1200/snippets/sql-mode/.yas-parents similarity index 100% rename from elpa/vertica-snippets-20191213.1109/snippets/sql-mode/.yas-parents rename to elpa/vertica-snippets-20200423.1200/snippets/sql-mode/.yas-parents diff --git a/elpa/vertica-snippets-20191213.1109/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el similarity index 92% rename from elpa/vertica-snippets-20191213.1109/vertica-snippets-autoloads.el rename to elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el index 756a1bef..5f769b7b 100644 --- a/elpa/vertica-snippets-20191213.1109/vertica-snippets-autoloads.el +++ b/elpa/vertica-snippets-20200423.1200/vertica-snippets-autoloads.el @@ -11,9 +11,7 @@ ;;; 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) +Add snippet dir to yas-snippet-dirs and load it." nil nil) (eval-after-load 'yasnippet '(vertica-snippets-initialize)) diff --git a/elpa/vertica-snippets-20191213.1109/vertica-snippets-pkg.el b/elpa/vertica-snippets-20200423.1200/vertica-snippets-pkg.el similarity index 71% rename from elpa/vertica-snippets-20191213.1109/vertica-snippets-pkg.el rename to elpa/vertica-snippets-20200423.1200/vertica-snippets-pkg.el index 99e0b887..683f2a74 100644 --- a/elpa/vertica-snippets-20191213.1109/vertica-snippets-pkg.el +++ b/elpa/vertica-snippets-20200423.1200/vertica-snippets-pkg.el @@ -1,11 +1,11 @@ -(define-package "vertica-snippets" "20191213.1109" "Yasnippets for Vertica" +(define-package "vertica-snippets" "20200423.1200" "Yasnippets for Vertica" '((yasnippet "0.6.1")) - :keywords - '("convenience" "snippets") - :authors + :commit "6ced718d9120878878700592fab430a8542b748f" :authors '(("Andreas Gerler" . "baron@bundesbrandschatzamt.de")) :maintainer '("Andreas Gerler" . "baron@bundesbrandschatzamt.de") + :keywords + '("convenience" "snippets") :url "https://github.com/baron42bba/vertica-snippets") ;; Local Variables: ;; no-byte-compile: t diff --git a/elpa/vertica-snippets-20191213.1109/vertica-snippets.el b/elpa/vertica-snippets-20200423.1200/vertica-snippets.el similarity index 100% rename from elpa/vertica-snippets-20191213.1109/vertica-snippets.el rename to elpa/vertica-snippets-20200423.1200/vertica-snippets.el -- 2.47.3