# -*- cording:UTF-8 -*-

import sqlite3

# Connection Object
conn = sqlite3.connect(":memory:")

# Create Cursor
c = conn.cursor()


# Create Table
c.execute("""
    CREATE TABLE person(
    uid int primary key,
    name text,
    age int
    )
""")


# Insert Data
rows = ((1,u"ふみ",27),
        (2,u"ぱいそん",25),
        (3,u"ぞーぷ",30),
        (4,u"すぱむ",45),
        (5,u"とーすと",15),
        (6,u"えっぐ",39))

for row in rows:
    c.execute("INSERT INTO person (uid, name, age) VALUES (?,?,?)",row)


# Select ALL
c.execute("SELECT * FROM person ORDER BY uid")

print "-"*40
print "select all"
print "-"*40

for row in c:
    print row[0],row[1],row[2]

# Select (uid > 2)
c.execute("SELECT * FROM person WHERE uid > 2 ORDER BY uid")

print "-"*40
print "select uid > 2"
print "-"*40

for row in c:
    print row[0],row[1],row[2]


# Connection Close
conn.close()