st4lk

import Cookie

# to fix http://bugs.python.org/issue2193 have to create own SimpleCookie
_LegalChars = Cookie._LegalChars + ":"


def _quote(str, LegalChars=_LegalChars, **kwargs):
	return Cookie._quote(str, LegalChars=_LegalChars, **kwargs)

st4lk

# -*- coding: utf-8 -*-
"""
Example of less-legged client workflow using OAuth means.
OAuth 1.0a is a 3-legged process. Less-legged process is not an OAuth 1.0a,
it just use similiar means, but people used to call it OAuth...
With 2-legged process user is not interacted in process.
In such workflow client application is acting like a user.
So client can fetch resources avaliable either to all users, either it can
access to resources owned by itself (even private).

st4lk

"""
Example of OAuth 2.0 process with client-side only web page.
We can access to user's resources without providing a client_secret!
Given access_token will be short-lived, about 1 or 2 hours, whereas
access_token given by server-side workflow is long-lived, up to 60 days.
http://stackoverflow.com/questions/9067947/facebook-access-token-server-side-vs-client-side-flows
API of facebook is used: https://developers.facebook.com/docs/facebook-login/manually-build-a-login-flow
"""
import webbrowser
import urllib2

st4lk

(?<=<h2>).+(?=</h2>)

st4lk

import csv
import logging

def get_csv_lines(file_name, encoding='cp1251'):
    try:
        lines = []
        with open(file_name, 'rb') as f:
            reader = csv.reader(f, delimiter=";")
            for line in reader:
                decoded_line = []

st4lk

from xlrd import open_workbook
from xlutils.copy import copy

def save_workbook_copy(file_from, file_to):
    rb = open_workbook(file_from, formatting_info=True)
    wb = copy(rb)  # a writable copy (I can't read values out of this, only write to it)
    w_sheet = wb.get_sheet(0)  # the sheet to write to within the writable copy
    row_index = 0
    col_index = 0
    w_sheet.write(row_index, col_index,'DataToBeWritten')

st4lk

from xlrd import open_workbook


def is_row_hidden(sheet, row_n):
    try:
        if sheet.rowinfo_map[row_n].hidden:
            return True
    except KeyError:
        #  empty row, treat as hidden
        pass

st4lk

from config import Session
from models import Person

session = Session()
persons = session.query(Person).filter(Person.name == u"Василий Пупкин", Person.status == STATUS.employer)
persons = session.query(Person).filter(Person.info.like(u"%Веб%"))
for person in persons:
    print person.link

st4lk

import pickle

with open('data.pkl', 'wb') as output:
    pickle.dump(data1, output)
    pickle.dump(data2, output)

with open('data.pkl', 'rb') as pkl_file:
    data1 = pickle.load(pkl_file)
    data2 = pickle.load(pkl_file)

st4lk

python setup.py install
paster create --template=spider site.ru
paster create --list-templates