From 0e41fe0f2f37a43ab4fb97d6e1ec2997f847fb0b Mon Sep 17 00:00:00 2001 From: Sean Bright Date: Mon, 16 Jan 2012 14:27:57 +0000 Subject: [PATCH] Sort the output of 'database show' by key. This more closely mimics the behavior of 'database show' before the conversion to sqlite3. git-svn-id: https://origsvn.digium.com/svn/asterisk/branches/10@350938 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- main/db.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/main/db.c b/main/db.c index 75f6eafabe..e4135821fd 100644 --- a/main/db.c +++ b/main/db.c @@ -119,8 +119,8 @@ DEFINE_SQL_STATEMENT(get_stmt, "SELECT value FROM astdb WHERE key=?") DEFINE_SQL_STATEMENT(del_stmt, "DELETE FROM astdb WHERE key=?") 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 ? || '/' || '%'") -DEFINE_SQL_STATEMENT(gettree_all_stmt, "SELECT key, value 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(create_astdb_stmt, "CREATE TABLE IF NOT EXISTS astdb(key VARCHAR(256), value VARCHAR(256), PRIMARY KEY(key))") -- 2.47.2