3 files changed, 278 insertions, 0 deletions
diff --git a/scripts/linux/compile.sh b/scripts/linux/compile.sh
new file mode 100755
index 0000000..eff0b04
--- /dev/null
+++ b/scripts/linux/compile.sh
@@ -0,0 +1,57 @@
+#!/bin/bash
+
+set -e
+
+if [ "$1" == "" ]; then
+    QMAKE=`which qmake`
+    if [ "$QMAKE" == "" ]; then
+	echo "Cannot find qmake"
+	exit 1
+    else
+	read -p "Is this correct qmake (y/N) $QMAKE : " yn
+	case $yn in
+	    [Yy]* ) ;;
+	    * ) echo "Please pass path to correct qmake as argument to this script."; exit;;
+	esac
+    fi
+else
+    QMAKE=$1
+fi
+
+cdir=`pwd`
+cpu_cores=`grep -c ^processor /proc/cpuinfo`
+absolute_path=`realpath $0`
+this_dir=`dirname $absolute_path`
+this_dir=`dirname $this_dir`
+parent_dir=`dirname $this_dir`
+
+if [ "$2" == "" ]; then
+    read -p "Number of CPU cores to use for compiling (hit enter to use $cpu_cores): " new_cpu_cores
+    case $new_cpu_cores in
+	"" ) ;;
+	* ) cpu_cores=$new_cpu_cores ;;
+    esac
+else
+    cpu_cores=$2
+fi
+
+if [ -d $parent_dir/output ]; then
+	read -p "Directory $parent_dir/output already exists. The script will delete and recreate it. Is that okay? (y/N) : " yn
+	case $yn in
+	    [Yy]* ) rm -rf $parent_dir/output ;;
+	    * ) echo "Aborted."; exit;;
+	esac
+fi
+
+cd $parent_dir
+mkdir output output/build output/build/Plugins
+
+cd output/build
+$QMAKE CONFIG+=portable ../../SQLiteStudio3
+make -j $cpu_cores
+
+cd Plugins
+$QMAKE CONFIG+=portable ../../../Plugins
+make -j $cpu_cores
+
+cd $cdir
diff --git a/scripts/linux/create_portable.sh b/scripts/linux/create_portable.sh
new file mode 100755
index 0000000..b3b2d52
--- /dev/null
+++ b/scripts/linux/create_portable.sh
@@ -0,0 +1,184 @@
+#!/bin/bash
+
+#  echo "$0 <sqlitestudio build output directory> <qmake path> [tgz|dist|dist_full]"
+
+if [ "$1" == "" ]; then
+    QMAKE=`which qmake`
+    if [ $QMAKE == "" ]; then
+	echo "Cannot find qmake"
+    else
+	read -p "Is this correct qmake (y/N) $QMAKE : " yn
+	case $yn in
+	    [Yy]* ) ;;
+	    * ) echo "Please pass path to correct qmake as argument to this script."; exit;;
+	esac
+    fi
+else
+    QMAKE=$1
+fi
+
+which chrpath >/dev/null
+if [ "$?" -ne 0 ]; then
+  echo "chrpath program missing!"
+  exit 1
+fi
+
+qt_paths_bin="${QMAKE/qmake/qtpaths}"
+$qt_paths_bin -v >/dev/null 2>&1
+if [ "$?" -ne 0 ]; then
+  echo "qtpaths program missing!"
+  exit 1
+fi
+
+OUTPUT=`pwd`/../../output
+
+cd $OUTPUT
+
+required_modules="libQt5Core.so libQt5Concurrent.so libQt5DBus.so libQt5Gui.so libQt5Network.so libQt5PrintSupport.so libQt5Script.so libQt5Widgets.so libQt5Xml.so \
+  libQt5Svg.so libQt5XcbQpa.so"
+required_plugins="platforms/libqxcb.so imageformats/libqgif.so imageformats/libqicns.so imageformats/libqico.so imageformats/libqjpeg.so \
+  imageformats/libqsvg.so imageformats/libqtga.so imageformats/libqtiff.so iconengines/libqsvgicon.so printsupport/libcupsprintersupport.so"
+optional_plugins="platformthemes/libqgtk3.so"
+
+qt_lib_dir=`ldd SQLiteStudio/sqlitestudio | grep libQt5Core | awk '{print $3;}'`
+qt_lib_dir=`dirname $qt_lib_dir`
+qt_plugins_dir=`$qt_paths_bin --plugin-dir`
+
+# Create portable dir to store distribution in
+rm -rf portable
+mkdir portable
+cd portable
+portable=`pwd`
+
+# Copy all output from compilation here
+cp -R $OUTPUT/SQLiteStudio .
+
+# Make lib directory to move all *.so files (sqlitestudio files and Qt files and dependencies)
+cd SQLiteStudio
+
+# Copy SQLite libs
+cd $portable/SQLiteStudio
+if [ -f /usr/local/lib/libsqlite3.so.0.8.6 ]; then
+    echo "SQLite3 library exists in /usr/local/lib/. Since this is usually a custom build of SQLite, it's preferred and will be used now."
+    sqlite3_lib=/usr/local/lib/libsqlite3.so.0.8.6
+    sqlite3_lib_target=`ldd $OUTPUT/SQLiteStudio/lib/libcoreSQLiteStudio.so | grep libsqlite | awk '{print $3;}'`
+    cp $sqlite3_lib lib/`basename $sqlite3_lib_target`
+else
+    sqlite3_lib=`ldd $OUTPUT/SQLiteStudio/lib/libcoreSQLiteStudio.so | grep libsqlite | awk '{print $3;}'`
+    cp $sqlite3_lib lib
+fi
+echo "Using SQLite3 library: $sqlite3_lib"
+
+sqlite2_lib=`ldd plugins/libDbSqlite2.so | grep libsqlite | awk '{print $3;}'`
+echo "Using SQLite2 library: $sqlite2_lib"
+cp $sqlite2_lib lib
+strip lib/*libsqlite*
+
+# Copy Qt
+cd $portable/SQLiteStudio/lib
+for module in $required_modules; do
+  if [ ! -f $qt_lib_dir/$module ]; then
+    echo "Required Qt module doesn't exist: $qt_lib_dir/$module"
+    exit 1
+  fi
+  cp -P $qt_lib_dir/$module* .
+  
+  for dep_lib in `ldd $qt_lib_dir/$module | grep $qt_lib_dir | awk '{print $3;}'`; do
+    cp -Pu $dep_lib* .
+  done
+done
+
+for lib in `ls *.so`; do
+  chrpath -r \$ORIGIN/lib $lib 2>&1 >/dev/null
+done
+
+# Now copy Qt plugins
+cd $portable/SQLiteStudio
+qt_plugin_dirs=()
+for plugin in $required_plugins; do
+  if [ ! -f $qt_plugins_dir/$plugin ]; then
+    echo "Required Qt plugin doesn't exist: $qt_plugins_dir/$plugin"
+    exit 1
+  fi
+  parts=(${plugin/\// })
+  mkdir ${parts[0]} 2>/dev/null
+  cp -P $qt_plugins_dir/$plugin ${parts[0]}
+  
+  # Update rpath in Qt plugins
+  cd ${parts[0]}
+  for lib in `ls *.so`; do
+    chrpath -r \$ORIGIN/../lib $lib 2>&1 >/dev/null
+  done
+  cd ..
+done
+
+for plugin in $optional_plugins; do
+  if [ ! -f $qt_plugins_dir/$plugin ]; then
+    continue
+  fi
+  parts=(${plugin/\// })
+  mkdir ${parts[0]} 2>/dev/null
+  cp -P $qt_plugins_dir/$plugin ${parts[0]}
+  
+  # Update rpath in Qt plugins
+  cd ${parts[0]}
+  for lib in `ls *.so`; do
+    chrpath -r \$ORIGIN/../lib $lib 2>&1 >/dev/null
+  done
+  cd ..
+done
+
+cd $portable/SQLiteStudio
+chrpath -r \$ORIGIN/lib sqlitestudio 2>&1 >/dev/null
+chrpath -r \$ORIGIN/lib sqlitestudiocli 2>&1 >/dev/null
+
+cd $portable
+VERSION=`SQLiteStudio/sqlitestudiocli -v | awk '{print $2}'`
+
+# Complete
+echo "Building complete package: sqlitestudio-$VERSION.tar.xz"
+tar cf sqlitestudio-$VERSION.tar SQLiteStudio
+xz -z sqlitestudio-$VERSION.tar
+  
+# App
+echo "Building incremental update package: sqlitestudio-$VERSION.tar.gz"
+cp -R SQLiteStudio app
+cd app
+#if [ "$3" == "dist" ]; then
+#        rm -rf plugins
+#        rm -f lib/libQ*
+#        rm -rf iconengines
+#        rm -rf imageformats
+#        rm -rf platforms
+#        rm -rf platformthemes
+#        rm -rf printsupport
+#        find . -type l -exec rm -f {} \;
+#fi
+rm -f lib/libicu*
+rm -f lib/libsqlite.so.0 ;# this is for SQLite 2
+tar cf sqlitestudio-$VERSION.tar *
+gzip -9 sqlitestudio-$VERSION.tar
+mv sqlitestudio-$VERSION.tar.gz ..
+cd ..
+rm -rf app
+
+
+# Plugins
+mkdir plugins
+SQLiteStudio/sqlitestudio --list-plugins | while read line
+do
+    PLUGIN=`echo $line | awk '{print $1}'`
+    PLUGIN_VER=`echo $line | awk '{print $2}'`
+    if [ -f SQLiteStudio/plugins/lib$PLUGIN.so ]; then
+      echo "Building plugin package: $PLUGIN-$PLUGIN_VER.tar.gz"
+      cp SQLiteStudio/plugins/lib$PLUGIN.so plugins/
+      tar cf $PLUGIN\-$PLUGIN_VER.tar plugins
+      gzip -9 $PLUGIN\-$PLUGIN_VER.tar
+    fi
+    rm -f plugins/*
+done
+rm -rf plugins
+
+echo "Done."
+
+echo "Portable distribution created at: $portable/SQLiteStudio"
diff --git a/scripts/linux/release.sh b/scripts/linux/release.sh
new file mode 100755
index 0000000..c490114
--- /dev/null
+++ b/scripts/linux/release.sh
@@ -0,0 +1,37 @@
+#!/bin/sh
+
+set -e
+
+TARGET_DIR=/tmp/sqls-installer
+QMAKE=/opt/qt/5.10.0/gcc_64/bin/qmake
+CORES=2
+TMP_DIR=~/tmp/SQLiteStudio
+
+if [ ! -f $QMAKE ]; then
+    echo "qmake at $QMAKE does not exist."
+    exit 1
+fi
+
+OLDDIR=`pwd`
+
+VER=`grep 'static const int sqlitestudioVersion' ../../SQLiteStudio3/coreSQLiteStudio/sqlitestudio.cpp | egrep -o '[\ 0-9]{2}' | bc | paste -s -d'.'`
+
+rm -rf ../../output
+./compile.sh $QMAKE $CORES
+./create_portable.sh $QMAKE
+cd ../installer
+rm -rf $TARGET_DIR
+tclsh assemble.tcl $TARGET_DIR --repo
+
+rm -rf $TMP_DIR
+$TARGET_DIR/InstallSQLiteStudio-* TargetDir=$TMP_DIR
+
+mv $TMP_DIR $TARGET_DIR/
+cd $TARGET_DIR
+
+tar cf sqlitestudio-$VER.tar SQLiteStudio
+xz -z sqlitestudio-$VER.tar
+rm -rf SQLiteStudio
+echo "Deleted installed app. System is clean."
+
+cd $OLDDIR