From a2ffa20983a370206ac84f2a3fef8b9dee4309c1 Mon Sep 17 00:00:00 2001 From: Kaarle Ritvanen Date: Sat, 1 Sep 2018 11:36:57 +0300 Subject: select_certs: support ordering --- dmvpn-ca | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) (limited to 'dmvpn-ca') 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(...) -- cgit v1.2.3