ClassORMLite

local orm = require "framework.orm"

New Context

local context = orm.new(, { ["tablename"] =

, ... })

local db = sqlite3.open(sandbox:resolveFile("data:///testorm2.sqlite"))
local blob_model = {
    -- ["id"] = "integer primary key", -- id is not required to define.
    ["path"] = "text",
    ["temppath"] = "text",
    ["name"] = "text",
    ["typeid"] = "integer",
    ["contenttype"] = "text",
    ["md5"] = "text",
    ["size"] = "integer",
    ["status"] = "integer default 0"
}

local block_model = {
    ["blobid"] = "integer",
    ["bg"] = "integer default 0",
    ["ed"] = "integer default 0",
    ["hash"] = "text",
    ["status"] = "integer"
}

local context = orm.new(db, {
    ["blob"] = blob_model,
    ["block"] = block_model
})

insert row

local row = context.("new|insert", {modelmap})

local row = context.blob("new", {
    path = "test",
    size = 123
})

update row

row.path = nil
row.typeid = "2"
row:update()

get all or by condition

local results = context.("list|select", format, ...)

local results = context.blob("list", "id>? and typeid=?", 40, 2)
for k,v in ipairs(results) do
    print(v.id)
end

delete

context.("delete", format, ...) or row:delete()

context.blob("delete", "id=? and typeid=?", 40, 2)