Z-Archive » OnlineApps » OnlineApps Secured Mailbox

Table MailSentBoxRecipient is added. Added one column in MailInbox, MailSentBox, MailArchive, and MailTrashCan table. When i added MailSentBoxRecipient and delete the few columns in MailSentBox in that have recipient, got error come out. This error because MailInbox, MailSentBox, MailArchive, and MailTrashCan is implement using MailBoxTableObjectInterface. I think to make it consistent, i think we need to create MailInboxRecipient, MailArchiveRecipient, and MailTrashCanRecipient for others table.

The auto generated id no used already, change it to .NEXTVAL. In all the method that need to insert to the MailInbox and MailSentBox, i created the query "SELECT INBOX_MESSAGEID.NEXTVAL FROM dual". Using this to increase the messageId by 1 when insert a row in database. I created a method in BaseHibernateDaoImpl to simple my work, that method is use to create this query and return the messageId. By using this method, i can get the messageId.

Problem:
Now i havent commit and push my work to the mercurial, because i change many things in the project. If i push it, the test cases for ayu and frank will got many errors and need to fix.

Changed the database table design. I move 4 columns in Mailbox to the recipient table, the columns i moved is LastAction, LastActionDate, LastActionUserId, and status. If the columns did not move it will facing problem when the status, last action, last action date, last action user id changed. Others recipient have the same messageId also will changed, because all share the same column. After changed the table design, i edit the BaseHibernateDao, BaseHibernateDaoImpl and SecuredMailBox class.

Finish edited the SecuredMailBox, now doing simple testing on it to make sure it work. Now finish test sendMessage, readMessage, replyMessage, archiveMessage and restoreArchiveMessage. All this is work, after edited and fix the problems on it. All the function in BaseHibernateDaoImpl also tested. All problems in this class fixed.

I change the database design for MailInbox, MailSentBox, MailArchive, and MailTrashCan. I add one column name sendStatus for these tables. This status is use in sentbox. When the mail in sentbox want to archive or delete, it need to save the status to archived and deleted. The new column is to store the status. I also finish test all the method using simple test. But now facing one problem, the problem is when i archive a mail from inbox, and all the recipient belong to the mail is moved to MailArchive, then the recipients in inbox for that mail will be empty, but the data for the mail will still in the inbox. I try to do checking the recipient for that mail, if the mail has no recipients, then delete the data of the mail. But now the checking got problem. Still checking what the problem.

Finish edited and tested all the methods in securedMailBox class. The problem of delete the data of the mail when the mail dont have any recipients in the mailbox solved. Now editing the JUnit test cases.