From 23bb68fe7e9cc8af176ff60b56e8a51a70f05a89 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Sun, 14 Feb 2021 01:35:10 +0000
Subject: Now generating pages directly from sqlite3

---
 tools/references/trac2down.py | 61 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 61 insertions(+)
 create mode 100644 tools/references/trac2down.py

(limited to 'tools/references/trac2down.py')

diff --git a/tools/references/trac2down.py b/tools/references/trac2down.py
new file mode 100644
index 0000000..c66a201
--- /dev/null
+++ b/tools/references/trac2down.py
@@ -0,0 +1,61 @@
+#!/usr/bin/env python2
+
+# Untested code from https://gist.githubusercontent.com/sgk/1286682/raw/b744dd2e47a68d60373ad39df87cfe8256f517af/trac2down.py
+
+# vim:set fileencoding=utf-8 sw=2 ai:
+
+import sqlite3
+import datetime
+import re
+
+SQL = '''
+  select
+      name, version, time, author, text
+    from
+      wiki w
+    where
+      version = (select max(version) from wiki where name = w.name)
+'''
+
+conn = sqlite3.connect('../trac.db')
+result = conn.execute(SQL)
+for row in result:
+  name = row[0]
+  version = row[1]
+  time = row[2]
+  author = row[3]
+  text = row[4]
+
+  text = re.sub('\r\n', '\n', text)
+  text = re.sub(r'{{{(.*?)}}}', r'`\1`', text)
+  def indent4(m):
+    return '\n    ' + m.group(1).replace('\n', '\n    ')
+  text = re.sub(r'(?sm){{{\n(.*?)\n}}}', indent4, text)
+  text = re.sub(r'(?m)^====\s+(.*?)\s+====$', r'#### \1', text)
+  text = re.sub(r'(?m)^===\s+(.*?)\s+===$', r'### \1', text)
+  text = re.sub(r'(?m)^==\s+(.*?)\s+==$', r'## \1', text)
+  text = re.sub(r'(?m)^=\s+(.*?)\s+=$', r'# \1', text)
+  text = re.sub(r'^       * ', r'****', text)
+  text = re.sub(r'^     * ', r'***', text)
+  text = re.sub(r'^   * ', r'**', text)
+  text = re.sub(r'^ * ', r'*', text)
+  text = re.sub(r'^ \d+. ', r'1.', text)
+
+  a = []
+  for line in text.split('\n'):
+    if not line.startswith('    '):
+      line = re.sub(r'\[(https?://[^\s\[\]]+)\s([^\[\]]+)\]', r'[\2](\1)', line)
+      line = re.sub(r'\[(wiki:[^\s\[\]]+)\s([^\[\]]+)\]', r'[\2](/\1/)', line)
+      line = re.sub(r'\!(([A-Z][a-z0-9]+){2,})', r'\1', line)
+      line = re.sub(r'\'\'\'(.*?)\'\'\'', r'*\1*', line)
+      line = re.sub(r'\'\'(.*?)\'\'', r'_\1_', line)
+    a.append(line)
+  text = '\n'.join(a)
+
+  fp = file('%s.md' % name, 'w')
+  print >>fp, '<!-- Name: %s -->' % name
+  print >>fp, '<!-- Version: %d -->' % version
+  print >>fp, '<!-- Last-Modified: %s -->' % datetime.datetime.fromtimestamp(time).strftime('%Y/%m/%d %H:%M:%S')
+  print >>fp, '<!-- Author: %s -->' % author
+  fp.write(text.encode('utf-8'))
+  fp.close()
-- 
cgit v1.2.3