From d36ea97cf7a091ff6df4b9eb086582ca500dea7c Mon Sep 17 00:00:00 2001 From: Joielechong Date: Fri, 29 Apr 2022 14:57:18 +0100 Subject: development/pgmodeler: Added (PostgreSQL Database Modeler) Signed-off-by: Dave Woodfall Signed-off-by: Willy Sudiarto Raharjo --- development/pgmodeler/README | 5 ++ development/pgmodeler/doinst.sh | 3 + development/pgmodeler/pgmodeler.SlackBuild | 122 +++++++++++++++++++++++++++++ development/pgmodeler/pgmodeler.info | 10 +++ development/pgmodeler/slack-desc | 19 +++++ 5 files changed, 159 insertions(+) create mode 100644 development/pgmodeler/README create mode 100644 development/pgmodeler/doinst.sh create mode 100644 development/pgmodeler/pgmodeler.SlackBuild create mode 100644 development/pgmodeler/pgmodeler.info create mode 100644 development/pgmodeler/slack-desc 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 < $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 -- cgit v1.2.3