rsperl

import pymssql

server = 'hostname.domainname'
database = 'mydb'
username = 'myuser'
password = 'mypass'

conn = pymssql.connect(server, username, password, database)
cursor = conn.cursor(as_dict=True)
cursor.execute('select 6 * 7 as [Result];')

rsperl

#!/usr/bin/env python

# src: http://pandas.pydata.org/pandas-docs/stable/io.html#io-excel-reader

import pandas as pd

# get a dataframe from xlsx object
xlsx = pd.ExcelFile('path_to_file.xls')
df = pd.read_excel(xlsx, 'Sheet1')

rsperl

What Log Levels Mean

src: https://blog.bordum.dk/logging-tutorial-python.html

• fatal: wake me up on Sunday morning at 4am
• error: apologize to the user and raise a ticket
• warn: make a note in case it happens again
• info: everything is fine, just checking in
• debug: fill filesystem with stack traces

rsperl

people = [ ... list of people objects ... ]
people_by_age = sorted(people, key=lambda person: person.age)

rsperl

import subprocess

date = subprocess.Popen(['date', '+%c'], stdout=subprocess.PIPE, stderr=subprocess.PIPE)
(out, err) = date.communicate()
print("stdout:    {}".format(out))
print("stderr:    {}".format(err))
print("exit code: {}".format(date.returncode))

rsperl

import urllib
f = urllib.urlopen(day_url)
html = f.read()

rsperl

import xml.dom
try:
    dom = xml.dom.minidom.parseString(xml_content)
except ExpatError, e:
    print >> sys.stderr, 'Invalid XML:', e

for p_node in dom.getElementsByTagName('p'):
    print 'class of paragraph', p.attributes['class']
    for child in p_node.childNodes:
        print 'XML child node:', child

rsperl

import re
text = "bug 1: first bug\nbug 2: duplicate of bug 1\nbug 999: the last bug"
for m in re.finditer('bug (\d+):', text):
    print 'bug number: '+ m.group(1)

rsperl

import hashlib
f = open(filepath)
digest = hashlib.md5()
while True:
    buf = f.read(4096)
    if buf == "":
        break
    digest.update(buf)
f.close()
print digest.hexdigest()

rsperl

import sqlite3 as dbapi2
db = dbapi2.connect('mydb.sqlite')

cur1 = db.cursor()
cur1.execute('CREATE TABLE friends (name VARCHAR(255), phone int)')
cur1.commit()

cur1 = db.cursor()
cur1.execute('SELECT phone FROM friends WHERE name = ?', ['Fred']) # does proper quoting
for (phone) in cur1: