deco args test

decoConnect.py

## -*- coding: utf-8 -*-
"""
decoratorに引数を持たせる
"""
import sqlite3
import charcode


def dbConnect(dbfile):
    def _dbConnect(func):
        def __dbConnect(*args,**kw):
            con = sqlite3.connect(dbfile)
            csr = con.cursor()
            result = func(csr)
            con.close()
            return result
        return __dbConnect
    return _dbConnect

@dbConnect("./db/jpTest.db")
def test(csr=None):
    
    csr.execute('select name,price from test;')
    for name,price in csr.fetchall():
        print name.encode('utf-8')
        print price

test()