Skip to content

Instantly share code, notes, and snippets.

SELECT TOP 100 *
FROM [Aperio].[dbo].[Specimen] Specimen
INNER JOIN [Aperio].[dbo].[Slide] Slide
ON Slide.ParentId=Specimen.Id
INNER JOIN [Aperio].[dbo].[Image] Image
ON Image.ParentId=Slide.Id
WHERE Specimen.ColumnPublishToWeb2 = 'TRUE'
@bdunnette
bdunnette / Dockerfile
Created April 28, 2017 19:48
Dockerfile for Ubuntu 16.04 LTS & libvips-tools
FROM ubuntu:16.04
MAINTAINER Brian Dunnette <[email protected]>
RUN \
# Install dependencies
sed "s/archive.ubuntu.com/local-mirror.cs.umn.edu/g; \
s/security.ubuntu.com/local-mirror.cs.umn.edu/g" \
-i /etc/apt/sources.list && \
apt-get update && \
# cd to your Loopback project directory and run:
# curl https://gist.githubusercontent.com/bdunnette/a1854b4f0c5010cb7a539be5f2d63ef8/raw/add-gulp.sh | sh
REPO=https://gist.githubusercontent.com/bdunnette/a1854b4f0c5010cb7a539be5f2d63ef8/raw
echo client/vendor >> .gitignore
mv server/boot/root.js server/boot/root.js.bak
sed 's/\("files\".*\:.*{\)/&\"loopback\#static\"\:\{\"params\"\:\"\$\!\.\.\/client\"\}/' -i server/middleware.json
sed 's/\("compression\".*\:.*{\)/&\"enabled\":false/' -i server/middleware.json
mkdir -p client/js client/css server/fixtures
touch client/css/app.css server/fixtures/.gitkeep
wget -O gulpfile.js $REPO/gulpfile.js
@bdunnette
bdunnette / install-watchman.sh
Last active November 28, 2017 10:49 — forked from ivan-loh/install-watchman.sh
Watchman installation for Ubuntu 16.04
# checkout, compile & install
git clone https://github.com/facebook/watchman.git
cd watchman/
# git checkout v4.7.0
sudo apt install -y autoconf automake build-essential python-dev
./autogen.sh
./configure
make
sudo make install
echo "Using $1 for output..."
for s in *.pdf
do
i="${s%.*}"
printf "# $i\n\n" >> $1
echo $s
pdftotext $s - >> $1
done
@bdunnette
bdunnette / openpgp.txt
Created January 25, 2017 14:29
OpenKeychain Linked Identity
This Gist confirms the Linked Identity in my OpenPGP key, and links it to this GitHub account.
Token for proof:
[Verifying my OpenPGP key: openpgp4fpr:653209785db2920ed1ad006862be838daa8af7b8]
@bdunnette
bdunnette / openpgp.txt
Created January 25, 2017 14:29
OpenKeychain Linked Identity
This Gist confirms the Linked Identity in my OpenPGP key, and links it to this GitHub account.
Token for proof:
[Verifying my OpenPGP key: openpgp4fpr:653209785db2920ed1ad006862be838daa8af7b8]
# cd to your Firebase project directory and run:
# curl https://gist.githubusercontent.com/bdunnette/258eafa8425e3b7c89dc873c73a5cc2d/raw/add-gulp.sh | sh
REPO=https://gist.githubusercontent.com/bdunnette/258eafa8425e3b7c89dc873c73a5cc2d/raw
echo public/vendor >> .gitignore
echo node_modules >> .gitignore
mkdir -p public/js public/css
touch public/css/app.css
curl $REPO/gulpfile.js > gulpfile.js
curl $REPO/app.js > public/js/app.js
sed "s/myApp/${PWD##*/}/g" -i public/js/app.js
@bdunnette
bdunnette / fix-google-credentials
Created October 24, 2016 17:33
Update Google OAuth credentials in Meteor/Mongo
db.meteor_accounts_loginServiceConfiguration.update({"service":"google"},{$set:{"clientId":"your-client-id","secret":"your-secret"}})
// In SpectrumMin.js, find the ChooseViewer function...
function ChooseViewer(){var viewer=null;
// Insert the following line before if(wPressed||aPressed)...
if(IsChrome()){wPressed=true;} // If user is running Chrome, sets web viewer as default to avoid SIS download
if(wPressed||aPressed){if(SystemParms.SessionMode=="IVD"){alert("WebViewer is disabled in IVD mode");