summaryrefslogtreecommitdiffstats
path: root/postgresql-model.lua
blob: 5ea63a0f12acbafa4e91a8df8a329fa32b4a510b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
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)
	-- Custom startstop to enable setup option
	local result = cfe({ label="Start/Stop result" })

	if (string.lower(action) == "start") or (string.lower(action) == "stop") or (string.lower(action) == "restart") or (string.lower(action) == "setup") then
		local file = io.popen(path .. "/etc/init.d/" .. processname .. " " .. string.lower(action) .. " 2>&1" )
		if file ~= nil then
			result.value = file:read( "*a" ) or ""
			file:close()
		end
		posix.sleep(2)-- Wait for the process to start|stop
	else
		result.errtxt = "Unknown command!"
	end

	return result
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