view examples/blog/src/lib/Post.luan @ 1395:9dfff82dfc59

finish postgres work
author Franklin Schmidt <fschmidt@gmail.com>
date Mon, 09 Sep 2019 01:22:23 -0600
parents bc40bc9aab3a
children 82415c9c0015
line wrap: on
line source

local Luan = require "luan:Luan.luan"
local error = Luan.error
local ipairs = Luan.ipairs or error()
local type = Luan.type or error()
local Time = require "luan:Time.luan"
local now = Time.now or error()
local String = require "luan:String.luan"
local trim = String.trim or error()
local db = require("site:/lib/Db.luan").db or error()


local Post = {}

local function from_doc(doc)
	return Post.new {
		id = doc.id
		subject = doc.subject
		content = doc.content
		date = doc.date
	}
end

function Post.new(this)
	type(this.subject)=="string" or error "subject must be string"
	type(this.content)=="string" or error "content must be string"
	this.date = this.date or now()

	function this.save()
		local doc = {
			type = "post"
			id = this.id
			subject = this.subject
			content = this.content
			date = this.date
		}
		db.save(doc)
		this.id = doc.id
	end

	return this
end

function Post.get_by_id(id)
	local doc = db.get_document("id:"..id)
	return doc and from_doc(doc)
end

function Post.get_all()
	local docs = db.search("type:post",1,1000,{sort="id desc"})
	local posts = {}
	for _, doc in ipairs(docs) do
		posts[#posts+1] = from_doc(doc)
	end
	return posts
end

function Post.search(query)
	query = trim(query)
	if #query == 0 then
		return Post.get_all()
	end
	local docs = db.search(query,1,1000)
	local posts = {}
	for _, doc in ipairs(docs) do
		posts[#posts+1] = from_doc(doc)
	end
	return posts
end

function Post.delete_by_id(id)
	db.delete("id:"..id)
end

return Post