-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thomas declared: > I've been teaching myself Django over the past couple of days. Thus > far, everything has been going smoothly, as I typically do a lot of > non-web based Python coding, so am familiar with the language. > However, Django's DB API is my first look into ORM and how it works. > > I understand the basics; how to create models and run a syncdb to > generate tables. I understand how to query, update/insert, etc. the > data by instantiating the class model and using the API methods > against it. All nice and well. > > Where I get lost fast is when I need to make changes to a table. For > example, say I want to change the name of a column from 'foo' to > 'bar'. I can run an ALTER TABLE in SQL and do this easily, but I > thought the idea of ORM was that you weren't supposed to be using SQL > directly. I.e. is there a way to change a column name (or a table > name, or a attribute type, etc.) from within ORM, i.e. from within the > model class; or do I have to run the SQL, then change the model to > 'match' that SQL, and then run a syncdb. > > I love the concept of being able to access data through objects, but > am just confused as what 'workflow' I should be following when doing > something like changing a column name. > > Sorry for the basic question. Google hasn't been much help when > getting into these details. I can sort of 'figure it out' by running > the SQL, matching the model class and going from there... but wasn't > sure if that was the best, or only way.
The ORM is an interface to generating the tables and executing data queries, but Django does not handle migration of DB schemas for you. One way to handle that is to run ALTER TABLE yourself. Another way to do it is to dump the data from your DB to a serialized format (like JSON), alter that dump using REGEXes, build a brand new DB (using syncdb), and then load the serialized data into it. The latter is typically how we do it for our projects. - -- Randy Barlow Software Developer The American Research Institute http://americanri.com 919.228.4971 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkqpYzkACgkQw3vjPfF7QfUHowCfeDLkBbAIkCpi++7l/KdNXZBJ bb8Anju+Y99nzjXr2zMXCmUu0AdDORxQ =sDyK -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
