Goal: Connect to MSSQL using FreeTDS / ODBC in Python.
Host: Linux Mint 15 x86_64
Install:
sudo apt-get install python-dev python-pip freetds-dev freetds-bin unixodbc-dev tdsodbc
pip install pyodbc
In /etc/odbcinst.ini:
import argparse | |
import os | |
import glob | |
def main(): | |
#Does not currently have support to read files from folders recursively | |
parser = argparse.ArgumentParser(description='Read in a file or set of files, and return the result.', formatter_class=argparse.ArgumentDefaultsHelpFormatter) | |
parser.add_argument('path', nargs='+', help='Path of a file or a folder of files.') | |
parser.add_argument('-e', '--extension', default='', help='File extension to filter by.') | |
args = parser.parse_args() |
d = {1:11, 2:22, 3:33} | |
# filter by key | |
d2 = {k : v for k,v in filter(lambda t: t[0] in [1, 3], d.iteritems())} | |
# filter by value | |
d3 = {k : v for k,v in d.iteritems() if k in [2,3]} |
import time | |
from progress.bar import Bar # sudo pip install progress | |
bar = Bar('Processing', max=20, suffix='%(index)d/%(max)d - %(percent).1f%% - %(eta)ds') | |
for i in range(20): | |
time.sleep(.05) # Do some work | |
bar.next() | |
bar.finish() |
package com.example.json | |
import net.liftweb.json._ | |
object HelloJson extends App { | |
case class Address(city: String, state: String) | |
case class Person(name: String, addresses: List[Address]) | |
implicit val formats = DefaultFormats |
def sliding(iterable, n): | |
return [iterable[i:i+n] for i in range(len(iterable) - n + 1)] | |
def xsliding(iterable, n): | |
for i in range(len(iterable) - n + 1): | |
yield iterable[i:i+n] | |
def reversed_iter(iterable): | |
return iterable[::-1] |
object Palandrome { | |
def main(args: Array[String]) { | |
val s = "meow woow ooooooo doggies aaadddfffdddaaa wow" | |
println("finding the longest palandrome of: " + s) | |
println(longestPal(s)) | |
} | |
def longestPal(s: String) = { | |
longestPalN(s, s.length) |
Goal: Connect to MSSQL using FreeTDS / ODBC in Python.
Host: Linux Mint 15 x86_64
Install:
sudo apt-get install python-dev python-pip freetds-dev freetds-bin unixodbc-dev tdsodbc
pip install pyodbc
In /etc/odbcinst.ini:
# Setup: | |
# 1) sudo pip install awscli | |
# 2) the following environment variables must be set | |
# - $ export AWS_ACCESS_KEY_ID=<access_key> | |
# - $ export AWS_SECRET_ACCESS_KEY=<secret_key> | |
import collections | |
import datetime | |
import json | |
import subprocess |
import glob | |
import os | |
def filelist(path, _filter="part-*"): | |
basepath = os.path.abspath(os.path.expanduser(path)) | |
return [filename for filename in glob.glob(basepath + '/' + _filter)] | |
def hfile(path, _filter="part-*"): | |
for filename in filelist(path, _filter): | |
with open(filename) as f: |