1. Prometheus Research, LLC
  2. Prometheus
  3. htsql


htsql / tool / data / vm / py27-update.sh


# Post-installation script for the py27 VM.
set -ex

# Update the hostname.
echo py27-vm >/etc/hostname

# Enable HTTPS for APT repositories.
apt-get -q update
apt-get -qy install apt-transport-https

# Register the testing repository.
echo "deb http://ftp.us.debian.org/debian/ wheezy main" >/etc/apt/sources.list.d/testing.list
cat <<END >>/etc/apt/preferences.d/pinning.pref
Package: *
Pin: release n=wheezy
Pin-Priority: 90
apt-get -q update

# Register the Oracle repository.
echo "deb https://oss.oracle.com/debian/ unstable main non-free" >/etc/apt/sources.list.d/oracle.list
wget -q https://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add -
apt-get -q update

# Install Mercurial.
apt-get -qy install mercurial

# Install Python dependencies from testing.
DEBIAN_FRONTEND=noninteractive \
apt-get -qy install -t wheezy gcc-4.4

# Install Python 2.7 and required Python packages.
apt-get -qy install -t wheezy python2.7
apt-get -qy install -t wheezy python-setuptools
apt-get -qy install -t wheezy python-yaml
apt-get -qy install -t wheezy python-pip
apt-get -qy install -t wheezy python-virtualenv

# Install development files for Python and database drivers.
apt-get -qy install -t wheezy python2.7-dev
apt-get -qy install libpq-dev
apt-get -qy install libmysqlclient-dev
apt-get -qy install freetds-dev
apt-get -qy install oracle-xe-client

# Clean APT cache.
apt-get clean

# Initialize Python virtual enviroment in `/root`.
virtualenv -p python2.7 --system-site-packages .

# Upgrade setuptools.
~/bin/pip -q install --upgrade distribute

# Install Django and SQLAlchemy.
~/bin/pip -q install Django
~/bin/pip -q install SQLAlchemy

# Install database adapters.
~/bin/pip -q install psycopg2
~/bin/pip -q install mysql-python
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client \
~/bin/pip -q install cx-oracle
~/bin/pip -q install pymssql -f http://pypi.python.org/pypi/pymssql/ --no-index

# Set the Oracle, FreeTDS and `virtualenv` environment variables on login.
cat <<END >>/root/.bashrc

export PATH=~/bin:\$PATH
export LD_LIBRARY_PATH=~/lib

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
export SQLPATH=\$ORACLE_HOME/sqlplus
export PATH=\$PATH:\$ORACLE_HOME/bin

export TDSVER=8.0