listing mail

2 files changed, 2 insertions, 1 deletions

diff --git a/lib/db/index.js b/lib/db/index.js
index ab4cdcf..b6fa235 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -138,7 +138,7 @@ db.getMailboxCounts = function(boxes){
 db.getMessages = function(username, box, limit, offset){
   var mbox = username + "." + box
   return Message.query(function(qb){
-    qb.column('id', 'mbox', 'unread', 'sender', 'recipient', 'date', 'subject').where("mbox", "=", mbox).orderBy("id", "desc")
+    qb.column('id', 'mbox', 'unread', 'sender', 'recipient', 'date', 'subject', knex.raw("CHAR_LENGTH(body) as size")).where("mbox", "=", mbox).orderBy("id", "desc")
     if (limit) {
       qb.limit(limit)
     }
diff --git a/lib/router.js b/lib/router.js
index 806c6db..f1d9a48 100644
--- a/lib/router.js
+++ b/lib/router.js
@@ -122,6 +122,7 @@ module.exports = function(app){
     bucky.ensureMessages,
     function(req, res){
       res.json({
+        user: { id: req.user.get("id"), username: req.user.get("username") },
         messages: res.messages,
         boxes: res.boxes,
       })