python peewee用来干啥的

pip install peewee

//读取localhost中的ershouche数据表，然后生成模型到db.py

python -m pwiz -e mysql -H localhost -p 3306 -u root -P root  ershouche > db.py

#coding=utf-8

from datetime import datetime

from db import *

database.connect()

# 打印出所有元素

for i in Dmoz.select():

    print i.description

    print i.__dict__

# 增加数据

for i in range(10):

    print Dmoz.create(description="user", link="HuaDong", title="100000%s" % str(i))

# 删除数据

band = Dmoz.get(Dmoz.title == "1000001")

band.delete_instance()

# select语句

band = Dmoz.select().where(Dmoz.title == "1000000").get()

print band.link

# 更改数据

band = Dmoz.get(Dmoz.title == "1000000")

print band.link

band.link = "Beach Boys"

band.save()

print  band.link

# 连表查询，peewee也支持join语句

# album = Album.select().join(Dmoz).where(

#         (Album.title == "Thrive") & amp;

# (Dmoz.name == "Newsboys")

# ).get()

# album.title = "Step Up to the Microphone"

# album.save()