module(..., package.seeall)

-- Load libraries
require("modelfunctions")
require("fs")
require("format")

-- Set variables
local processname = "postgresql"
local packagename = "postgresql"
local datadirectory = "/var/lib/postgresql/data/"
local pidfile = "postmaster.pid"

local path = "PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin "

local filelist = fs.find_files_as_array(".*\.conf", datadirectory)

-- ################################################################################
-- LOCAL FUNCTIONS

-- ################################################################################
-- PUBLIC FUNCTIONS

function startstop_service(action)
	return modelfunctions.startstop_service(processname, action, {"Setup", "Start", "Stop", "Restart"})
end

function getstatus()
	local status = modelfunctions.getstatus(processname, packagename, "Postgresql Status")

	-- Enabled status is unique for postgresql
	-- Look for pid file stored in data_directory .. /postmaster.pid
	local file = datadirectory .. pidfile
	-- check to see if there's a matching proc directory and that it was created slightly after the pid file
	-- this allows us to avoid the problem with proc numbers wrapping
	local tmp = string.match(fs.read_file(file) or "", "%d+")
	if tmp then
		local dir = "/proc/" .. tmp
		filetime = posix.stat(file, "ctime")
		dirtime = posix.stat(dir, "ctime")
		if dirtime and (tonumber(dirtime) - tonumber(filetime) < 100) then
			status.value.status.value = "Running"
		end
	end

	return status
end

function getstatusdetails()
	return cfe({ type="longtext", value="", label="Postgresql Status Details" })
end

function getfilelist()
	local listed_files = {}

	for i,name in ipairs(filelist) do
		local filedetails = fs.stat(name) or {}
		table.insert ( listed_files , {filename=name, mtime=filedetails.mtime or "---", filesize=filedetails.size or "0"} )
	end

	table.sort(listed_files, function (a,b) return (a.filename < b.filename) end )

	return cfe({ type="list", value=listed_files, label="Postgresql File List" })
end

function getfiledetails(filename)
	return modelfunctions.getfiledetails(filename, filelist)
end

function updatefiledetails(filedetails)
	return modelfunctions.setfiledetails(filedetails, filelist)
end