From 4f7c57f83dad7779325929291cc04371086af01f Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Thu, 5 Dec 2019 19:29:23 +0100 Subject: [PATCH] update vertica-snippets --- .../sql-interactive-mode/.dir-locals.el | 7 +++++++ .../snippets/sql-interactive-mode/busy-hours | 0 .../sql-interactive-mode/check_rle_overridden | 0 .../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 .../sql-interactive-mode/format_numbers | 0 .../sql-interactive-mode/get-partitions | 0 .../sql-interactive-mode/get-projections | 0 .../snippets/sql-interactive-mode/grants | 0 .../sql-interactive-mode/last-statement-timing | 0 .../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 | 15 +++++++++++++++ .../snippets/sql-interactive-mode/pset_footer | 0 .../query-acquisition-queue | 0 .../sql-interactive-mode/query-event-issues | 0 .../query-long-acquisitions | 0 .../sql-interactive-mode/query-requests | 0 .../query-requests-overview | 17 +++++++++++++++++ .../snippets/sql-interactive-mode/query-times | 0 .../sql-interactive-mode/rebalance_status | 0 .../sql-interactive-mode/resource-pool-move | 0 .../sql-interactive-mode/resource_pool_status | 16 ++++++++++++++++ .../sql-interactive-mode/resource_pools | 0 .../snippets/sql-interactive-mode/resources | 0 .../snippets/sql-interactive-mode/ros_count | 16 ++++++++++++++++ .../snippets/sql-interactive-mode/sessions | 0 .../sql-interactive-mode/storage-containers | 0 .../sql-interactive-mode/storage-locations | 0 .../snippets/sql-interactive-mode/table_locks | 12 ++++++++++++ .../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 | 2 +- .../vertica-snippets.el | 0 41 files changed, 94 insertions(+), 6 deletions(-) create mode 100644 elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/.dir-locals.el rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/busy-hours (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/check_rle_overridden (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/config-changes (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/current_epoch (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/errors (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/external_table_details (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/format_numbers (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/get-partitions (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/get-projections (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/grants (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/last-statement-timing (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/licence-history (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/list-backups (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/list-tables-row-count-size (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/nodes (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/pool_queues (100%) create mode 100644 elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/projection_storage rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/pset_footer (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/query-acquisition-queue (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/query-event-issues (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/query-long-acquisitions (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/query-requests (100%) create mode 100644 elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-requests-overview rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/query-times (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/rebalance_status (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/resource-pool-move (100%) create mode 100644 elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource_pool_status rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/resource_pools (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/resources (100%) create mode 100644 elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/ros_count rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/sessions (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/storage-containers (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/storage-locations (100%) create mode 100644 elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/table_locks rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/user_sessions (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-interactive-mode/vertica_users (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/snippets/sql-mode/.yas-parents (100%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/vertica-snippets-autoloads.el (61%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/vertica-snippets-pkg.el (83%) rename elpa/{vertica-snippets-20191007.1546 => vertica-snippets-20191205.1016}/vertica-snippets.el (100%) diff --git a/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/.dir-locals.el b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/.dir-locals.el new file mode 100644 index 00000000..584e23ec --- /dev/null +++ b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/.dir-locals.el @@ -0,0 +1,7 @@ +;;; Directory Local Variables +;;; For more information see (info "(emacs) Directory Variables") + +((fundamental-mode + (mode . snippet)) + ) + diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/busy-hours b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/busy-hours similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/busy-hours rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/busy-hours diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/check_rle_overridden b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/check_rle_overridden similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/check_rle_overridden rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/check_rle_overridden diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/config-changes b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/config-changes similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/config-changes rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/config-changes diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/current_epoch b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/current_epoch similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/current_epoch rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/current_epoch diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/errors b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/errors similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/errors rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/errors diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/external_table_details b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/external_table_details similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/external_table_details rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/external_table_details diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/format_numbers b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/format_numbers similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/format_numbers rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/format_numbers diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/get-partitions b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/get-partitions similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/get-partitions rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/get-partitions diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/get-projections b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/get-projections similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/get-projections rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/get-projections diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/grants b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/grants similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/grants rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/grants diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/last-statement-timing b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/last-statement-timing similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/last-statement-timing rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/last-statement-timing diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/licence-history b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/licence-history similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/licence-history rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/licence-history diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/list-backups b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/list-backups similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/list-backups rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/list-backups diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/list-tables-row-count-size b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/list-tables-row-count-size similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/list-tables-row-count-size rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/list-tables-row-count-size diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/nodes b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/nodes similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/nodes rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/nodes diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/pool_queues b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/pool_queues similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/pool_queues rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/pool_queues diff --git a/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/projection_storage b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/projection_storage new file mode 100644 index 00000000..18102a09 --- /dev/null +++ b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/projection_storage @@ -0,0 +1,15 @@ +# -*- mode: snippet -*- +# name: projection_storage +# key: ps_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT node_name, + projection_schema, + projection_name, + (SUM(used_bytes)/1024^3)::INT size_in_GB + FROM projection_storage + WHERE anchor_table_name = '$1' + GROUP BY 1,2,3 + ORDER BY 2,3,1 + LIMIT 20;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/pset_footer b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/pset_footer similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/pset_footer rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/pset_footer diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-acquisition-queue b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-acquisition-queue similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-acquisition-queue rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-acquisition-queue diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-event-issues b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-event-issues similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-event-issues rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-event-issues diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-long-acquisitions b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-long-acquisitions similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-long-acquisitions rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-long-acquisitions diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-requests b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-requests similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-requests rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-requests diff --git a/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-requests-overview b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-requests-overview new file mode 100644 index 00000000..da6332ae --- /dev/null +++ b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-requests-overview @@ -0,0 +1,17 @@ +# -*- mode: snippet -*- +# name: query-requests-overview +# key: qro_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# expand-env: ((yas/indent-line 'auto) (yas/wrap-around-region 't)) +# -- +SELECT user_name, + start_timestamp, + request_duration_ms, + transaction_id, + STATEMENT_ID, + substr(request, 0, 1000) AS request + FROM v_monitor.query_requests +WHERE transaction_id > 0 +ORDER BY request_duration_ms DESC +LIMIT 10;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-times b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-times similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/query-times rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/query-times diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/rebalance_status b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/rebalance_status similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/rebalance_status rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/rebalance_status diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/resource-pool-move b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource-pool-move similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/resource-pool-move rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource-pool-move diff --git a/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource_pool_status b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource_pool_status new file mode 100644 index 00000000..b12a00f3 --- /dev/null +++ b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource_pool_status @@ -0,0 +1,16 @@ +# -*- mode: snippet -*- +# name: resource_pool_status +# key: rps_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT node_name, + pool_name, + TO_CHAR( memory_size_kb / 1024, '999g999g999g999') AS memory_size_mb, + TO_CHAR( max_memory_size_kb / 1024, '999g999g999g999') AS max_memory_size_mb, + TO_CHAR( memory_size_actual_kb / 1024, '999g999g999g999') AS memory_size_actual_mb, + planned_concurrency, + TO_CHAR( query_budget_kb / 1024 , '999g999g999g999') AS query_budget_mb + FROM resource_pool_status + WHERE pool_name = '$1' + ORDER BY 1,2;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/resource_pools b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource_pools similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/resource_pools rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resource_pools diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/resources b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resources similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/resources rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/resources diff --git a/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/ros_count b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/ros_count new file mode 100644 index 00000000..35c1b18b --- /dev/null +++ b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/ros_count @@ -0,0 +1,16 @@ +# -*- mode: snippet -*- +# name: ros_count +# key: ro_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT node_name, + projection_schema, + projection_name, + SUM(ros_count) AS ros_count + FROM v_monitor.projection_storage + GROUP BY node_name, + projection_schema, + projection_name + HAVING SUM(ros_count) > 100 + ORDER BY ros_count DESC;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/sessions b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/sessions similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/sessions rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/sessions diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/storage-containers b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/storage-containers similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/storage-containers rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/storage-containers diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/storage-locations b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/storage-locations similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/storage-locations rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/storage-locations diff --git a/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/table_locks b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/table_locks new file mode 100644 index 00000000..973008bf --- /dev/null +++ b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/table_locks @@ -0,0 +1,12 @@ +# -*- mode: snippet -*- +# name: table_locks +# key: tl_ +# group: vertica +# condition: (if (string-equal sql-product 'vertica)t) +# -- +SELECT locks.lock_mode, + locks.lock_scope, + substr(locks.transaction_description, 1, 100) AS "left", + locks.request_timestamp, + locks.grant_timestamp + FROM v_monitor.locks;$0 \ No newline at end of file diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/user_sessions b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/user_sessions similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/user_sessions rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/user_sessions diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/vertica_users b/elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/vertica_users similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-interactive-mode/vertica_users rename to elpa/vertica-snippets-20191205.1016/snippets/sql-interactive-mode/vertica_users diff --git a/elpa/vertica-snippets-20191007.1546/snippets/sql-mode/.yas-parents b/elpa/vertica-snippets-20191205.1016/snippets/sql-mode/.yas-parents similarity index 100% rename from elpa/vertica-snippets-20191007.1546/snippets/sql-mode/.yas-parents rename to elpa/vertica-snippets-20191205.1016/snippets/sql-mode/.yas-parents diff --git a/elpa/vertica-snippets-20191007.1546/vertica-snippets-autoloads.el b/elpa/vertica-snippets-20191205.1016/vertica-snippets-autoloads.el similarity index 61% rename from elpa/vertica-snippets-20191007.1546/vertica-snippets-autoloads.el rename to elpa/vertica-snippets-20191205.1016/vertica-snippets-autoloads.el index 20d0609e..756a1bef 100644 --- a/elpa/vertica-snippets-20191007.1546/vertica-snippets-autoloads.el +++ b/elpa/vertica-snippets-20191205.1016/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" (23994 -;;;;;; 46376 342293 671000)) +;;;### (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") (23994 46376 -;;;;;; 343407 998000)) +;;;### (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-20191007.1546/vertica-snippets-pkg.el b/elpa/vertica-snippets-20191205.1016/vertica-snippets-pkg.el similarity index 83% rename from elpa/vertica-snippets-20191007.1546/vertica-snippets-pkg.el rename to elpa/vertica-snippets-20191205.1016/vertica-snippets-pkg.el index 2411512a..0a713c75 100644 --- a/elpa/vertica-snippets-20191007.1546/vertica-snippets-pkg.el +++ b/elpa/vertica-snippets-20191205.1016/vertica-snippets-pkg.el @@ -1,4 +1,4 @@ -(define-package "vertica-snippets" "20191007.1546" "Yasnippets for Vertica" +(define-package "vertica-snippets" "20191205.1016" "Yasnippets for Vertica" '((yasnippet "0.6.1")) :keywords '("convenience" "snippets") diff --git a/elpa/vertica-snippets-20191007.1546/vertica-snippets.el b/elpa/vertica-snippets-20191205.1016/vertica-snippets.el similarity index 100% rename from elpa/vertica-snippets-20191007.1546/vertica-snippets.el rename to elpa/vertica-snippets-20191205.1016/vertica-snippets.el -- 2.47.3