Pma2wiki

See Also: MediaWiki/Syntax highlighting

#!/usr/bin/php
<?php
/**
 * This script is meant to be used as a command-line tool, or else as the target of a custom action within
 * Quanta
 * The script will get the contents of a file which is the generated output of a PHPMyAdmin SQL Schema export, and change the
 * format of the table defintion 'headings' into the H2 heading format suitable for posting into MediaWiki
 * This process creates easy to navigate and reference SQL schema files in the wiki
 * The exact tag output by this script (<sql> or <source lang=sql>) must correlate with the MediaWiki extension you use to get syntax highlighting
 * In any case, you need to have a GeSHi syntax highlighting extension active in your MediaWiki installation.
 *
 * @Usage
 * php /path/to/pma2wiki.php /some/pma-schema.sql
 */

$content = file_get_contents($argv[1]);



/** replace the
 * -- --------------------------------------------------------
 * with nothing
 */
$content = preg_replace ("/^[\s-]+$\n/m", '', $content);


/** Handle the 'header' output
 *  e.g.
-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-3
-- http://www.phpmyadmin.net
 */

$pattern = '/
-- phpMyAdmin SQL Dump
-- version (.*)$
-- http(.*)$
/mU';
$replacement = '
phpMyAdmin SQL Dump<br />
version $1<br />
http$2
';
$content = preg_replace ($pattern, $replacement, $content);

/**
 * Make the DB name a H2
 */
$pattern = '/^--[\s]([^:]+): `(.*)`$/mU';
$replacement = "== $1: $2 == \n";
$content = preg_replace ($pattern, $replacement, $content);

/** handle the heading metadata
 * e.g.
-- Host: foo.example.com
-- Generation Time: May 03, 2007 at 12:33 PM
-- Server version: 3.23.55
-- PHP Version: 5.2.0-8+etch1
--
-- Database: `myDatabase`
 */
$pattern = '/^--[\s]([^:]+): (.*)$/mU';
$replacement = "; $1: $2";
$content = preg_replace ($pattern, $replacement, $content);

/** replace the
 * -- Table --
 * comment with a
 * === Table ===
 * wiki syntax heading
 */
//$content = preg_replace("/^--\s+\n^-- Table structure for table `([^`]+)`\n^--\s+\n/imUs", "\n=== $1 ===\n", $content);
$content = preg_replace("/\n^-- Table structure for table `([^`]+)`$/imUs", "\n=== $1 ===\n", $content);

/** replace the
 * -- --------------------------------------------------------
 * with nothing
 */
$content = preg_replace ("/^[\s-]+$\n/m", '', $content);

/** wrap the CREATE statement in <sql> tags (relies on geshi)
 */
$pattern = '/(CREATE TABLE [^;]+;)/U';
// depends on GeSHi and which extension you have
$replacement = '<source lang=sql> 
$1

'; $content = preg_replace ($pattern, $replacement, $content);

// output the content so that the Quanta action can see it. echo $content; ?> </source>

PHP is the HyperText Preprocessor = the most popular programming language for the web