From 7ecada72ead5eae88a8b726104de5e2d367af994 Mon Sep 17 00:00:00 2001
From: Andreas Gerler <baron@bundesbrandschatzamt.de>
Date: Tue, 12 May 2015 21:06:07 +0200
Subject: [PATCH] new yasnippets to use orgmode sql with MySQL and Oracle via
 Perl/DBD::Oracle/dbish.

Signed-off-by: Andreas Gerler <baron@bundesbrandschatzamt.de>
---
 snippets/org-mode/sqlmysql | 14 ++++++++++++++
 snippets/org-mode/sqlora   | 11 +++++++++++
 2 files changed, 25 insertions(+)
 create mode 100644 snippets/org-mode/sqlmysql
 create mode 100644 snippets/org-mode/sqlora

diff --git a/snippets/org-mode/sqlmysql b/snippets/org-mode/sqlmysql
new file mode 100644
index 00000000..0a75beb1
--- /dev/null
+++ b/snippets/org-mode/sqlmysql
@@ -0,0 +1,14 @@
+# -*- mode: snippets -*-
+# name: sqlmysql
+# expand-env: ((yas-indent-line 'fixed))
+# key: sqlmysql
+# --
+:PROPERTIES:
+:engine: mysql
+:dbhost: ${1:localhost}
+:dbuser: ${2:user}
+:dbpassword: ${3:password}
+:cmdline: --protocol=tcp
+:exports: both
+:END:
+$0
\ No newline at end of file
diff --git a/snippets/org-mode/sqlora b/snippets/org-mode/sqlora
new file mode 100644
index 00000000..991d188e
--- /dev/null
+++ b/snippets/org-mode/sqlora
@@ -0,0 +1,11 @@
+# -*- mode: snippets -*-
+# name: sqlora
+# expand-env: ((yas-indent-line 'fixed))
+# key: sqlora
+# --
+:PROPERTIES:
+:engine: dbi
+:cmdline: dbi:Oracle://${1:localhost}:${2:1521}/${3:SID} ${4:user} ${5:password}
+:exports: both
+:END:
+$0
\ No newline at end of file
-- 
2.47.3