New port: databases/sqlitestudio

SQLiteStudio is a SQLite database manager with the following features:
* Intuitive interface
* Powerful, yet light and fast
* Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON)
* Importing data from various formats (CSV, custom text files)
* Numerous small additions, like formatting code, history of queries executed
  in editor windows, on-the-fly syntax checking, and more
* Unicode support
* Configurable colors, fonts and shortcuts

WWW: http://sqlitestudio.pl/

PR:		204294
Submitted by:	yuri@rawbw.com

5 files changed, 152 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 1faf64613c7f..fa7c41ca8de1 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -922,6 +922,7 @@
     SUBDIR += sqliteman
     SUBDIR += sqlitemanager
     SUBDIR += sqliteodbc
+    SUBDIR += sqlitestudio
     SUBDIR += sqlrelay
     SUBDIR += sqsh
     SUBDIR += squirrel-sql
diff --git a/databases/sqlitestudio/Makefile b/databases/sqlitestudio/Makefile
new file mode 100644
index 000000000000..be9937540050
--- /dev/null
+++ b/databases/sqlitestudio/Makefile
@@ -0,0 +1,117 @@
+# Created by: Yuri Victorovich <yuri@rawbw.com>
+# $FreeBSD$
+
+PORTNAME=	sqlitestudio
+PORTVERSION=	3.0.6
+CATEGORIES=	databases
+MASTER_SITES=	http://sqlitestudio.pl/files/sqlitestudio3/complete/tar/
+
+MAINTAINER=	yuri@rawbw.com
+COMMENT=	SQLite database GUI manager
+
+LICENSE=	GPLv3
+LICENSE_FILE=	${WRKSRC}/guiSQLiteStudio/license.txt
+
+OPTIONS_DEFINE=		PLUGIN_CSV_IMPORT PLUGIN_CSV_EXPORT PLUGIN_HTML_EXPORT
+OPTIONS_DEFINE+=	PLUGIN_PDF_EXPORT PLUGIN_JSON_EXPORT PLUGIN_XML_EXPORT
+OPTIONS_DEFINE+=	PLUGIN_SQL_EXPORT PLUGIN_REGEXP_IMPORT
+OPTIONS_DEFINE+=	PLUGIN_SQL_FORMATTER_SIMPLE PLUGIN_SQL_ENTERPRISE_FORMATTER
+OPTIONS_DEFINE+=	PLUGIN_PRINTING
+PLUGIN_CSV_IMPORT_DESC=			Install CsvImport plugin
+PLUGIN_CSV_EXPORT_DESC=			Install CsvExport plugin
+PLUGIN_HTML_EXPORT_DESC=		Install HtmlExport plugin
+PLUGIN_PDF_EXPORT_DESC=			Install PdfExport plugin
+PLUGIN_JSON_EXPORT_DESC=		Install JsonExport plugin
+PLUGIN_XML_EXPORT_DESC=			Install XmlExport plugin
+PLUGIN_SQL_EXPORT_DESC=			Install SqlExport plugin
+PLUGIN_REGEXP_IMPORT_DESC=		Install RegExp plugin
+PLUGIN_SQL_FORMATTER_SIMPLE_DESC=	Install SqlFormatterSimple plugin
+PLUGIN_SQL_ENTERPRISE_FORMATTER_DESC=	Install SqlEnterpriseFormatter plugin
+PLUGIN_PRINTING_DESC=			Install Printing plugin
+OPTIONS_DEFAULT=	PLUGIN_CSV_IMPORT PLUGIN_CSV_EXPORT PLUGIN_HTML_EXPORT
+OPTIONS_DEFAULT+=	PLUGIN_PDF_EXPORT PLUGIN_JSON_EXPORT PLUGIN_XML_EXPORT
+OPTIONS_DEFAULT+=	PLUGIN_SQL_EXPORT PLUGIN_REGEXP_IMPORT
+OPTIONS_DEFAULT+=	PLUGIN_SQL_FORMATTER_SIMPLE PLUGIN_SQL_ENTERPRISE_FORMATTER
+OPTIONS_DEFAULT+=	PLUGIN_PRINTING
+OPTIONS_SUB=	yes
+
+WRKSRC=		${WRKDIR}/SQLiteStudio3
+
+USES=		compiler:c++11-lib gmake qmake
+USE_QT5=	core gui svg sql xml network sql-sqlite3_run widgets script \
+		concurrent uitools buildtools_build linguisttools_build
+USE_SQLITE=	yes
+USE_GL=		gl
+USE_LDCONFIG=	yes
+
+.include <bsd.port.pre.mk>
+
+.if ${COMPILER_TYPE} == clang && (${COMPILER_VERSION} < 37)
+# The reason for clang37 is that previous versions fail to compile with various errors
+BUILD_DEPENDS+=	clang37:${PORTSDIR}/lang/clang37
+CPP=		clang-cpp37
+CC=		clang37
+CXX=		clang++37
+.endif
+
+post-patch:
+	@${REINPLACE_CMD} -e 's|/usr/|${LOCALBASE}/|' \
+		${WRKSRC}/dirs.pri
+	@${REINPLACE_CMD} -e 's|pluginDirs += QDir(CFG->getConfigDir()).absoluteFilePath("plugins");|pluginDirs += "${LOCALBASE}/lib/sqlitestudio";|' \
+		${WRKSRC}/coreSQLiteStudio/services/impl/pluginmanagerimpl.cpp
+
+.include <bsd.port.options.mk>
+
+PLUGIN_DIRS=
+.if ${PORT_OPTIONS:MPLUGIN_CSV_IMPORT}
+PLUGIN_DIRS     += CsvImport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_CSV_EXPORT}
+PLUGIN_DIRS     += CsvExport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_HTML_EXPORT}
+PLUGIN_DIRS     += HtmlExport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_PDF_EXPORT}
+PLUGIN_DIRS     += PdfExport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_JSON_EXPORT}
+PLUGIN_DIRS     += JsonExport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_XML_EXPORT}
+PLUGIN_DIRS     += XmlExport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_SQL_EXPORT}
+PLUGIN_DIRS     += SqlExport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_REGEXP_IMPORT}
+PLUGIN_DIRS     += RegExpImport
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_SQL_FORMATTER_SIMPLE}
+PLUGIN_DIRS     += SqlFormatterSimple
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_SQL_ENTERPRISE_FORMATTER}
+PLUGIN_DIRS     += SqlEnterpriseFormatter
+.endif
+.if ${PORT_OPTIONS:MPLUGIN_PRINTING}
+PLUGIN_DIRS     += Printing
+USE_QT5+=	printsupport
+.endif
+
+post-configure:
+.for plugin in ${PLUGIN_DIRS}
+	@cd ${WRKDIR}/Plugins/${plugin} && \
+		${SETENV} ${QMAKE_ENV} ${_QMAKE} ${QMAKE_ARGS} ${QMAKE_SOURCE_PATH}
+.endfor
+post-build:
+.for plugin in ${PLUGIN_DIRS}
+	@cd ${WRKDIR}/Plugins/${plugin} && \
+		${DO_MAKE_BUILD} ${ALL_TARGET}
+.endfor
+post-install:
+.for plugin in ${PLUGIN_DIRS}
+	@cd ${WRKDIR}/Plugins/${plugin} && \
+		${SETENV} ${MAKE_ENV} ${FAKEROOT} ${MAKE_CMD} ${MAKE_FLAGS} ${MAKEFILE} ${MAKE_ARGS} ${INSTALL_TARGET}
+.endfor
+
+.include <bsd.port.post.mk>
diff --git a/databases/sqlitestudio/distinfo b/databases/sqlitestudio/distinfo
new file mode 100644
index 000000000000..af06f2257423
--- /dev/null
+++ b/databases/sqlitestudio/distinfo
@@ -0,0 +1,2 @@
+SHA256 (sqlitestudio-3.0.6.tar.gz) = 7b376b0adb3ec2b284d7dbea3115a436f4d567c1e43e28f36cf872355978b3d5
+SIZE (sqlitestudio-3.0.6.tar.gz) = 2464996
diff --git a/databases/sqlitestudio/pkg-descr b/databases/sqlitestudio/pkg-descr
new file mode 100644
index 000000000000..3bbac2643ee7
--- /dev/null
+++ b/databases/sqlitestudio/pkg-descr
@@ -0,0 +1,11 @@
+SQLiteStudio is a SQLite database manager with the following features:
+* Intuitive interface
+* Powerful, yet light and fast
+* Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON)
+* Importing data from various formats (CSV, custom text files)
+* Numerous small additions, like formatting code, history of queries executed
+  in editor windows, on-the-fly syntax checking, and more
+* Unicode support
+* Configurable colors, fonts and shortcuts
+
+WWW: http://sqlitestudio.pl/
diff --git a/databases/sqlitestudio/pkg-plist b/databases/sqlitestudio/pkg-plist
new file mode 100644
index 000000000000..2bbca3e0bfb1
--- /dev/null
+++ b/databases/sqlitestudio/pkg-plist
@@ -0,0 +1,21 @@
+bin/SQLiteStudio
+bin/sqlitestudiocli
+lib/libcoreSQLiteStudio.so
+lib/libcoreSQLiteStudio.so.1
+lib/libcoreSQLiteStudio.so.1.0
+lib/libcoreSQLiteStudio.so.1.0.0
+lib/libguiSQLiteStudio.so
+lib/libguiSQLiteStudio.so.1
+lib/libguiSQLiteStudio.so.1.0
+lib/libguiSQLiteStudio.so.1.0.0
+%%PLUGIN_CSV_IMPORT%%lib/sqlitestudio/libCsvImport.so
+%%PLUGIN_CSV_EXPORT%%lib/sqlitestudio/libCsvExport.so
+%%PLUGIN_HTML_EXPORT%%lib/sqlitestudio/libHtmlExport.so
+%%PLUGIN_PDF_EXPORT%%lib/sqlitestudio/libPdfExport.so
+%%PLUGIN_JSON_EXPORT%%lib/sqlitestudio/libJsonExport.so
+%%PLUGIN_XML_EXPORT%%lib/sqlitestudio/libXmlExport.so
+%%PLUGIN_SQL_EXPORT%%lib/sqlitestudio/libSqlExport.so
+%%PLUGIN_REGEXP_IMPORT%%lib/sqlitestudio/libRegExpImport.so
+%%PLUGIN_SQL_FORMATTER_SIMPLE%%lib/sqlitestudio/libSqlFormatterSimple.so
+%%PLUGIN_SQL_ENTERPRISE_FORMATTER%%lib/sqlitestudio/libSqlEnterpriseFormatter.so
+%%PLUGIN_PRINTING%%lib/sqlitestudio/libPrinting.so