dotfiles/setup-macos-mysql-work.sh at master · laurynas-biveinis/dotfiles · GitHub

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
#!/bin/zsh

set -euo pipefail

# Do setup-macos-python.sh first

brew install ghostscript bison libfido2 doxygen graphviz lz4 libeatmydata \
	rapidjson protobuf@21 llvm@14 llvm@15 llvm@16 llvm@17 llvm@18 llvm@19 \
	llvm@20 openblas perl mysql-client@8.0

# Set the default clang-format version to what upstreams use. Note that this
# does not affect clangd.
sudo ln -sf /opt/homebrew/opt/llvm@18/bin/clang-format \
	/usr/local/bin/clang-format
brew link protobuf@21

# Needs to be re-executed after every XCode update
sudo ln -sf /opt/homebrew/opt/gcc/lib/gcc/current/libgfortran.a \
	$(xcode-select -p)/Platforms/MacOSX.platform/Developer/SDKs/MacOSX.sdk/usr/lib/libgfortran.a

# Perl
# TODO(laurynas): does not survive upgrades, do what the Perl formula advises
# with local::lib
/opt/homebrew/opt/perl/bin/cpan DBI
/opt/homebrew/opt/perl/bin/cpan JSON
/opt/homebrew/opt/perl/bin/cpan Expect
# Adjust path only for compilation below. For now I don't need it globally
export PATH="/opt/homebrew/opt/mysql-client@8.0/bin:$PATH"
# Will fail
# https://stackoverflow.com/questions/53277884/installation-of-dbdmysql-fails-with-symbol-not-found-on-osx-mojave
/opt/homebrew/opt/perl/bin/cpan DBD::mysql
# Go to ~/.cpan/build/DBD-mysql-<latest> and do:
perl Makefile.PL \
	--libs="-L/opt/homebrew/opt/mysql-client@8.0/lib -L/opt/homebrew/lib -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv"
sudo make install

# Python
mkdir ~/vilniusdb
virtualenv ~/vilniusdb/mysql-python-env
source ~/vilniusdb/mysql-python-env/bin/activate
# https://github.com/orgs/Homebrew/discussions/5547#discussioncomment-10292879
export PKG_CONFIG_PATH="$(brew --prefix)/opt/mysql-client@8.0/lib/pkgconfig"
pip install --force-reinstall --no-cache mysqlclient
pip install mysql-connector-python==8.0.33