aok1425

SELECT ML.PERSON.MEDRECNO AS MRN, ML.OBS.HDID, ML.OBS.OBSVALUE, ML.OBS.OBSDATE
FROM ML.PERSON INNER JOIN ML.OBS ON ML.PERSON.PID = ML.OBS.PID
WHERE ML.OBS.OBSDATE <= ADD_MONTHS(LAST_DAY(SYSDATE), -1) AND ML.OBS.OBSDATE > ADD_MONTHS(LAST_DAY(SYSDATE), -14) AND ML.OBS.XID = 100000000000000000000000000000000000 AND ML.OBS.CHANGE <10 AND 
(ML.OBS.HDID = 2451
OR ML.OBS.HDID = 2753 
OR ML.OBS.HDID =18283
OR ML.OBS.HDID = 92 
OR ML.OBS.HDID = 6857
OR ML.OBS.HDID = 2323
OR ML.OBS.HDID = 2719

aok1425

# filenames MUST start w COD or DOR, for MCMOnlyUnit()

import pandas as pd
import pypyodbc 
import os
from datetime import datetime
from math import isnan
from shutil import copy as copy_file
from numpy import float64

aok1425

$ tmux new -s session-name
$ tmux a -t session-name # to attach to particular session
	
$ tmux detach 
or
$ Ctrl-b d

aok1425

from IPython.core.debugger import Tracer; Tracer()()

aok1425

# adapted from https://github.com/alaw1290/CS591B1/blob/master/RTscrapers/moviescraper.py

from bs4 import BeautifulSoup
from selenium import webdriver
import locale
locale.setlocale( locale.LC_ALL, 'en_US.UTF-8' )
import datetime

driver = webdriver.Chrome("/usr/lib/chromium-browser/chromedriver")
# driver = webdriver.PhantomJS() # oesn't work, for whatever reason

aok1425

# push subfolder in git repo called "app" to heroku
git push heroku `git subtree split --prefix app master`:master --force

###

pd.set_option('max_colwidth', 400)

from IPython.display import display
with pd.option_context("display.max_columns", 50):
    display(df.head(2))

aok1425

brew install wine winetricks wget
winetricks directplay
cd ~/Documents
wget https://www.dropbox.com/s/6k82coiruvysezp/aoe2_tc_1_4.zip
unzip aoe2_tc_1_4.zip

echo "INSTALLED!"
echo "Run winecfg, go to graphics tab, check 'Emulate a virtual desktop' and set initial resolution"
echo "Command to play:"
echo "  $ wine ~/Documents/aoe2_tc/Age2_x1/age2_x1.exe NormalMouse"

aok1425

sudo add-apt-repository -y ppa:wine/wine-builds
sudo apt update
sudo apt install winehq-devel winetricks
winetricks directplay
cd ~/Documents
wget https://www.dropbox.com/s/6k82coiruvysezp/aoe2_tc_1_4.zip
unzip aoe2_tc_1_4.zip

echo "INSTALLED!"
echo "Command to play:"

aok1425

aok1425