Skip to content

Instantly share code, notes, and snippets.

View nickwanhere's full-sized avatar

Nick Wan nickwanhere

  • Hong Kong
View GitHub Profile
@nickwanhere
nickwanhere / gist:1a65fc47b78ba81fc4f41b9ccb02587b
Created May 15, 2019 07:12
Craft 3 Query Super Table in Plugin
$entry = Entry::find()
->section('acount')
->leftJoin('{{%supertableblocks}} as supertableblocks', '[[supertableblocks.ownerId]] = [[entries.id]]')
->leftJoin('{{%stc_SUPERTABLEFILED}} as stc_backstopids', '[[stc_SUPERTABLEFILED.elementId]] = [[supertableblocks.id]]')
->andWhere(['stc_SUPERTABLEFILED.field_TARGET'=>$id])
->one();
@nickwanhere
nickwanhere / fix.sh
Created September 7, 2021 06:50
Mac Big Sur Pyenv install 2.7.11
CFLAGS="-I$(brew --prefix readline)/include -I$(brew --prefix openssl)/include -I$(xcrun --show-sdk-path)/usr/include" \
LDFLAGS="-L$(brew --prefix readline)/lib -L$(brew --prefix openssl)/lib" \
PYTHON_CONFIGURE_OPTS=--enable-unicode=ucs2 \
pyenv install -v 2.7.11
@nickwanhere
nickwanhere / x86_build.sh
Created June 17, 2022 08:31
Compile Rust under Mac OS with Open SSL without cross-compile. Use Docker instead.
LAMBDA_ARCH="linux/x86_64"
RUST_TARGET="x86_64-unknown-linux-gnu"
RUST_VERSION="latest"
APP_NAME="app_name"
docker run -it --platform ${LAMBDA_ARCH} --rm --user "$(id -u)":"$(id -g)" -v "${PWD}":/usr/src/myapp -w /usr/src/myapp rust:${RUST_VERSION} cargo build --release --target ${RUST_TARGET} -v
cp -v ./target/${RUST_TARGET}/release/${APP_NAME} ./build/bootstrap