sqlite test

jpTest.py

## -*- coding: utf-8 -*-
"""
SQLITEで日本語を使用するテスト
"""
import sqlite3
import charcode

def createDB():
    con = sqlite3.connect("./db/jpTest.db")
    csr = con.cursor()
    csr.execute('create table test(id serial,name text,price text)')


def test():
    con = sqlite3.connect("./db/jpTest.db")
    csr = con.cursor()
    csr.execute('insert into test(name,price) values(?,?)',(u"てすと","100"))
    con.commit()

    csr.execute('select name,price from test;')

    for name,price in csr.fetchall():
        print name.encode('utf-8')
        print price
    con.close()

test()