pyactiverecord 0.4.2

功能

• 类似mysql包装器的活动记录
• orm

要求

• python 3.x
• mysql
• mysql连接器python

安装

pip install pyactiverecord

用法

创建模型类。

import model


class SampleModel(model.Model):

    number = model.Column(type=model.Type.int)
    title = model.Column(type=modle.Type.varchar)
    text = model.Column(type=model.Type.text)
    date = model.Column(type=model.Type.timestamp)

此时，如果此表的模型类名的小写不是 存在，表自动创建。

pyactiverecord需要连接到数据库，程序需要 调用databese.setup（）方法。

import model

def execute():
    s = SampleModel()
    s.title = "test"
    s.text = "test to save sample model"
    s.save()

    s = SampleModel.query().first()
    print(s.title, s.text)


if __name__ == '__main__':

    model.Database.setup(
        host="localhost",
        database="database_name",
        user="root",
        password=""
    )

    execute()

方法

data = SampleModel.query()
for d in data:
    print(d.title)

# where
data = SampleModel.query(where=["title='py-activerecord'", "text like '%Python%'"])

# order
data = SampleModel.query(order=["id asc", "title desc"])

s = SampleModel()
s.number = 1
s.title = "py-activerecord"
s.text = "ActiveRecord for Python Library"
s.date = "2016-01-01 00:00:00"

s.save()

s = SampleModel.query(where=["title='py-activerecord'"], order=["id asc"]).first()
s.delete()