powellc

#!/usr/bin/env python
from __future__ import with_statement # needed for python 2.5
from fabric.api import *
from fabric.contrib.console import confirm

# ================================================================
# NOTE: 
#    using this fabfile expects that you have the python utility
# fabric installed locally, ssh access to reamea.com, and your
# ssh public key associated with the account 'mboza@reamea.com'

powellc

#!/bin/bash

# The purpose of this file is to, as quickly as possible, set up a home directory 
# with all the creature comforts I expect.
#
# For this to work:
#   1. Add ssh keys to github and personal git repo
#   2. sudo aptitude install zsh git-core

mkdir $HOME/.virtualenvs

powellc

# terminfo and termcap for nice 256 color terminal
# allow bold colors - necessary for some reason
attrcolor b ".I"
# tell screen how to set colors. AB = background, AF=foreground
termcapinfo xterm 'Co#256:AB=\E[48;5;%dm:AF=\E[38;5;%dm'
# erase background with current bg color
defbce "on"

powellc

export TERM=xterm-256color

# Default the box color to red, but change to differentiate boxes or VPSs
export BOXCOLOR="%{$fg[red]%}"

# Path to your oh-my-zsh configuration.
export ZSH=$HOME/.oh-my-zsh

# Set to the name theme to load.
# Look in ~/.oh-my-zsh/themes/

powellc

#!/bin/bash

###
###  This script simply parses ifconfig and loads a box's main IP into a shell variable
###

OS=`uname`
IP="" # store IP
case $OS in
   Linux) IP=`ifconfig  | grep 'inet addr:'| grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}' | grep 24 `;;

powellc

diff --git a/src/adzone/managers.py b/src/adzone/managers.py
index 347e85e..271e36d 100644
--- a/src/adzone/managers.py
+++ b/src/adzone/managers.py
@@ -8,8 +8,15 @@ class AdManager(models.Manager):
         Returns a random advert that belongs to the specified category and zone
         
         """
-        try:
-            ad = self.get_query_set().filter(category__slug=ad_category, zone__slug=ad_zone).order_by('?')[0]

powellc

#!/usr/bin/python
import sys
sys.path.append('<path_to_virtualenv>')

from gevent import monkey; monkey.patch_all()
from gevent.wsgi import WSGIServer
import os
import traceback
from django.core.handlers.wsgi import WSGIHandler
from django.core.management import call_command

powellc

#!/bin/bash
# Location to place backups.
backup_dir="/var/backups/databases/"
nightly_dir="/var/backups/databases/latest/"
#String to append to the name of the backup files
backup_date=`date +%d-%m-%Y`
#Numbers of days you want to keep copie of your databases
number_of_days=15
databases=`psql -l -t | cut -d'|' -f1 | sed -e 's/ //g' -e '/^$/d'`
for i in $databases; do  if [ "$i" != "postgres" ] && [ "$i" != "template0" ] && [ "$i" != "template1" ] && [ "$i" != "template_postgis" ]; then    

powellc

#!/bin/bash
 
DB_BACKUP="/var/backups/databases/"
LATEST_DIR="/var/backups/databases/latest/"

DB_USER="root"
DB_PASSWD="secretttt"
HN=`hostname | awk -F. '{print $1}'`
 
# Remove backups older than 10 days

powellc

echo "Your database name [Enter]: "
read YOUR_DB
echo "New owner name [Enter]: "
read NEW_OWNER

# First alter tables
for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" $YOUR_DB` ; do  
  psql -c "alter table $tbl owner to $NEW_OWNER" $YOUR_DB ; 
done