Initial commit for acf-mysqlv0.1.0

1 files changed, 62 insertions, 0 deletions

diff --git a/mysql-model.lua b/mysql-model.lua
new file mode 100644
index 0000000..2375097
--- /dev/null
+++ b/mysql-model.lua
@@ -0,0 +1,62 @@
+local mymodule = {}
+
+-- Load libraries
+modelfunctions = require("modelfunctions")
+fs = require("acf.fs")
+format = require("acf.format")
+db = require("acf.db")
+dbmodelfunctions = require("dbmodelfunctions")
+
+-- Set variables
+local conffile = "/etc/mysql/my.cnf"
+local processname = "mysql"
+local packagename = "mysql"
+
+local path = "PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin "
+
+local filelist
+
+-- ################################################################################
+-- LOCAL FUNCTIONS
+
+local determineconnection = function()
+	local port = format.parse_ini_file(fs.read_file(conffile), "client", "port")
+	return db.create(db.engine.mysql, nil, nil, nil, "", tonumber(port) or 3306)
+end
+
+-- ################################################################################
+-- PUBLIC FUNCTIONS
+
+function mymodule.get_startstop(self, clientdata)       
+	return modelfunctions.get_startstop(processname)
+end
+
+function mymodule.startstop_service(self, startstop, action)
+	return modelfunctions.startstop_service(startstop, action)
+end
+
+function mymodule.getstatus()
+	return modelfunctions.getstatus(processname, packagename, "MySQL Status")
+end
+
+function mymodule.getstatusdetails()
+	local retval = cfe({ type="longtext", value="", label="MySQL Status Details" })
+	retval.value, retval.errtxt = modelfunctions.run_executable({"mysqladmin", "extended-status"})
+	return retval
+end
+
+function mymodule.getfiledetails()
+	return modelfunctions.getfiledetails(conffile, {conffile})
+end
+
+function mymodule.updatefiledetails(self, filedetails)
+	return modelfunctions.setfiledetails(self, filedetails, {conffile})
+end
+
+for n,f in pairs(dbmodelfunctions) do
+	mymodule[n] = function(...)
+		return f(determineconnection, ...)
+	end
+end
+
+return mymodule