From f0863085c7f865069e0d49a99488734abe044c6a Mon Sep 17 00:00:00 2001
From: lassulus <lass@aidsballs.de>
Date: Wed, 13 Apr 2016 16:37:26 +0200
Subject: l 5: add mk_sql_pair

---
 lass/5pkgs/mk_sql_pair/default.nix | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 lass/5pkgs/mk_sql_pair/default.nix

(limited to 'lass/5pkgs/mk_sql_pair')

diff --git a/lass/5pkgs/mk_sql_pair/default.nix b/lass/5pkgs/mk_sql_pair/default.nix
new file mode 100644
index 00000000..a9f0d279
--- /dev/null
+++ b/lass/5pkgs/mk_sql_pair/default.nix
@@ -0,0 +1,19 @@
+{ pkgs, ... }:
+
+pkgs.writeScriptBin "mk_sql_pair" ''
+  #!/bin/sh
+
+  name=$1
+  password=$2
+
+  if [ $# -ne 2 ]; then
+    echo '$1=name, $2=password'
+    exit 23;
+  fi
+
+  cat <<EOF
+    create database $name;
+    create user $name;
+    grant all on $name.* to $name@'localhost' identified by '$password';
+  EOF
+''
-- 
cgit v1.2.3