From d6697acafc1529df8b95110636d022d5f599dd5a Mon Sep 17 00:00:00 2001 From: Antonio Leal Date: Thu, 25 Aug 2022 22:22:09 +0100 Subject: development/SQLiteStudio: Added (SQLite db manager in C++ using Qt) Signed-off-by: Dave Woodfall Signed-off-by: Willy Sudiarto Raharjo --- development/SQLiteStudio/README | 20 ++++ development/SQLiteStudio/SQLiteStudio.SlackBuild | 142 +++++++++++++++++++++++ development/SQLiteStudio/SQLiteStudio.desktop | 9 ++ development/SQLiteStudio/SQLiteStudio.info | 10 ++ development/SQLiteStudio/doinst.sh | 15 +++ development/SQLiteStudio/slack-desc | 19 +++ 6 files changed, 215 insertions(+) create mode 100644 development/SQLiteStudio/README create mode 100644 development/SQLiteStudio/SQLiteStudio.SlackBuild create mode 100644 development/SQLiteStudio/SQLiteStudio.desktop create mode 100644 development/SQLiteStudio/SQLiteStudio.info create mode 100644 development/SQLiteStudio/doinst.sh create mode 100644 development/SQLiteStudio/slack-desc (limited to 'development/SQLiteStudio') diff --git a/development/SQLiteStudio/README b/development/SQLiteStudio/README new file mode 100644 index 0000000000..06a0e8289a --- /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 0000000000..9d047896ec --- /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 0000000000..14481051e3 --- /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 0000000000..c780510ea2 --- /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 0000000000..38e4870b5f --- /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 0000000000..e37f5ac5d0 --- /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: -- cgit v1.2.3-65-gdbad