michaelkarrer81

#!/bin/bash

usage()
{
cat << EOF
usage: $0 options

This script set ownership for all table, sequence and views for a given database

Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto

michaelkarrer81

Odoo - Rename an addon without losing data

Rename addon

• Change __openerp__.py addon name field
• Change README.rst file
• Change translations files (i18n folder, .po and .pot files)

michaelkarrer81

#!/bin/sh
#
# This hook is placed in Bare repository and it updates Working tree whenever a PUSH
# is executed
#
# Assuming following file structure:
# .
# |-- myproject
# |-- myproject.git
# set WORKTREE=../myproject

michaelkarrer81

##
## Use-case: Host in a remote git (on a ssh-able host) both pillars and states on Salt Stack 0.17.x
## 
## See thread: https://groups.google.com/forum/#!topic/salt-users/bOz2cdY-pnY
#
# Salt stack master and minion procedure, short version:
#
# - On the Master:
#
#     wget -O - http://bootstrap.saltstack.org | sudo sh -s -- -M git v0.17.0

michaelkarrer81

source: http://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/

`openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key]`

What this command does is extract the private key from the .pfx file. Once entered you need to type in the importpassword of the .pfx file.  This is the password that you used to protect your keypair when you created your .pfx file.  If you cannot remember it anymore you can just throw your .pfx file away, cause you won’t be able to import it again, anywhere!.  Once you entered the import password OpenSSL requests you to type in another password, twice!. This new password will protect your .key file.

Now let’s extract the certificate:

`openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt]`

michaelkarrer81

location /some/location {
  # check, if any query strings are available
  if( $args = '' ) {
    # no query found, so...
    return 301 /destination/url/;
  }

  # if it reaches here, then query is found, so...
  return 301 /destination/url/?$args;
}

michaelkarrer81

Creating a Happy Git Environment on OS X

Step 1: Install Git

brew install git bash-completion

Configure things:

git config --global user.name "Your Name"

git config --global user.email "[email protected]"

michaelkarrer81

If you have a huge repository (in size and in history) and want to add a subfolder 
to your project as a submodule you can follow this example to save time and space
using git's shallow clone and shallow checkout feature. It is a bit more complicated
in this example because I assume that you want your submodule to track a non-default
branch, called `mybranch`, instead of the `master` branch. Things could probably get
a lot simpler when using the default branch. After following the commands in these
examples you can use `git submodule update` and `git submodule update --remote` as normal.

michaelkarrer81

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

michaelkarrer81

import StringIO
from selenium import webdriver
from PIL import Image
 
 
# Install instructions
#
# npm install phantomjs
# sudo apt-get install libjpeg-dev
# pip install selenium pillow