-
Notifications
You must be signed in to change notification settings - Fork 177
/
module.lua
executable file
·52 lines (45 loc) · 1.74 KB
/
module.lua
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
local mysql = require "model.mysql"
local service_model = {}
function service_model.add(domain_id, name, host, description)
local db = mysql.getDb()
local res, err, errno, sqlstate = db:query("INSERT INTO agw_service (domain_id, name,host,description)values(\'"..domain_id.."\',\'"..name.."\',\'"..host.."\',\'"..description.."\')", 10)
db:set_keepalive(10000, 100)
return res, err
end
function service_model.deleteByDomainId(did)
local db = mysql.getDb()
local res, err, errno, sqlstate = db:query("DELETE FROM agw_service WHERE domain_id="..did, 10)
db:set_keepalive(10000, 100)
return res, err
end
function service_model.delete(id)
local db = mysql.getDb()
local res, err, errno, sqlstate = db:query("DELETE FROM agw_service WHERE id="..id, 10)
db:set_keepalive(10000, 100)
return res, err
end
function service_model.update(id, name, host, description)
local db = mysql.getDb()
local res, err, errno, sqlstate = db:query("UPDATE agw_service SET name=\'"..name.."\',host=\'"..host.."\',description=\'"..description.."\' WHERE id="..id, 10)
db:set_keepalive(10000, 100)
return res, err
end
function service_model.getService(id)
local db = mysql.getDb()
local services, err, errno, sqlstate = db:query("SELECT * FROM agw_service WHERE id="..id, 10)
service = nil
if table.getn(services) > 0 then
service = services[1]
else
err = "error service id"
end
db:set_keepalive(10000, 100)
return service, err
end
function service_model.getServices(domain_id)
local db = mysql.getDb()
local services, err, errno, sqlstate = db:query("SELECT * FROM agw_service WHERE domain_id="..domain_id, 10)
db:set_keepalive(10000, 100)
return services, err
end
return service_model