On 08-Aug-07, at 10:13 PM, James Bennett wrote:
>> constructing the SQL. With Django, it is building the SQL for me. > > Your best bet is to thoroughly read the documentation on the ORM; once > your tables are created (it can create them for you, but you don't > have to let it do that -- instead you can have it print the SQL out to > a file for you to execute yourself), the ORM only ever does SELECT, > INSERT and UPDATE, and it's fairly obvious which ORM methods perform > which queries. in fact, even at the data level, you could, outside django do inserts, updates and deletes and allow the django user to use only selects that view the data. In which case the django user would have only readonly access to the database. So your choices are: 1. django user gets create, drop rights on tables and indexes. select, insert, update and delete. Alter table rights dont arise until some form of schema evolution makes it's way into trunk as django currently cannot manipulate individual columns in tables 2. do the db structure manually outside django and give django rights only over the data - select, insert, update, delete 3. do even data manipulation outside allow django user readonly rights. There are rigid frameworks around which mandate that *all* actions *must* be done through the framework, otherwise everything gets borked. Django is much more flexible here. So, for example, django doesnt do check contraints - but that doesnt mean that a django app cannot have check constraints. All it means that you have to set these up in the database manually and maybe write some stuff in the views to catch the db errors. (check constraints are a GSoc project, so maybe django will have them soon) -- regards kg http://lawgon.livejournal.com http://nrcfosshelpline.in/web/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
