aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorKaarle Ritvanen <kaarle.ritvanen@datakunkku.fi>2018-09-01 11:36:57 +0300
committerKaarle Ritvanen <kaarle.ritvanen@datakunkku.fi>2018-09-01 21:34:45 +0300
commita2ffa20983a370206ac84f2a3fef8b9dee4309c1 (patch)
tree6c2a3a4fb8a3eec61a3eb70e11af5ed27d379b27
parent8e37fb1ddea5c72a25d1971ef9634dca12d3c39d (diff)
downloaddmvpn-tools-a2ffa20983a370206ac84f2a3fef8b9dee4309c1.tar.bz2
dmvpn-tools-a2ffa20983a370206ac84f2a3fef8b9dee4309c1.tar.xz
select_certs: support ordering
-rwxr-xr-xdmvpn-ca11
1 files changed, 7 insertions, 4 deletions
diff --git a/dmvpn-ca b/dmvpn-ca
index 9ae3caa..79c14c2 100755
--- a/dmvpn-ca
+++ b/dmvpn-ca
@@ -149,8 +149,11 @@ end
function delete(tbl, filter) execute('DELETE FROM '..tbl..where(filter)) end
-function select_many(what, from, filter, mode)
- local cur = execute('SELECT '..what..' FROM '..from..where(filter))
+function select_many(what, from, filter, mode, order)
+ local cur = execute(
+ 'SELECT '..what..' FROM '..from..where(filter)..
+ (order and ' ORDER BY '..order or '')
+ )
return function()
local row = cur:fetch(mode and {}, mode)
if row == nil then cur:close() end
@@ -158,8 +161,8 @@ function select_many(what, from, filter, mode)
end
end
-function select_certs(filter)
- return select_many('*', 'certificate', filter, 'a')
+function select_certs(filter, order)
+ return select_many('*', 'certificate', filter, 'a', order)
end
function select_one(...)