svn commit: r317518 - in head/textproc: . mysqlviz mysqlviz/files

[TAKATSU Tomonari]

Author: tota
Date: Mon May  6 14:10:45 2013
New Revision: 317518
URL: http://svnweb.freebsd.org/changeset/ports/317518

Log:
  - Add new port: textproc/mysqlviz
  
    Render a graphical representation of a MySQL or SQLite database
    from a mysqldump or sqlite3 .dump file.
  
    Features:
    - Can infer foreign key relationships if you do not have them defined
    - Handles partial dumps (FK to tables that are not defined within the dump)
    - Fast! Uses sed and grep for data extraction (MySQL only)
  
    WWW: http://code.google.com/p/mysqlviz/

Added:
  head/textproc/mysqlviz/
  head/textproc/mysqlviz/Makefile   (contents, props changed)
  head/textproc/mysqlviz/distinfo   (contents, props changed)
  head/textproc/mysqlviz/files/
  head/textproc/mysqlviz/files/patch-mysqlviz   (contents, props changed)
  head/textproc/mysqlviz/pkg-descr   (contents, props changed)
Modified:
  head/textproc/Makefile

Modified: head/textproc/Makefile
==============================================================================
--- head/textproc/Makefile	Mon May  6 13:58:49 2013	(r317517)
+++ head/textproc/Makefile	Mon May  6 14:10:45 2013	(r317518)
@@ -457,6 +457,7 @@
     SUBDIR += multimarkdown
     SUBDIR += muse
     SUBDIR += mxml
+    SUBDIR += mysqlviz
     SUBDIR += mythes
     SUBDIR += nb-aspell
     SUBDIR += nds-aspell

Added: head/textproc/mysqlviz/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/textproc/mysqlviz/Makefile	Mon May  6 14:10:45 2013	(r317518)
@@ -0,0 +1,37 @@
+# Created by: TAKATSU Tomonari <tota at FreeBSD.org>
+# $FreeBSD$
+
+PORTNAME=	mysqlviz
+PORTVERSION=	0.3
+CATEGORIES=	textproc
+MASTER_SITES=	GOOGLE_CODE
+
+MAINTAINER=	tota at FreeBSD.org
+COMMENT=	MySQL and SQLite Database Visualisation Tool
+
+NO_BUILD=	yes
+USE_BZIP2=	yes
+USE_PHP=	yes
+WANT_PHP_CLI=	yes
+
+PLIST_FILES=	bin/${PORTNAME}
+
+PORTEXAMPLES=	eg.png eg.sql sqlite-eg.sql
+
+OPTIONS_DEFINE=	EXAMPLES
+
+.include <bsd.port.options.mk>
+
+post-patch:
+	@${REINPLACE_CMD} \
+		-e 's|/usr/bin/php|${LOCALBASE}/bin/php|' \
+		${WRKSRC}/${PORTNAME}
+
+do-install:
+	@${INSTALL_SCRIPT} ${WRKSRC}/${PORTNAME} ${PREFIX}/bin
+.if ${PORT_OPTIONS:MEXAMPLES}
+	@${MKDIR} ${EXAMPLESDIR}
+	@cd ${WRKSRC} && ${INSTALL_DATA} ${PORTEXAMPLES} ${EXAMPLESDIR}
+.endif
+
+.include <bsd.port.mk>

Added: head/textproc/mysqlviz/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/textproc/mysqlviz/distinfo	Mon May  6 14:10:45 2013	(r317518)
@@ -0,0 +1,2 @@
+SHA256 (mysqlviz-0.3.tar.bz2) = fdfc89771b821dfa6e9dda7a189d9f6d7db22a0bedb8450ba96dc08cf0221d8e
+SIZE (mysqlviz-0.3.tar.bz2) = 15377

Added: head/textproc/mysqlviz/files/patch-mysqlviz
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/textproc/mysqlviz/files/patch-mysqlviz	Mon May  6 14:10:45 2013	(r317518)
@@ -0,0 +1,25 @@
+--- mysqlviz.orig	2010-11-13 08:54:02.000000000 +0900
++++ mysqlviz	2013-05-06 17:56:14.000000000 +0900
+@@ -184,17 +184,16 @@
+ 
+ # usage information
+ function usage() {
+- global $argv;
+- print '[' . basename($argv[0]) . " - mysql + sqlite database visualisation tool]\n\n";
++ print "[mysqlviz - mysql + sqlite database visualisation tool]\n\n";
+  print "usage:\n";
+- print "  " . $argv[0] . " -f <sqldumpfile> [-r]\n";
+- print "                                 ^--- 'redump' mode: generates a\n";
+- print "                                      mysqldump command line to redump.\n";
++ print "  mysqlviz -f <sqldumpfile> [-r]\n";
++ print "                               ^--- 'redump' mode: generates a\n";
++ print "                                    mysqldump command line to redump.\n";
+  print "toolchain:\n";
+  print " $ mysqldump -d db >db.sql          # MySQL: -d = 'no data', only structure\n";
+  print "    - OR -\n";
+  print " $ sqlite database.db .dump >db.sql # SQLite (also: 'sqlite3 ...')\n";
+- print " $ $argv[0] -f ./db.sql >./db.dot # 'dot' is a graphviz format.\n";
++ print " $ mysqlviz -f ./db.sql >./db.dot # 'dot' is a graphviz format.\n";
+  print " $ dot -Tpng db.dot >db.png         # generate image with graphviz\n\n";
+  print "notes:\n";
+  print " if you do not have any foreign keys defined, relationships will be\n";

Added: head/textproc/mysqlviz/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/textproc/mysqlviz/pkg-descr	Mon May  6 14:10:45 2013	(r317518)
@@ -0,0 +1,9 @@
+Render a graphical representation of a MySQL or SQLite database
+from a mysqldump or sqlite3 .dump file.
+
+Features:
+- Can infer foreign key relationships if you do not have them defined
+- Handles partial dumps (FK to tables that are not defined within the dump)
+- Fast! Uses sed and grep for data extraction (MySQL only)
+
+WWW: http://code.google.com/p/mysqlviz/