diff options
author | Kaarle Ritvanen <kaarle.ritvanen@datakunkku.fi> | 2018-09-01 11:36:57 +0300 |
---|---|---|
committer | Kaarle Ritvanen <kaarle.ritvanen@datakunkku.fi> | 2018-09-01 21:34:45 +0300 |
commit | a2ffa20983a370206ac84f2a3fef8b9dee4309c1 (patch) | |
tree | 6c2a3a4fb8a3eec61a3eb70e11af5ed27d379b27 | |
parent | 8e37fb1ddea5c72a25d1971ef9634dca12d3c39d (diff) | |
download | dmvpn-tools-a2ffa20983a370206ac84f2a3fef8b9dee4309c1.tar.bz2 dmvpn-tools-a2ffa20983a370206ac84f2a3fef8b9dee4309c1.tar.xz |
select_certs: support ordering
-rwxr-xr-x | dmvpn-ca | 11 |
1 files changed, 7 insertions, 4 deletions
@@ -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(...) |