Merge pull request #12 from fengtan/trac_export_attachments
Add script to make Trac wiki attachments understandable by the UWC
diff --git a/trac_export_attachments.php b/trac_export_attachments.php
new file mode 100644
index 0000000..90f4ee1
--- /dev/null
+++ b/trac_export_attachments.php
@@ -0,0 +1,33 @@
+<?php
+
+/**
+ * Dumps Trac wiki attachments in a format understandable by the UWC.
+ *
+ * This script assumes Trac uses a Postgres server.
+ */
+
+$dbhost = 'localhost'; // Trac DB host
+$dbuser = 'trac'; // Trac DB username
+$dbpass = ''; // Trac DB password
+$dbname = 'trac'; // Trac DB name
+$rootdir = '/tmp/trac-attachments'; // Attachments will be dumped into this folder
+$tracenv = '/var/www/trac'; // Path to Trac environment
+
+
+$rs = pg_query("SELECT id,filename FROM attachment WHERE type='wiki'") or die ('query failed ' . pg_last_error());
+
+echo "#!/bin/bash\n";
+while($row = pg_fetch_array($rs)) {
+ $id = $row['id'];
+ $name = escapeshellarg($row['filename']);
+ $filedir = "$rootdir/$id";
+ $filepath = escapeshellarg($filedir . '/' . $row['filename']);
+ echo "echo mkdir -p $filedir\n";
+ echo "mkdir -p $filedir\n";
+ $command = "trac-admin $tracenv attachment export wiki:" . $id . " " . $name . " " . $filepath;
+ echo "echo $command\n";
+ echo $command . "\n";
+}
+pg_free_result($rs);
+pg_close($conn);
+
