development/SQLiteStudio: Added (SQLite db manager in C++ using Qt)

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

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

6 files changed, 215 insertions, 0 deletions

diff --git a/development/SQLiteStudio/README b/development/SQLiteStudio/README
new file mode 100644
index 000000000000..06a0e8289ab8
--- /dev/null
+++ b/development/SQLiteStudio/README
@@ -0,0 +1,20 @@
+SQLiteStudio is a free, open source, multi-platform SQLite database
+manager writtenin C++, with use of Qt framework. It is a desktop
+application for browsing and editing SQLite database files, aimed
+for people who know what SQLite is, or what relational databases
+are in general.
+
+SQLiteStudio was created and is maintained by Pawel Salawa with
+contribution from the community.
+
+The project was initially implemented in Tcl/Tk, until version 3.0.0
+that was completely re-written in C++/Qt.
+
+It is an open-source software, released under GPL (v3) license.
+You are free to use it for any purpose you like.
+
+Homepage: https://sqlitestudio.pl/
+Github: https://github.com/pawelsalawa/sqlitestudio
+
+This package installs to /opt/SQLiteStudio and depends on
+chrpath package also found in SlackBuilds
diff --git a/development/SQLiteStudio/SQLiteStudio.SlackBuild b/development/SQLiteStudio/SQLiteStudio.SlackBuild
new file mode 100644
index 000000000000..9d047896ecb8
--- /dev/null
+++ b/development/SQLiteStudio/SQLiteStudio.SlackBuild
@@ -0,0 +1,142 @@
+#!/bin/bash
+
+# Slackware build script for the SQLiteStudio
+
+# Copyright 2022 Antonio Leal, Lisbon, Portugal
+# 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=SQLiteStudio
+VERSION=${VERSION:-3.3.3}
+BUILD=${BUILD:-1}
+TAG=${TAG:-_SBo}
+PKGTYPE=${PKGTYPE:-tgz}
+BASENAME=${BASENAME:-sqlitestudio}
+
+if [ -z "$ARCH" ]; then
+  case "$( uname -m )" in
+    i?86) ARCH=i586 ;;
+    arm*) ARCH=arm ;;
+       *) ARCH=$( uname -m ) ;;
+  esac
+fi
+
+if [ ! -z "${PRINT_PACKAGE_NAME}" ]; then
+  echo "$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE"
+  exit 0
+fi
+
+if [ "$ARCH" = "i586" ]; then
+  SLKCFLAGS="-O2 -march=i586 -mtune=i686"
+  LIBDIRSUFFIX=""
+  QMAKE=/usr/lib/qt5/bin/qmake
+  CORES=2
+elif [ "$ARCH" = "i686" ]; then
+  SLKCFLAGS="-O2 -march=i686 -mtune=i686"
+  LIBDIRSUFFIX=""
+  QMAKE=/usr/lib/qt5/bin/qmake
+  CORES=2
+elif [ "$ARCH" = "x86_64" ]; then
+  SLKCFLAGS="-O2 -fPIC"
+  LIBDIRSUFFIX="64"
+  QMAKE=/usr/lib64/qt5/bin/qmake
+  CORES=4
+else
+  SLKCFLAGS="-O2"
+  LIBDIRSUFFIX=""
+  QMAKE=/usr/lib/qt5/bin/qmake
+  CORES=4
+fi
+
+set -e
+TMP=${TMP:-/tmp/SBo}
+PKG=$TMP/package-$PRGNAM
+OUTPUT=${OUTPUT:-/tmp}
+BUILDDIR=$TMP/$BASENAME-$VERSION
+
+rm -rf $PKG $BUILDDIR
+mkdir -p $TMP $PKG $OUTPUT
+cd $TMP
+
+tar xvfz $CWD/$BASENAME-$VERSION.tar.gz
+
+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 640 -o -perm 600 -o -perm 444 \
+  -o -perm 440 -o -perm 400 \) -exec chmod 644 {} \;
+
+cd $BUILDDIR/scripts/linux
+./compile.sh $QMAKE $CORES
+./create_portable.sh $QMAKE
+
+mkdir -p $PKG/opt/$PRGNAM
+mv $BUILDDIR/output/portable/SQLiteStudio/*  $PKG/opt/$PRGNAM
+
+mkdir -p $PKG/usr/share/pixmaps
+cp $BUILDDIR/scripts/installer/config/watermark.png $PKG/usr/share/pixmaps/SQLiteStudio.png
+mkdir -p $PKG/usr/share/applications
+cp $CWD/SQLiteStudio.desktop $PKG/usr/share/applications
+
+# remove uneeded symlinks
+( cd $PKG/opt/SQLiteStudio/lib ; rm -rf libk5crypto.so.3 )
+( cd $PKG/opt/SQLiteStudio/lib ; rm -rf libk5crypto.so.3.1 )
+( cd $PKG/opt/SQLiteStudio/lib ; rm -rf libkrb5.so.3 )
+( cd $PKG/opt/SQLiteStudio/lib ; rm -rf libkrb5.so.3.3 )
+( cd $PKG/opt/SQLiteStudio/lib ; rm -rf libkrb5support.so.0 )
+( cd $PKG/opt/SQLiteStudio/lib ; rm -rf libkrb5support.so.0.1 )
+
+# or fix broken symlink
+#(
+#  cd $PKG/opt/SQLiteStudio/lib
+#  for lnk in libk5crypto.so.3.1 libkrb5.so.3.3 libkrb5support.so.0.1 \
+#    libk5crypto.so.3 libkrb5.so.3 libkrb5support.so.0; do
+#    rm -f $lnk ; ln -s ../../../lib$LIBDIRSUFFIX/$lnk $lnk
+#  done
+#)
+
+# create additonal program symlinks
+mkdir -p $PKG/usr/bin
+( cd $PKG/usr/bin ; rm -rf sqlitestudio )
+( cd $PKG/usr/bin ; ln -sf ../../opt/SQLiteStudio/sqlitestudio sqlitestudio )
+( cd $PKG/usr/bin ; rm -rf SQLiteStudio )
+( cd $PKG/usr/bin ; ln -sf ../../opt/SQLiteStudio/sqlitestudio SQLiteStudio )
+( cd $PKG/usr/bin ; rm -rf sqlitestudiocli )
+( cd $PKG/usr/bin ; ln -sf ../../opt/SQLiteStudio/sqlitestudiocli sqlitestudiocli )
+( cd $PKG/usr/bin ; rm -rf SQLiteStudioCli )
+( cd $PKG/usr/bin ; ln -sf ../../opt/SQLiteStudio/sqlitestudiocli SQLiteStudioCli )
+
+rm -f $PKG/{,usr/}lib${LIBDIRSUFFIX}/*.la
+
+find $PKG -print0 | xargs -0 file | grep -e "executable" -e "shared object" | grep ELF \
+  | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null || true
+
+find $PKG -name perllocal.pod -o -name ".packlist" -o -name "*.bs" | xargs rm -f || 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/SQLiteStudio/SQLiteStudio.desktop b/development/SQLiteStudio/SQLiteStudio.desktop
new file mode 100644
index 000000000000..14481051e36d
--- /dev/null
+++ b/development/SQLiteStudio/SQLiteStudio.desktop
@@ -0,0 +1,9 @@
+[Desktop Entry]
+Name=SQLiteStudio
+Comment=SQLite database manager
+Exec=/opt/SQLiteStudio/sqlitestudio
+Icon=/usr/share/pixmaps/SQLiteStudio.png
+Terminal=false
+Type=Application
+Categories=System;Development;
+
diff --git a/development/SQLiteStudio/SQLiteStudio.info b/development/SQLiteStudio/SQLiteStudio.info
new file mode 100644
index 000000000000..c780510ea268
--- /dev/null
+++ b/development/SQLiteStudio/SQLiteStudio.info
@@ -0,0 +1,10 @@
+PRGNAM="SQLiteStudio"
+VERSION="3.3.3"
+HOMEPAGE="https://sqlitestudio.pl/"
+DOWNLOAD="https://github.com/pawelsalawa/sqlitestudio/archive/3.3.3/sqlitestudio-3.3.3.tar.gz"
+MD5SUM="5cdf72142a28f3797f4375a9cd307387"
+DOWNLOAD_x86_64=""
+MD5SUM_x86_64=""
+REQUIRES="chrpath"
+MAINTAINER="Antonio Leal"
+EMAIL="antonioleal@yahoo.com"
diff --git a/development/SQLiteStudio/doinst.sh b/development/SQLiteStudio/doinst.sh
new file mode 100644
index 000000000000..38e4870b5f96
--- /dev/null
+++ b/development/SQLiteStudio/doinst.sh
@@ -0,0 +1,15 @@
+if [ -x /usr/bin/update-desktop-database ]; then
+  /usr/bin/update-desktop-database -q usr/share/applications >/dev/null 2>&1
+fi
+
+if [ -x /usr/bin/update-mime-database ]; then
+  /usr/bin/update-mime-database usr/share/mime >/dev/null 2>&1
+fi
+
+if [ -e usr/share/icons/hicolor/icon-theme.cache ]; then
+  if [ -x /usr/bin/gtk-update-icon-cache ]; then
+    /usr/bin/gtk-update-icon-cache -f usr/share/icons/hicolor >/dev/null 2>&1
+  fi
+fi
+
+
diff --git a/development/SQLiteStudio/slack-desc b/development/SQLiteStudio/slack-desc
new file mode 100644
index 000000000000..e37f5ac5d003
--- /dev/null
+++ b/development/SQLiteStudio/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------------------------------------------------------|
+SQLiteStudio: SQLiteStudio (SQLite database manager written in C++ using Qt)
+SQLiteStudio:
+SQLiteStudio: A free, open source, multi-platform SQLite database manager written
+SQLiteStudio: in C++, with use of Qt framework.
+SQLiteStudio:
+SQLiteStudio: SQLiteStudio is a desktop application for browsing and editing SQLite
+SQLiteStudio: database files. It is aimed for people, who know what SQLite is, or
+SQLiteStudio: what relational databases are in general.
+SQLiteStudio:
+SQLiteStudio: Homepage: https://sqlitestudio.pl/
+SQLiteStudio: