identity: Make SQL query order by recent dates first.
closes vanadium/issues#298
Change-Id: I5cb4042cbe2cd125a6a7372ec685ac6c8fb5a335
diff --git a/services/identity/internal/auditor/sql_database.go b/services/identity/internal/auditor/sql_database.go
index a79f753..c2bc071 100644
--- a/services/identity/internal/auditor/sql_database.go
+++ b/services/identity/internal/auditor/sql_database.go
@@ -38,7 +38,7 @@
if err != nil {
return nil, err
}
- queryStmt, err := db.Prepare(fmt.Sprintf("SELECT Email, Caveats, Timestamp, Blessings FROM %s WHERE Email=?", table))
+ queryStmt, err := db.Prepare(fmt.Sprintf("SELECT Email, Caveats, Timestamp, Blessings FROM %s WHERE Email=? ORDER BY Timestamp DESC", table))
return sqlDatabase{insertStmt, queryStmt}, err
}