Re: Need some advice in new project
I am not sure why you would want "all companies bank accounts in different tables." Is it for security? to ensure that only appropriate people are able to view the records of any given company? There is the row-level-permissions branch, but I do not believe it has been maintained in a while so I rolled my own by implementing a very simple row-level access based on the 'organization' that a user belongs to. You may want to consider something like this. -r On Jul 28, 1:47 pm, anna <[EMAIL PROTECTED]> wrote: > Hello my friends. > > I need your help in designing our new based application. > The goal is to build a kind of backoffice system, which helps to > organize all data of a specific company. > No problem with it. Build your models, data structures, input and > output 'screens'. > > But... > this application goes to a 'proxy' company, who's job is organize > other companies data. (Assume its an accounting firm, for example) > All models etc. are the same in each, but we expressly don't want to > store same data in same table (i mean all companies bank accounts are > in different tables) > We have to create new 'database' dynamically from a web based > interface seamlessly. > Did you solve similar problem already? > Prefixing tables, different databases or what? > > Thank you for any advice. > > Anna --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: Need some advice in new project
Hi, > [...] > All models etc. are the same in each, but we expressly don't want to > store same data in same table (i mean all companies bank accounts are > in different tables) > We have to create new 'database' dynamically from a web based > interface seamlessly. > Did you solve similar problem already? > Prefixing tables, different databases or what? You should not have to care about this, it's the "proxy" company's DBA business. It depends on what database vendor they use, how they deal with security, backups, replications, DBA's mood, what kind of data are stored, etc. As regards creating databases, schemas, users, tablespaces, etc..., you can do it in python with the DB-API modules for the relevant vendor and put a web interface in front of it. >From the Django side, beware of the fact that the database support has limitations (no MSQL, no Oracle, no schema on Postgres). Olivier --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: Need some advice in new project
Hi Anna, On 7/28/07, anna <[EMAIL PROTECTED]> wrote: > > Hello my friends. > > I need your help in designing our new based application. > The goal is to build a kind of backoffice system, which helps to > organize all data of a specific company. > No problem with it. Build your models, data structures, input and > output 'screens'. > > But... > this application goes to a 'proxy' company, who's job is organize > other companies data. (Assume its an accounting firm, for example) > All models etc. are the same in each, but we expressly don't want to > store same data in same table (i mean all companies bank accounts are > in different tables) > We have to create new 'database' dynamically from a web based > interface seamlessly. > Did you solve similar problem already? > Prefixing tables, different databases or what? > > Thank you for any advice. So you want to change setting values when the application is running? Sorry, if I didn't understand your problem right. If I understood correct, this could help you: http://code.google.com/p/django-values/ Not sure if it's already usable. > Anna Kai --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---