#!/usr/bin/env python

import sqlite3

conn = sqlite3.connect(':memory:')
conn.execute("Create Table User (Name)")
conn.execute("insert into user (name) values ('user1')")
r = conn.execute('select name from user')
conn.commit()
lr = list(r)
assert lr == [(u'user1',)], 'got {}'.format(lr)