Emma is a graphical toolkit for MySQL database developers and administrators.

It provides dialogs to create or modify MySQL databases, tables and
associated indexes.  It has a built-in syntax highlighting SQL editor with
table- and fieldname tab-completion and automatic SQL statement formatting.
The results of an executed query are displayed in a resultset where the record-
data can be edited by the user, if the SQL statement allows for it. The SQL
editor and resultset-view are grouped in tabs. Results can be exported to CSV
files. Multiple simultaneously opened MySQL connections are possible.

WWW: http://www.fastflo.de/projects/emma

PR:		ports/106229
Submitted by:	Junji NAKANISHI <jun-g@daemonfreaks.com>

5 files changed, 84 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 65efaaba5aa9..4a6fbc620c3b 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -40,6 +40,7 @@
     SUBDIR += dbtool
     SUBDIR += dbview
     SUBDIR += edb
+    SUBDIR += emma
     SUBDIR += erlang-mysql
     SUBDIR += erserver
     SUBDIR += evolution-data-server
diff --git a/databases/emma/Makefile b/databases/emma/Makefile
new file mode 100644
index 000000000000..f3c444cb4a09
--- /dev/null
+++ b/databases/emma/Makefile
@@ -0,0 +1,25 @@
+# New ports collection makefile for:	emma
+# Date created:				2 December 2006
+# Whom:					Junji NAKANISHI <jun-g@daemonfreaks.com>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	emma
+PORTVERSION=	0.6
+CATEGORIES=	databases
+MASTER_SITES=	http://www.fastflo.de/files/emma/downloads/python_src/
+
+MAINTAINER=	jun-g@daemonfreaks.com
+COMMENT=	Extendable MySQL managing assistant
+
+RUN_DEPENDS=	${PYTHON_SITELIBDIR}/MySQLdb/__init__.py:${PORTSDIR}/databases/py-MySQLdb
+
+USE_GNOME=	pygtk2
+USE_PYTHON=	yes
+USE_PYDISTUTILS=yes
+
+pre-patch:
+	@${REINPLACE_CMD} -e 's|python2.4|env python|' ${WRKSRC}/emma
+
+.include <bsd.port.mk>
diff --git a/databases/emma/distinfo b/databases/emma/distinfo
new file mode 100644
index 000000000000..a6677ae2a5f1
--- /dev/null
+++ b/databases/emma/distinfo
@@ -0,0 +1,3 @@
+MD5 (emma-0.6.tar.gz) = da3bd1d1f4ee75d02a4c8637e28fd732
+SHA256 (emma-0.6.tar.gz) = ecbec283df27ebc73fe89fea77260d29b37919c4403542cd94b6ea88b6e75a7e
+SIZE (emma-0.6.tar.gz) = 60753
diff --git a/databases/emma/pkg-descr b/databases/emma/pkg-descr
new file mode 100644
index 000000000000..3cd1defb40e5
--- /dev/null
+++ b/databases/emma/pkg-descr
@@ -0,0 +1,10 @@
+Emma is a graphical toolkit for MySQL database developers and administrators.
+It provides dialogs to create or modify MySQL databases, tables and
+associated indexes.  It has a built-in syntax highlighting SQL editor with
+table- and fieldname tab-completion and automatic SQL statement formatting.
+The results of an executed query are displayed in a resultset where the record-
+data can be edited by the user, if the SQL statement allows for it. The SQL
+editor and resultset-view are grouped in tabs. Results can be exported to CSV
+files. Multiple simultaneously opened MySQL connections are possible.
+
+WWW: http://www.fastflo.de/projects/emma
diff --git a/databases/emma/pkg-plist b/databases/emma/pkg-plist
new file mode 100644
index 000000000000..b98148e54cdb
--- /dev/null
+++ b/databases/emma/pkg-plist
@@ -0,0 +1,45 @@
+bin/emma
+share/emma/changelog
+share/emma/glade/emma.glade
+share/emma/glade/table_editor.glade
+share/emma/icons/db.png
+share/emma/icons/emma.png
+share/emma/icons/field.png
+share/emma/icons/host.png
+share/emma/icons/index.png
+share/emma/icons/index_primary.png
+share/emma/icons/index_unique.png
+share/emma/icons/offline_host.png
+share/emma/icons/table.png
+share/emma/theme/README.html
+share/emma/theme/gtk-2.0/gtkrc
+@dirrm share/emma/theme/gtk-2.0
+@dirrm share/emma/theme
+@dirrm share/emma/icons
+@dirrm share/emma/glade
+@dirrm share/emma
+%%PYTHON_SITELIBDIR%%/emmalib/__init__.py
+%%PYTHON_SITELIBDIR%%/emmalib/__init__.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/__init__.pyo
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_db.py
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_db.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_db.pyo
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_host.py
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_host.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_host.pyo
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_query_tab.py
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_query_tab.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_query_tab.pyo
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_table.py
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_table.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/mysql_table.pyo
+%%PYTHON_SITELIBDIR%%/emmalib/plugins/pretty_format/__init__.py
+%%PYTHON_SITELIBDIR%%/emmalib/plugins/pretty_format/__init__.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/plugins/pretty_format/__init__.pyo
+%%PYTHON_SITELIBDIR%%/emmalib/plugins/table_editor/__init__.py
+%%PYTHON_SITELIBDIR%%/emmalib/plugins/table_editor/__init__.pyc
+%%PYTHON_SITELIBDIR%%/emmalib/plugins/table_editor/__init__.pyo
+@dirrm %%PYTHON_SITELIBDIR%%/emmalib/plugins/table_editor
+@dirrm %%PYTHON_SITELIBDIR%%/emmalib/plugins/pretty_format
+@dirrm %%PYTHON_SITELIBDIR%%/emmalib/plugins
+@dirrm %%PYTHON_SITELIBDIR%%/emmalib