Date: Mon, 6 May 2013 14:10:45 +0000 (UTC) From: TAKATSU Tomonari <tota@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r317518 - in head/textproc: . mysqlviz mysqlviz/files Message-ID: <201305061410.r46EAjW9018313@svn.freebsd.org>
next in thread | raw e-mail | index | archive | help
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@FreeBSD.org> +# $FreeBSD$ + +PORTNAME= mysqlviz +PORTVERSION= 0.3 +CATEGORIES= textproc +MASTER_SITES= GOOGLE_CODE + +MAINTAINER= tota@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/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201305061410.r46EAjW9018313>