Hello: I have a web2py application in production, and lately I've been asked to add too many features that already exist in erp systems like odoo (known before as openerp). So I'm considering the alternatives: - Forget odoo, write everything I need from scratch in web2py - Forget my app, rewrite it from scratch in odoo - Have them share some tables on the database. The two apps would run alongside, at the beggining with very little interaction, and they would start to offer different views, then different controllers, for interacting with the same tables. Then some key parts would be rewritten over time, trying to move to a better architecture, taking only small steps.
web2py seems capable, according to the manual, to use already existing tables, and odoo uses an autoincrement integer field called 'id'. So it looks possible, even simple, but to my limited experience this seems a bit hazy. As odoo uses ORM, it seems to me that it is web2py that should adapt to the tables created by odoo, and not viceversa. Also, I'm more experienced in web2py than odoo. Any advice would be appreciated. For example: - Is there an open source web2py application that uses legacy tables, so that I can read its code? - The manual says: "Records must be referenced exclusively using the "id" field", but what does that mean exactly? What I understand is: "odoo can do whatever it wants with the tables, in your web2py app you can build a set using any field, and then select, update or delete the set, but you can only join tables using the id field". Is that even close? - How would you handle the login step, so that users log only once? - There might be other alternatives to sharing the database. I could use the odoo web service? Is that more recommendable? Regards -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
