Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 19 Aug 2001 04:45:25 +0200 (CEST)
From:      Cyrille Lefevre <clefevre@citeweb.net>
To:        FreeBSD-gnats-submit@freebsd.org
Subject:   ports/29862: New port: databases/mysql-gui (1.7.5)
Message-ID:  <200108190245.f7J2jPO52075@gits.dyndns.org>

next in thread | raw e-mail | index | archive | help

>Number:         29862
>Category:       ports
>Synopsis:       New port: databases/mysql-gui (1.7.5)
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Sat Aug 18 19:50:29 PDT 2001
>Closed-Date:
>Last-Modified:
>Originator:     Cyrille Lefevre
>Release:        FreeBSD 4.3-STABLE i386
>Organization:
ACME
>Environment:

FreeBSD gits 4.3-STABLE FreeBSD 4.3-STABLE #28: Wed Jul 25 09:04:25 CEST 2001     root@gits:/disk2/4.x-stable/src/sys/compile/CUSTOM  i386

>Description:

	A graphical SQL client for MySQL.

	http://www.mysql.com/downloads/gui-mysqlgui.html

	This port requires the fl_editor and flvw ports.

>How-To-Repeat:

	n/a

>Fix:

# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	mysql-gui/pkg-plist
#	mysql-gui/pkg-descr
#	mysql-gui/pkg-comment
#	mysql-gui/distinfo
#	mysql-gui/Makefile
#	mysql-gui/files/patch-Makefile
#	mysql-gui/files/patch-dodatni.cc
#	mysql-gui/files/patch-main.cc
#	mysql-gui/files/patch-single.cc
#	mysql-gui/files/patch-FL-Fl_Editor.H
#	mysql-gui/files/patch-FL-editengine.h
#
echo x - mysql-gui/pkg-plist
sed 's/^X//' >mysql-gui/pkg-plist << 'END-of-mysql-gui/pkg-plist'
X@comment $FreeBSD$
Xbin/mysqlgui
END-of-mysql-gui/pkg-plist
echo x - mysql-gui/pkg-descr
sed 's/^X//' >mysql-gui/pkg-descr << 'END-of-mysql-gui/pkg-descr'
XA graphical SQL client for MySQL.
X
XWWW: http://www.mysql.com/downloads/gui-mysqlgui.html
END-of-mysql-gui/pkg-descr
echo x - mysql-gui/pkg-comment
sed 's/^X//' >mysql-gui/pkg-comment << 'END-of-mysql-gui/pkg-comment'
XA graphical SQL client for MySQL
END-of-mysql-gui/pkg-comment
echo x - mysql-gui/distinfo
sed 's/^X//' >mysql-gui/distinfo << 'END-of-mysql-gui/distinfo'
XMD5 (mysqlgui-1.7.5.tar.gz) = 94781b272263abb5fdfe6a429b4aead8
END-of-mysql-gui/distinfo
echo x - mysql-gui/Makefile
sed 's/^X//' >mysql-gui/Makefile << 'END-of-mysql-gui/Makefile'
X# New ports collection makefile for:    mysql-gui
X# Date created:				August 17 2001
X# Whom:	      				Cyrille Lefevre <clefevre@citeweb.net>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	mysql-gui
XPORTVERSION=	1.7.5
XCATEGORIES=	databases
XMASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
XMASTER_SITE_SUBDIR=	mirrors/mysql/Downloads/mysqlgui
XDISTNAME=	${PORTNAME:S/-//}-${PORTVERSION}
X
XMAINTAINER=	clefevre@citeweb.net
X
XLIB_DEPENDS=	sqlplus.1:${PORTSDIR}/databases/mysql++ \
X 		intl.1:${PORTSDIR}/devel/gettext \
X 		glut.3:${PORTSDIR}/graphics/Mesa3 \
X 		jpeg.9:${PORTSDIR}/graphics/jpeg \
X 		fleditor.1:${PORTSDIR}/x11-toolkits/fl_editor \
X		flvw.1:${PORTSDIR}/x11-toolkits/flvw
X
XUSE_X_PREFIX=	yes
XUSE_MESA=	yes
XWRKSRC=		${WRKDIR}/${DISTNAME:S/-/-src-/}
XMAKE_ARGS=	PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \
X		PTHREAD_LIBS="${PTHREAD_LIBS}"
X
XOLD_FILES=	Fl_Editor.h Fl_FancyEditor.h Fl_ProgressBox.h \
X		Fl_StatusPanel.h Flv_CStyle.H Flv_List.H Flv_Style.H \
X		Flv_Table.H Flve_Check_Button.H Flve_Combo.H Flve_Input.H \
X		editor.h math.h strings.h vartypes.h wstrings.h
XNEW_FILES=	Fl_Editor.H editengine.h
X
Xpost-extract: remove-inc
X
Xremove-inc:
X.for file in ${OLD_FILES}
X	@${RM} -f ${WRKSRC}/FL/${file}
X.endfor
X
Xpre-patch: copy-inc
X
Xcopy-inc:
X.for file in ${NEW_FILES}
X	@${CP} ${PREFIX}/include/FL/${file} ${WRKSRC}/FL/
X.endfor
X
X.include <bsd.port.mk>
END-of-mysql-gui/Makefile
echo x - mysql-gui/files/patch-Makefile
sed 's/^X//' >mysql-gui/files/patch-Makefile << 'END-of-mysql-gui/files/patch-Makefile'
X--- Makefile.orig	Wed Apr 11 21:12:20 2001
X+++ Makefile	Sun Aug 19 03:41:52 2001
X@@ -1,27 +1,51 @@
X # --------------------- M a c r o s -------------------------------
X-CC          = gcc
X-CXX         = g++
X-#CFLAGS = -O0 -g -pipe -fno-default-inline
X-CFLAGS      = -O3 -g -pipe -fforce-mem -fforce-addr
X-#CFLAGS = -g -pipe
X-#CFLAGS      =  -c -O2 -fstrength-reduce -finline-functions 
X-INCLUDE1    = -I. -I../mysql++-1.7/sqlplusint -I/usr/local/include/mysql 
X-LIBS =  -L. -L/usr/X11R6/lib -lrcl -lrcledit -lsqlplus /usr/local/lib/mysql/libmysqlclient.a -lm -lflvw  -lfltk -lXext -ljpeg 
X-#LIBS = -L. -L/usr/X11R6/lib -lrcl -lrcledit /home/Sinisa/guiclient/libsqlplus.a /usr/local/lib/mysql/libmysqlclient.a -lfltk /usr/X11R6/lib/libXext.a /usr/X11R6/lib/libX11.a /usr/lib/libstdc++.a /usr/lib/libm.a /usr/lib/libc.a xx.o
X-OBJS =  edfile.o about.o db_tree.o Fl_NSlider.o getvars.o qsort.o queries.o bebac.o main.o do_sql.o tables.o dodatni.o status.o process.o grant.o password.o get_table.o admin.o  single.o zoom.o sin_jpeg.o jmemsrc.o options.o Fl_File_Dialog.o Fl_Dir.o Fl_Input_File.o Fl_Toggle_Tree.o Fl_Toggle_Node.o Fl_Toggle_Tree_Base.o Fl_Toggle_Node_Base.o Animated_Icon.o  Fl_Help.o Fl_Envelope.o Fl_Envelope_Scroll.o Selection.o gif.o 
X+
X+PREFIX?=	/usr/X11R6
X+LOCALBASE?=	/usr/local
X+X11BASE?=	/usr/X11R6
X+BSD_INSTALL_PROGRAM?= install -C -c -s -o root -g wheel -m 555
X+PTHREAD_CFLAGS?= -D_THREAD_SAFE
X+PTHREAD_LIBS?=	-pthread
X+CPPFLAGS=	${PTHREAD_CFLAGS} \
X+		-I. \
X+		-I${LOCALBASE}/include \
X+		-I${LOCALBASE}/include/mysql \
X+		-I${X11BASE}/include
X+LDFLAGS=	-L${LOCALBASE}/lib \
X+		-L${LOCALBASE}/lib/mysql \
X+		-L${X11BASE}/lib
X+LIBS=		-lsqlplus -lmysqlclient -lfleditor -lflvw -lfltk \
X+		-ljpeg -lGLU -lGL -lXext -lX11 -lintl -lm -lz ${PTHREAD_LIBS}
X+
X+TARGET=		mysqlgui
X+OBJS =		Fl_Dir.o Fl_Envelope.o Fl_Envelope_Scroll.o \
X+		Fl_File_Dialog.o Fl_Help.o Fl_Input_File.o \
X+		Fl_NSlider.o Fl_Toggle_Node.o Fl_Toggle_Node_Base.o \
X+		Fl_Toggle_Tree.o Fl_Toggle_Tree_Base.o \
X+		Animated_Icon.o Selection.o \
X+		about.o admin.o bebac.o db_tree.o do_sql.o \
X+		dodatni.o get_table.o getvars.o gif.o grant.o \
X+		jmemsrc.o main.o options.o password.o process.o \
X+		qsort.o queries.o sin_jpeg.o single.o status.o \
X+		tables.o zoom.o
X 
X # --------------------  R u l e s ---------------------------------
X-default: all
X-all:        mysqlgui
X+
X+all:        $(TARGET)
X+
X+install:	$(TARGET)
X+	${BSD_INSTALL_PROGRAM} $(TARGET) ${PREFIX}/bin
X+
X clean : 
X-	/bin/rm *.o mysqlgui
X+	rm -f *.o
X 
X+clobber: clean
X+	rm -f $(TARGET)
X 
X-mysqlgui: $(OBJS)
X-#	$(CC) $(OBJS) $(LIBS) -o mysqlgui  "-Wl,-rpath,../mysql++-1.7/sqlplusint/.libs"
X-	$(CXX)  -o mysqlgui $(OBJS) $(LIBS) /usr/lib/libz.a
X+$(TARGET): $(OBJS)
X+	$(CXX) $(LDFLAGS) -o mysqlgui $(OBJS) $(LIBS)
X 
X-%.o : %.cc
X-	$(CXX) $(CFLAGS) $(INCLUDE1) -c $<
X-%.o : %.c
X-	gcc $(CFLAGS) $(INCLUDE1) -c $<
X+.c.o:
X+	${CC} ${CFLAGS} ${CPPFLAGS} -c $<
X+.cc.o:
X+	${CXX} ${CXXFLAGS} ${CPPFLAGS} -c $<
END-of-mysql-gui/files/patch-Makefile
echo x - mysql-gui/files/patch-dodatni.cc
sed 's/^X//' >mysql-gui/files/patch-dodatni.cc << 'END-of-mysql-gui/files/patch-dodatni.cc'
X--- dodatni.cc.orig	Sat Aug 18 18:18:15 2001
X+++ dodatni.cc	Sat Aug 18 09:51:00 2001
X@@ -1,5 +1,6 @@
X // generated by Fast Light User Interface Designer (fluid) version 1.00
X #include "bebac.h"
X+#include <stdarg.h>
X #ifdef __WIN32__
X extern "C" {
X #define errno WSAGetLastError()
END-of-mysql-gui/files/patch-dodatni.cc
echo x - mysql-gui/files/patch-main.cc
sed 's/^X//' >mysql-gui/files/patch-main.cc << 'END-of-mysql-gui/files/patch-main.cc'
X--- main.cc.orig	Sat Aug 18 18:18:16 2001
X+++ main.cc	Sat Aug 18 09:57:03 2001
X@@ -461,7 +461,7 @@
X }
X 
X static void if_conn (void) {
X-  unsigned int j = 0, counter = 0;  c_info=con->clinet_info(); s_info=con->server_info();
X+  unsigned int j = 0, counter = 0;  c_info=con->client_info(); s_info=con->server_info();
X   try {
X 		Query query = con->query(); if (ldb) {ddd=(string)ldb; ldb=(char*)ddd.c_str();}
X     query << "show databases";
X@@ -526,7 +526,7 @@
X 			tables.insert(tables.end(),xx);
X 		}
X 		qSortHelp (0, (size_t) tables.size(), Fcmp, Exchange); 	
X-		ldb = (char *)databases[j].c_str(); c_info=con->clinet_info(); s_info=con->server_info();
X+		ldb = (char *)databases[j].c_str(); c_info=con->client_info(); s_info=con->server_info();
X 		b_connect->set();    down_group->activate();  query_browser->activate();
X 		if (databases.size()) choice_db->activate();  choice_db->redraw(); 
X 		; if (query_menus) hier->activate();
END-of-mysql-gui/files/patch-main.cc
echo x - mysql-gui/files/patch-single.cc
sed 's/^X//' >mysql-gui/files/patch-single.cc << 'END-of-mysql-gui/files/patch-single.cc'
X--- single.cc.orig	Sat Aug 18 18:18:16 2001
X+++ single.cc	Sat Aug 18 18:17:24 2001
X@@ -1,16 +1,13 @@
X // generated by Fast Light User Interface Designer (fluid) version 1.00
X-
X #include <client.h>
X #include <sqlplus.hh>
X+#undef Time
X //
X //	This file implements the file I/O routines for the editor engine.
X //	These are simple ASCII I/O routines, just for getting text out of
X //	a file, or putting it into one.
X //
X #include "single.h"
X-#include <FL/vartypes.h>
X-#include <FL/strings.h>
X-#include <FL/editor.h>
X 
X extern Connection *con;
X 
END-of-mysql-gui/files/patch-single.cc
echo x - mysql-gui/files/patch-FL-Fl_Editor.H
sed 's/^X//' >mysql-gui/files/patch-FL-Fl_Editor.H << 'END-of-mysql-gui/files/patch-FL-Fl_Editor.H'
X--- FL/Fl_Editor.H.orig	Sat Aug 18 18:19:48 2001
X+++ FL/Fl_Editor.H	Sat Aug 18 17:32:18 2001
X@@ -186,6 +186,7 @@
X 	Fl_Color textcolor() const { return(Fl_Color)textcolor_; }
X 	void textcolor(uchar n) { textcolor_ = n; }
X 	void LoadFrom(FILE *file) { engine->LoadFrom(file); ShowCursor(CURSOR_UNHIDE); SyncDisplay(); }
X+	void LoadSQL (const char *query) { engine->LoadSQL(query); ShowCursor(CURSOR_UNHIDE); SyncDisplay(); }
X 	void SaveTo(FILE *file) { engine->SaveTo(file); }
X 	void LoadFrom(const char *buffer) { engine->LoadFrom(buffer); ShowCursor(CURSOR_UNHIDE); SyncDisplay(); }
X 	void SaveTo(char *buffer) { engine->SaveTo(buffer); }
END-of-mysql-gui/files/patch-FL-Fl_Editor.H
echo x - mysql-gui/files/patch-FL-editengine.h
sed 's/^X//' >mysql-gui/files/patch-FL-editengine.h << 'END-of-mysql-gui/files/patch-FL-editengine.h'
X--- FL/editengine.h.orig	Sat Aug 18 18:19:59 2001
X+++ FL/editengine.h	Sat Aug 18 17:12:48 2001
X@@ -113,6 +113,7 @@
X   rclError SetTabs(short *tabs);
X   rclError ChangeWidth(short newwidth)      { Width = newwidth; return Command(REFORMAT,(long)newwidth); };
X   rclError LoadFrom(const char *buffer);
X+  rclError LoadSQL(const char *query);
X   rclError SaveTo(char *buffer);
X   rclError LoadFrom(FILE *infile);
X   rclError SaveTo(FILE *outfile);
END-of-mysql-gui/files/patch-FL-editengine.h
exit

>Release-Note:
>Audit-Trail:
>Unformatted:

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200108190245.f7J2jPO52075>