From 2599aad31087bf16bdb89f6307c816f48a54768b Mon Sep 17 00:00:00 2001
From: Andreas Gerler <baron@bundesbrandschatzamt.de>
Date: Sun, 9 Oct 2016 16:19:47 +0200
Subject: [PATCH] adding yasnippets for sql-mode

- lstables support different sql-products.

Signed-off-by: Andreas Gerler <baron@bundesbrandschatzamt.de>
---
 snippets/{sql-vertica-mode => sql-mode}/lsresources |  0
 snippets/{sql-vertica-mode => sql-mode}/lsschemas   |  0
 snippets/sql-mode/lstables                          | 10 ++++++++++
 snippets/{sql-vertica-mode => sql-mode}/lsusers     |  0
 snippets/sql-vertica-mode/lstables                  |  5 -----
 5 files changed, 10 insertions(+), 5 deletions(-)
 rename snippets/{sql-vertica-mode => sql-mode}/lsresources (100%)
 rename snippets/{sql-vertica-mode => sql-mode}/lsschemas (100%)
 create mode 100644 snippets/sql-mode/lstables
 rename snippets/{sql-vertica-mode => sql-mode}/lsusers (100%)
 delete mode 100644 snippets/sql-vertica-mode/lstables

diff --git a/snippets/sql-vertica-mode/lsresources b/snippets/sql-mode/lsresources
similarity index 100%
rename from snippets/sql-vertica-mode/lsresources
rename to snippets/sql-mode/lsresources
diff --git a/snippets/sql-vertica-mode/lsschemas b/snippets/sql-mode/lsschemas
similarity index 100%
rename from snippets/sql-vertica-mode/lsschemas
rename to snippets/sql-mode/lsschemas
diff --git a/snippets/sql-mode/lstables b/snippets/sql-mode/lstables
new file mode 100644
index 00000000..bc20e970
--- /dev/null
+++ b/snippets/sql-mode/lstables
@@ -0,0 +1,10 @@
+# -*- mode: snippet -*-
+# name: lstables
+# key: ls-tables
+# --
+`(pcase sql-product
+       ('mysql (insert-string "SHOW TABLES LIKE "))
+       ('postgres (insert-string "SELECT * FROM pg_catalog.pg_tables WHERE table_name LIKE "))
+       ('vertica (insert-string "SELECT TABLE_NAME FROM TABLES WHERE TABLE_SCHEMA ="))
+       (- (insert-string "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE "))
+       )`'$1';$0
\ No newline at end of file
diff --git a/snippets/sql-vertica-mode/lsusers b/snippets/sql-mode/lsusers
similarity index 100%
rename from snippets/sql-vertica-mode/lsusers
rename to snippets/sql-mode/lsusers
diff --git a/snippets/sql-vertica-mode/lstables b/snippets/sql-vertica-mode/lstables
deleted file mode 100644
index ee348fce..00000000
--- a/snippets/sql-vertica-mode/lstables
+++ /dev/null
@@ -1,5 +0,0 @@
-# -*- mode: snippet -*-
-# name: lstables
-# key: ls-tables
-# --
-SELECT TABLE_NAME FROM TABLES WHERE TABLE_SCHEMA = '$1';$0
\ No newline at end of file
-- 
2.47.3