From 2ffdf3118756a05fc5396caf1ffbf07f606543b7 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Mon, 30 Jan 2017 21:28:12 +0000
Subject: [PATCH] dbq_template

---
 etc/profile.d/dbq.sh            |  6 ++++++
 share/templates/mutt-google.php | 38 +++++++++++++++++++++++++++++++++
 2 files changed, 44 insertions(+)
 create mode 100644 share/templates/mutt-google.php

diff --git a/etc/profile.d/dbq.sh b/etc/profile.d/dbq.sh
index e6e6f106..a88e08e3 100644
--- a/etc/profile.d/dbq.sh
+++ b/etc/profile.d/dbq.sh
@@ -15,3 +15,9 @@ dbq2pgsql() {
 dbq_data_src() {
   eval $(dbq t=data_src header=0 format=csv rows.fields=src name=$1)
 }
+
+dbq_template() {
+  local t=$1
+  shift
+  dbq f=template idtemplate=$t $@
+}
diff --git a/share/templates/mutt-google.php b/share/templates/mutt-google.php
new file mode 100644
index 00000000..c7e2b1a4
--- /dev/null
+++ b/share/templates/mutt-google.php
@@ -0,0 +1,38 @@
+<?php
+# NB 29.01.17: Mutt google template 
+# See: https://blog.bartbania.com/raspberry_pi/consolify-your-gmail-with-mutt/
+
+# Aliases
+foreach ([
+  'mail',
+  'login',
+  'id',
+] as $p) {
+  if (!empty($ROW['email'])) break;
+  if (isset($ROW[$p])) $ROW['email'] = $ROW[$p];
+}
+foreach ([
+  'password',
+  'value',
+] as $p) {
+  if (!empty($ROW['passwd'])) break;
+  if (isset($ROW[$p])) $ROW['passwd'] = $ROW[$p];
+}
+?>
+account-hook imap://mail.gmail.com/ ""
+set from=<?=$ROW['email']?>
+
+set imap_user=<?=$ROW['email']?>
+set imap_pass=<?=$ROW['passwd']?>
+
+set smtp_url=smtp://<?=$ROW['email']?>@smtp.gmail.com:587/
+set smtp_pass=<?=$ROW['passwd']?>
+
+set folder=imaps://imap.gmail.com:993
+set spoolfile=+INBOX
+set postponed=+[Gmail]/Drafts
+set trash='+[Google Mail]/Trash'
+
+set move = no  #Stop asking to move read messages to mbox!
+set imap_keepalive = 900
+#set timeout=15
-- 
2.47.3