1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
|
#!/bin/sh
printUsage() {
echo "$0 <sqlitestudio build output directory> <qmake path> [dmg|dist|dist_full]"
}
if [ "$#" -lt 2 ] || [ "$#" -gt 3 ]; then
printUsage
exit 1
fi
if [ "$#" -eq 3 ] && [ "$3" != "dmg" ] && [ "$3" != "dist" ] && [ "$3" != "dist_plugins" ] && [ "$3" != "dist_full" ]; then
printUsage
exit 1
fi
qt_deploy_bin="${2/qmake/macdeployqt}"
ls $qt_deploy_bin >/dev/null 2>&1
if [ "$?" -ne 0 ]; then
echo "macdeployqt program missing!"
exit 1
fi
cd "$1/SQLiteStudio"
rm -rf SQLiteStudio.app/Contents/Frameworks
rm -rf SQLiteStudio.app/Contents/PlugIns
rm -f SQLiteStudio.app/Contents/MacOS/sqlitestudiocli
rm -f SQLiteStudio.app/Contents/Resources/qt.conf
mkdir SQLiteStudio.app/Contents/Frameworks
cp -RP plugins SQLiteStudio.app/Contents
mv SQLiteStudio.app/Contents/plugins SQLiteStudio.app/Contents/PlugIns
mkdir -p SQLiteStudio.app/Contents/PlugIns/styles
cp -RP styles/* SQLiteStudio.app/Contents/PlugIns/styles
cp -RP lib*SQLiteStudio*.dylib SQLiteStudio.app/Contents/Frameworks
# CLI paths
qtcore_path=`otool -L sqlitestudiocli | awk '/QtCore/ {print $1;}'`
new_qtcore_path="@rpath/QtCore.framework/Versions/5/QtCore"
cp -P sqlitestudiocli SQLiteStudio.app/Contents/MacOS
install_name_tool -change libcoreSQLiteStudio.1.dylib "@rpath/libcoreSQLiteStudio.1.dylib" SQLiteStudio.app/Contents/MacOS/sqlitestudiocli
install_name_tool -change $qtcore_path $new_qtcore_path SQLiteStudio.app/Contents/MacOS/sqlitestudiocli
# SQLiteStudio binary paths
install_name_tool -change libcoreSQLiteStudio.1.dylib "@rpath/libcoreSQLiteStudio.1.dylib" SQLiteStudio.app/Contents/MacOS/SQLiteStudio
install_name_tool -change libguiSQLiteStudio.1.dylib "@rpath/libguiSQLiteStudio.1.dylib" SQLiteStudio.app/Contents/MacOS/SQLiteStudio
# Lib paths
install_name_tool -change libcoreSQLiteStudio.1.dylib "@rpath/libcoreSQLiteStudio.1.dylib" SQLiteStudio.app/Contents/Frameworks/libguiSQLiteStudio.1.dylib
install_name_tool -change libsqlite3.0.dylib "@rpath/libsqlite3.0.dylib" SQLiteStudio.app/Contents/Frameworks/libcoreSQLiteStudio.1.dylib
cdir=`pwd`
cd ../../../lib/
libdir=`pwd`
cd "$cdir"
echo "lib:"
ls -l ../../../lib/
echo "in frameworks - 1:"
ls -l SQLiteStudio.app/Contents/Frameworks
cp -RP ../../../lib/libsqlite3.0.dylib SQLiteStudio.app/Contents/Frameworks
cp -RP ../../../lib/libtcl8.6.dylib SQLiteStudio.app/Contents/Frameworks
cp -RP ../../../lib/libcrypto.3.dylib SQLiteStudio.app/Contents/Frameworks
cd SQLiteStudio.app/Contents/Frameworks
ln -s libsqlite3.0.dylib libsqlite3.dylib
ln -s libcrypto.3.dylib libcrypto.dylib
cd ../../..
echo "in frameworks - 2:"
ls -l SQLiteStudio.app/Contents/Frameworks
# Plugin paths
function fixPluginPaths() {
for f in `ls "$1"`
do
PLUGIN_FILE="$1/$f"
if [ -f "$PLUGIN_FILE" ]; then
echo "Fixing paths for plugin $PLUGIN_FILE"
install_name_tool -change libcoreSQLiteStudio.1.dylib "@rpath/libcoreSQLiteStudio.1.dylib" "$PLUGIN_FILE"
install_name_tool -change libguiSQLiteStudio.1.dylib "@rpath/libguiSQLiteStudio.1.dylib" "$PLUGIN_FILE"
fi
if [ -d "$PLUGIN_FILE" ]; then
fixPluginPaths "$PLUGIN_FILE"
fi
done
}
fixPluginPaths SQLiteStudio.app/Contents/PlugIns
fixPluginLibPath() {
local PLUGIN="$1"
local LIBNAME="$2"
if [ -z "$PLUGIN" ] || [ -z "$LIBNAME" ]; then
echo "Usage: fixPluginLibPath <plugin.dylib> <libname.dylib>"
return 1
fi
# Znalezienie aktualnego wpisu z otool -L
local OLD
OLD=$(otool -L "$PLUGIN" | awk -v lib="$LIBNAME" '$1 ~ lib {print $1; exit}')
if [ -z "$OLD" ]; then
echo "WARNING: Library $LIBNAME not found in $PLUGIN"
return 0
fi
# Nowa ścieżka
local NEW="@rpath/$LIBNAME"
echo "Fixing $PLUGIN: $OLD → $NEW"
install_name_tool -change "$OLD" "$NEW" "$PLUGIN"
}
fixPluginLibPath SQLiteStudio.app/Contents/PlugIns/libDbSqliteCipher.dylib libcrypto.3.dylib
fixPluginLibPath SQLiteStudio.app/Contents/PlugIns/libScriptingTcl.dylib libtcl8.6.dylib
function replaceInfo() {
cdir=`pwd`
echo Replacing Info.plist
cd "$1/SQLiteStudio"
VERSION=`SQLiteStudio.app/Contents/MacOS/sqlitestudiocli -v | awk '{print $2}'`
YEAR=`date '+%Y'`
cd SQLiteStudio.app/Contents
sed "s/%VERSION%/$VERSION/g" Info.plist | sed "s/%YEAR%/$YEAR/g" > Info.plist.new
echo "New plist:"
cat Info.plist.new
mv Info.plist.new Info.plist
cd "$cdir"
}
if [ "$3" == "dmg" ]; then
replaceInfo "$1"
"$qt_deploy_bin" SQLiteStudio.app -dmg
elif [ "$3" == "dist" ]; then
replaceInfo "$1"
"$qt_deploy_bin" SQLiteStudio.app -dmg -executable=SQLiteStudio.app/Contents/MacOS/SQLiteStudio -always-overwrite -verbose=3
cd "$1/SQLiteStudio"
VERSION=`SQLiteStudio.app/Contents/MacOS/sqlitestudiocli -v | awk '{print $2}'`
mv SQLiteStudio.dmg sqlitestudio-$VERSION.dmg
hdiutil attach sqlitestudio-$VERSION.dmg
hdiutil detach /Volumes/SQLiteStudio
# Convert image to RW and attach
hdiutil convert sqlitestudio-$VERSION.dmg -format UDRW -o sqlitestudio-rw-$VERSION.dmg
hdiutil attach -readwrite sqlitestudio-rw-$VERSION.dmg
# Fix sqlite3 file in the image
cp -RPf "$libdir/libsqlite3.0.dylib" /Volumes/SQLiteStudio/SQLiteStudio.app/Contents/Frameworks/
# Fix python dependencies in the image
rm -f /Volumes/SQLiteStudio/SQLiteStudio.app/Contents/Frameworks/libpython*
rm -f /Volumes/SQLiteStudio/SQLiteStudio.app/Contents/Frameworks/libint*
install_name_tool -change "@loader_path/../Frameworks/libpython3.9.dylib" libpython3.9.dylib /Volumes/SQLiteStudio/SQLiteStudio.app/Contents/PlugIns/libScriptingPython.dylib
# Detach RW image
hdiutil detach /Volumes/SQLiteStudio
hdiutil compact sqlitestudio-rw-$VERSION.dmg
# Convert image back to RO and compressed
rm -f sqlitestudio-$VERSION.dmg
hdiutil convert sqlitestudio-rw-$VERSION.dmg -format UDZO -o sqlitestudio-$VERSION.dmg
rm -f sqlitestudio-rw-$VERSION.dmg
echo "Verifying contents of new image:"
hdiutil attach sqlitestudio-$VERSION.dmg
ls -l /Volumes/SQLiteStudio/SQLiteStudio.app/Contents/Frameworks
hdiutil detach /Volumes/SQLiteStudio
echo "Done."
else
"$qt_deploy_bin" SQLiteStudio.app
replaceInfo "$1"
fi
|
