From 6854cb3f4d8219cf1829e32122eb2502a916eae9 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sat, 1 Feb 2020 09:05:48 +0100
Subject: initial checkin

---
 setup/exportdb.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 setup/exportdb.php

(limited to 'setup/exportdb.php')

diff --git a/setup/exportdb.php b/setup/exportdb.php
new file mode 100644
index 0000000..fd714a3
--- /dev/null
+++ b/setup/exportdb.php
@@ -0,0 +1,27 @@
+<?php
+ 
+error_reporting(E_ALL);
+
+die('Enable me by commenting this out by editing '.basename(__FILE__).' at line '.__LINE__);
+
+require_once '../vendor/adodb/adodb-php/adodb.inc.php';
+require_once '../vendor/adodb/adodb-php/adodb-xmlschema03.inc.php';
+
+$conf = @parse_ini_file('../flyspray.conf.php', true) or die('Cannot open config file.');
+
+/* Start by creating a normal ADODB connection. */
+$db = ADONewConnection($conf['database']['dbtype']);
+$db->Connect( $conf['database']['dbhost'], $conf['database']['dbuser'],
+              $conf['database']['dbpass'], $conf['database']['dbname']) or die('Cannot connect to DB.');
+$db->debug= true;
+
+/* Use the database connection to create a new adoSchema object. */
+$schema = new adoSchema($db);
+
+$withdata=false;
+$stripprefix=true;
+$data = $schema->ExtractSchema( $withdata, '  ', $conf['database']['dbprefix'], $stripprefix);
+
+file_put_contents('flyspray-schema.xml', $data);
+
+?>
-- 
cgit v1.2.3-70-g09d2