sqlite decorator test

decoConnect.py

## -*- coding: utf-8 -*-
"""
DecoでConnect
"""
import sqlite3
import charcode


def dbConnect(func):
    def _dbConnect(*args,**kw):
        con = sqlite3.connect("./db/jpTest.db")
        csr = con.cursor()
        result = func(csr)
        con.close()
        return result
    return _dbConnect

@dbConnect
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()