RFE: exmdb usage stats for folders

[crpb]

Just something for the future..

It would be nice to get those via api/cli aswell

• mailcount/folder
• size/folder

like in the counterpart

[crpb]

something like this

-- FOLDER LOOKUP VIEW VIA FOLDERS INCLUDING PARENT
DROP VIEW IF EXISTS temp.folderlist;
CREATE VIEW IF NOT EXISTS temp.folderlist
AS SELECT distinct(p.folder_id),
          p.parent_id,
          f1.propval AS foldername
     FROM folders p
     JOIN folder_properties f1
       ON f1.folder_id = p.folder_id
      AND f1.proptag = 805371935
    ORDER BY p.folder_id
;

-- MSGs/FOLDERSIZES
DROP VIEW IF EXISTS temp.messagecount;
CREATE VIEW IF NOT EXISTS temp.messagecount AS
SELECT fl.folder_id AS id,
       fl.foldername AS folder,
       SUM(m.message_size) as foldersize,
       count(m.message_id) AS count
  FROM folderlist fl
  LEFT JOIN messages m
    ON fl.folder_id = m.parent_fid
   AND m.is_deleted = 0
 WHERE fl.parent_id > 1
 GROUP BY fl.folder_id,
          fl.foldername
;

SELECT * FROM messagecount;

i already use those and other things, but would be gread to have a couple of VIEWS in the database by default 🙈