Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008631 | Openbravo ERP | 02. Master data management | public | 2009-04-18 12:40 | 2011-02-04 09:14 |
| Reporter | rentidee | ||||
| Assigned To | rmorley | ||||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 20 | OS Version | rPath Linux | |
| Product Version | 2.50alpha-r11 | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0008631: Hooks in DAL (prerequisit for multi master replication of offline databases) | ||||
| Description | There should be some type of hook possible for a module to change the behavior of let's say delete in SessionHandler. It should be possible that a module is adding some additional functionality to the default behavior of hibernate. I try to explain this: I need urgently additional functionality in case any record get's deleted in the database, in any table. In case of a delete the primary id should be written into an extra table. The table contains only the date of the deletion, the user who deleted the record, the table id and the id of the deleted record Why do I need this? I try to synchronize two databases. One of them is stored on a laptop which is primarly offline. In case an internet connection exists I sync all new and changed rows in the tables on the laptop with the office server using rest web services. That works fine for insert and update. But this does not work in case I deleted a record on the laptop. I need this information, so I can delete all the records on the office server It would be so easy. I iterate through all the records of my delete table on the laptops database and remove this columns on the office server using rest. Adding such a feature would enable openbravo to become multi master replicatable. Additionally I would like to add the same functionality for inserts and updates. In my deletion table I could also add changes and additions. It would increase performance during the sync process because it would not be necessary to query all the changes in every table the laptop and the office database posseses, but only the changes made since the last sync Ok. It is possible to add this features using triggers in the database tables, but from the point of architecture it would be nice to inject additional functionality like inversion of control (Spring) directly into the sessionhandler In a second step I would like to add an approval system. Again hooks are required so that a deletion of a record must be approved by an officer first before a deletion,addition or update can be performed on the office server by a laptop user (salesman) | ||||
| Steps To Reproduce | |||||
| Proposed Solution | Adding inversion of control to sessionHandler would be nice :-) | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-04-18 12:40 | rentidee | New Issue | |||
| 2009-04-18 12:40 | rentidee | Assigned To | => rafaroda | ||
| 2009-04-23 11:48 | rafaroda | Assigned To | rafaroda => pjuvara | ||
| 2011-02-04 09:14 | jpabloae | Assigned To | pjuvara => rmorley | ||
| There are no notes attached to this issue. |