ClassORMLite

local orm = require "framework.orm"

New 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
})