Paul J Stevens wrote: > Grrr. We do have a bug. I can confirm I had this happen to me on a > postgres installation. I didn't remember Ralf's report (no bug was filed > on the tracker at the time. Is now, though). Do you run postgresql? No, I'm running mysql-5.0.32 (debian/etch).
> There's some rudimentary python classes in python. But what do you mean > by 'sorted'? Do you want to move messages into folders en masse? Based > on arrival date? Please elaborate a bit if you can. > Rudimentary dbmail classes for python? Are they online somewhere? Yes, I mean to move messages into folders en masse. For instance, say I want to keep folders Inbox, Archive, TwoYearsOld, ThreeYearsOld, etc. I want to run a daily cron job that does the following, based on the mail's date header: * Move all unflagged messages older than 30 days from Inbox to Archive * Move all messages older than 365 days from Archive to TwoYearsOld * Move all messages older than 730 days from TwoYearsOld to ThreeYearsOld * . . . (creating folders as needed along the way) That's just one example. But the abstract idea is the same... I'm looking for scripting tools to select X messages and do Y to them (move, delete, flag, unflag, etc). Perhaps some simple things can be done in raw SQL. Regarding vfolders... > But you would also require some middleware for managing those views. [...] If > not, we'd have to > design our own imap extension 'VFOLDER'. > That would be ideal, I suppose... but I would settle for server-side management. Some command-line tool, or even raw SQL script, could configure a virtual folder that an IMAP client would see as any other folder. E.g., create a mailbox and populate it with the results of an arbitrary SQL query. Maybe allow for a sieve-style configuration file to define vfolders for a given user. IMAP doesn't have to know a thing, does it? ;-) Thanks for your help. -C- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
