development/pgmodeler: Added (PostgreSQL Database Modeler)

Signed-off-by: Dave Woodfall <dave@slackbuilds.org>

Signed-off-by: Willy Sudiarto Raharjo <willysr@slackbuilds.org>

5 files changed, 159 insertions, 0 deletions

diff --git a/development/pgmodeler/README b/development/pgmodeler/README
new file mode 100644
index 0000000000..8086e3029b
--- /dev/null
+++ b/development/pgmodeler/README
@@ -0,0 +1,5 @@
+pgModeler - PostgreSQL Database Modeler - is an open-source
+data-modeling tool designed for PostgreSQL. No more DDL commands written
+by hand, let pgModeler do the job for you! This software reunites the
+conceptsof entity-relationship diagrams and the features that PostgreSQL
+implements as extensions of SQL standards.
diff --git a/development/pgmodeler/doinst.sh b/development/pgmodeler/doinst.sh
new file mode 100644
index 0000000000..5fb28930db
--- /dev/null
+++ b/development/pgmodeler/doinst.sh
@@ -0,0 +1,3 @@
+if [ -x /usr/bin/update-desktop-database ]; then
+  /usr/bin/update-desktop-database -q usr/share/applications >/dev/null 2>&1
+fi
diff --git a/development/pgmodeler/pgmodeler.SlackBuild b/development/pgmodeler/pgmodeler.SlackBuild
new file mode 100644
index 0000000000..5f4149636e
--- /dev/null
+++ b/development/pgmodeler/pgmodeler.SlackBuild
@@ -0,0 +1,122 @@
+#!/bin/bash
+
+# Slackware build script for pgmodeler
+
+# Copyright 2022 Joielechong, Indonesia
+# All rights reserved.
+#
+# Redistribution and use of this script, with or without modification, is
+# permitted provided that the following conditions are met:
+#
+# 1. Redistributions of this script must retain the above copyright
+#    notice, this list of conditions and the following disclaimer.
+#
+# THIS SOFTWARE IS PROVIDED BY THE AUTHOR ''AS IS'' AND ANY EXPRESS OR IMPLIED
+# WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
+# MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO
+# EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
+# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
+# PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
+# OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
+# WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
+# OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
+# ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+
+cd $(dirname $0) ; CWD=$(pwd)
+
+PRGNAM=pgmodeler
+VERSION=${VERSION:-0.9.4}
+BUILD=${BUILD:-1}
+TAG=${TAG:-_SBo}
+PKGTYPE=${PKGTYPE:-tgz}
+
+if [ -z "$ARCH" ]; then
+  case "$( uname -m )" in
+    i?86) ARCH=i586 ;;
+    arm*) ARCH=arm ;;
+       *) ARCH=$( uname -m ) ;;
+  esac
+fi
+
+# If the variable PRINT_PACKAGE_NAME is set, then this script will report what
+# the name of the created package would be, and then exit. This information
+# could be useful to other scripts.
+if [ ! -z "${PRINT_PACKAGE_NAME}" ]; then
+  echo "$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE"
+  exit 0
+fi
+
+TMP=${TMP:-/tmp/SBo}
+PKG=$TMP/package-$PRGNAM
+OUTPUT=${OUTPUT:-/tmp}
+
+if [ "$ARCH" = "i586" ]; then
+  SLKCFLAGS="-O2 -march=i586 -mtune=i686"
+  LIBDIRSUFFIX=""
+elif [ "$ARCH" = "i686" ]; then
+  SLKCFLAGS="-O2 -march=i686 -mtune=i686"
+  LIBDIRSUFFIX=""
+elif [ "$ARCH" = "x86_64" ]; then
+  SLKCFLAGS="-O2 -fPIC"
+  LIBDIRSUFFIX="64"
+else
+  SLKCFLAGS="-O2"
+  LIBDIRSUFFIX=""
+fi
+
+set -e
+
+rm -rf $PKG
+mkdir -p $TMP $PKG $OUTPUT
+cd $TMP
+rm -rf $PRGNAM-$VERSION
+tar xvf $CWD/$PRGNAM-$VERSION.tar.gz
+cd $PRGNAM-$VERSION
+chown -R root:root .
+find -L . \
+ \( -perm 777 -o -perm 775 -o -perm 750 -o -perm 711 -o -perm 555 -o -perm 511 \) \
+ -exec chmod 755 {} \; -o \
+ \( -perm 666 -o -perm 664 -o -perm 600 -o -perm 444 -o -perm 440 -o -perm 400 \) \
+ -exec chmod 644 {} \;
+
+qmake-qt5 \
+  QMAKE_CFLAGS+="$SLKCFLAGS" \
+  QMAKE_CXXFLAGS+="$SLKCFLAGS" \
+  PREFIX=/usr \
+  pgmodeler.pro
+
+make
+make install INSTALL_ROOT=$PKG
+
+mkdir -p $PKG/usr/share/{pixmaps,applications}
+
+cat <<EOF > $PKG/usr/share/applications/$PRGNAM.desktop
+[Desktop Entry]
+Version=1.0
+Type=Application
+Terminal=false
+Name=pgModeler
+GenericName=PostgreSQL Database Modeler
+Comment=An open-source data-modeling tool designed for PostgreSQL.
+Exec=pgmodeler
+Icon=$PRGNAM.png
+Categories=Database;Development
+StartupNotify=true
+Keywords=Database;SQL;PostgreSQL
+MimeType=application/sql
+EOF
+
+install -m 0644 assets/conf/pgmodeler_logo.png $PKG/usr/share/pixmaps/$PRGNAM.png
+
+find $PKG | xargs file | grep -e "executable" -e "shared object" | grep ELF \
+  | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null || true
+
+mkdir -p $PKG/usr/doc/$PRGNAM-$VERSION
+cat $CWD/$PRGNAM.SlackBuild > $PKG/usr/doc/$PRGNAM-$VERSION/$PRGNAM.SlackBuild
+
+mkdir -p $PKG/install
+cat $CWD/slack-desc > $PKG/install/slack-desc
+cat $CWD/doinst.sh > $PKG/install/doinst.sh
+
+cd $PKG
+/sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE
diff --git a/development/pgmodeler/pgmodeler.info b/development/pgmodeler/pgmodeler.info
new file mode 100644
index 0000000000..e4f53a79da
--- /dev/null
+++ b/development/pgmodeler/pgmodeler.info
@@ -0,0 +1,10 @@
+PRGNAM="pgmodeler"
+VERSION="0.9.4"
+HOMEPAGE="https://pgmodeler.io/"
+DOWNLOAD="https://github.com/pgmodeler/pgmodeler/archive/v0.9.4/pgmodeler-0.9.4.tar.gz"
+MD5SUM="4072efd1aafae2a1f485755c1d8629f9"
+DOWNLOAD_x86_64=""
+MD5SUM_x86_64=""
+REQUIRES="postgresql"
+MAINTAINER="Joielechong"
+EMAIL="juansspy@gmail.com"
diff --git a/development/pgmodeler/slack-desc b/development/pgmodeler/slack-desc
new file mode 100644
index 0000000000..bac4b42b52
--- /dev/null
+++ b/development/pgmodeler/slack-desc
@@ -0,0 +1,19 @@
+# HOW TO EDIT THIS FILE:
+# The "handy ruler" below makes it easier to edit a package description.
+# Line up the first '|' above the ':' following the base package name, and
+# the '|' on the right side marks the last column you can put a character in.
+# You must make exactly 11 lines for the formatting to be correct.  It's also
+# customary to leave one space after the ':' except on otherwise blank lines.
+
+         |-----handy-ruler------------------------------------------------------|
+pgmodeler: pgModeler (PostgreSQL Database Modeler)
+pgmodeler:
+pgmodeler: pgModeler - PostgreSQL Database Modeler - is an open-source
+pgmodeler: data-modeling tool designed for PostgreSQL. No more DDL
+pgmodeler: commands written by hand, let pgModeler do the job for you!
+pgmodeler:
+pgmodeler: This software unites the concepts of entity-relationship
+pgmodeler: diagrams and the features that PostgreSQL implements as
+pgmodeler: extensions of SQL standards.
+pgmodeler:
+pgmodeler: Homepage: https://pgmodeler.io