diff options
author | Sean Bright <sean@malleable.com> | 2012-01-16 17:12:36 +0000 |
---|---|---|
committer | Sean Bright <sean@malleable.com> | 2012-01-16 17:12:36 +0000 |
commit | 409751e2dc5fe9e5973de9f3c989809f89f7b660 (patch) | |
tree | 6c367fe0296780b531807198be7922ae661f8276 /main/db.c | |
parent | 35fef9a7dcad2e7c7659245511a579d2066c894b (diff) |
Sort the output of 'database showkey' as well.
You can pass wildcards (%) to the database CLI commands, so this will sort the
returned list of matches.
........
Merged revisions 350978 from http://svn.asterisk.org/svn/asterisk/branches/10
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@350979 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'main/db.c')
-rw-r--r-- | main/db.c | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -121,7 +121,7 @@ DEFINE_SQL_STATEMENT(deltree_stmt, "DELETE FROM astdb WHERE key || '/' LIKE ? || DEFINE_SQL_STATEMENT(deltree_all_stmt, "DELETE FROM astdb") DEFINE_SQL_STATEMENT(gettree_stmt, "SELECT key, value FROM astdb WHERE key || '/' LIKE ? || '/' || '%' ORDER BY key") DEFINE_SQL_STATEMENT(gettree_all_stmt, "SELECT key, value FROM astdb ORDER BY key") -DEFINE_SQL_STATEMENT(showkey_stmt, "SELECT key, value FROM astdb WHERE key LIKE '%' || '/' || ?") +DEFINE_SQL_STATEMENT(showkey_stmt, "SELECT key, value FROM astdb WHERE key LIKE '%' || '/' || ? ORDER BY key") DEFINE_SQL_STATEMENT(create_astdb_stmt, "CREATE TABLE IF NOT EXISTS astdb(key VARCHAR(256), value VARCHAR(256), PRIMARY KEY(key))") static int init_stmt(sqlite3_stmt **stmt, const char *sql, size_t len) |