CC Farm Database

-- Farm database
-- author: SukaiPoppuGo
--
local _db = {
  {["block"]="minecraft:wheat",      ["crop"]="minecraft:wheat",     ["seed"]="minecraft:wheat_seeds",    ["stem"]=false,},
  {["block"]="minecraft:carrots",    ["crop"]="minecraft:carrot",     ["seed"]="minecraft:carrot",        ["stem"]=false,},
  {["block"]="minecraft:potatoes",   ["crop"]="minecraft:potato",     ["seed"]="minecraft:potato",        ["stem"]=false,}, --item minecraft:poisonous_potato
  {["block"]="minecraft:melon_block",["crop"]="minecraft:melon",      ["seed"]="minecraft:melon_seeds",   ["stem"]="minecraft:melon_stem",},
  {["block"]="minecraft:pumpkin",    ["crop"]="minecraft:pumpkin",    ["seed"]="minecraft:pumpkin_seeds", ["stem"]="minecraft:pumpkin_stem",},
  {["block"]="minecraft:reeds",      ["crop"]="minecraft:reeds",      ["seed"]="minecraft:reeds",         ["stem"]=false,},
  {["block"]="minecraft:nether_wart",["crop"]="minecraft:nether_wart",["seed"]="minecraft:nether_wart",   ["stem"]=false,},
  {["block"]="minecraft:beetroots",  ["crop"]="minecraft:beetroot",   ["seed"]="minecraft:beetroot_seeds",["stem"]=false,},
}

local _search = function(v)
    if v then
        local _,row
        for _,row in pairs(_db) do
            local __,_v
            for __,_v in pairs(row) do
                if _v==v then return true, row end
            end
        end
        return false,nil
    end
end

query = function(k,v)
    v = v or false
    local _,row
    local result={}
    for _,row in pairs(_db) do
        if v and row[k] and row[k]==v then return true, row
        else if row[k] then table.insert(result, row[k]) end end
    end
    if #result>0 then return true,result
    else return false,nil end
end

blockFrom = function(v)
    local b,result = _search(v)
    if b then return result["block"]
    else return nil end
end
seedFrom = function(v)
    local b,result = _search(v)
    if b then return result["seed"]
    else return nil end
end
cropFrom = function(v)
    local b,result = _search(v)
    if b then return result["crop"]
    else return nil end
end
hasStem = function(v)
    local b,result = _search(v)
    if b then return result["stem"]
    else return nil end
end