aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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(...)