migrations.txt 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851
  1. ==========
  2. Migrations
  3. ==========
  4. .. module:: django.db.migrations
  5. :synopsis: Schema migration support for Django models
  6. .. versionadded:: 1.7
  7. Migrations are Django's way of propagating changes you make to your models
  8. (adding a field, deleting a model, etc.) into your database schema. They're
  9. designed to be mostly automatic, but you'll need to know when to make
  10. migrations, when to run them, and the common problems you might run into.
  11. A Brief History
  12. ---------------
  13. Prior to version 1.7, Django only supported adding new models to the
  14. database; it was not possible to alter or remove existing models via the
  15. ``syncdb`` command (the predecessor to :djadmin:`migrate`).
  16. Third-party tools, most notably `South <http://south.aeracode.org>`_,
  17. provided support for these additional types of change, but it was considered
  18. important enough that support was brought into core Django.
  19. The Commands
  20. ------------
  21. There are several commands which you will use to interact with migrations
  22. and Django's handling of database schema:
  23. * :djadmin:`migrate`, which is responsible for applying migrations, as well as
  24. unapplying and listing their status.
  25. * :djadmin:`makemigrations`, which is responsible for creating new migrations
  26. based on the changes you have made to your models.
  27. * :djadmin:`sqlmigrate`, which displays the SQL statements for a migration.
  28. It's worth noting that migrations are created and run on a per-app basis.
  29. In particular, it's possible to have apps that *do not use migrations* (these
  30. are referred to as "unmigrated" apps) - these apps will instead mimic the
  31. legacy behavior of just adding new models.
  32. You should think of migrations as a version control system for your database
  33. schema. ``makemigrations`` is responsible for packaging up your model changes
  34. into individual migration files - analogous to commits - and ``migrate`` is
  35. responsible for applying those to your database.
  36. The migration files for each app live in a "migrations" directory inside
  37. of that app, and are designed to be committed to, and distributed as part
  38. of, its codebase. You should be making them once on your development machine
  39. and then running the same migrations on your colleagues' machines, your
  40. staging machines, and eventually your production machines.
  41. .. note::
  42. It is possible to override the name of the package which contains the
  43. migrations on a per-app basis by modifying the :setting:`MIGRATION_MODULES`
  44. setting.
  45. Migrations will run the same way on the same dataset and produce consistent
  46. results, meaning that what you see in development and staging is, under the
  47. same circumstances, exactly what will happen in production.
  48. Django will make migrations for any change to your models or fields - even
  49. options that don't affect the database - as the only way it can reconstruct
  50. a field correctly is to have all the changes in the history, and you might
  51. need those options in some data migrations later on (for example, if you've
  52. set custom validators).
  53. Backend Support
  54. ---------------
  55. Migrations are supported on all backends that Django ships with, as well
  56. as any third-party backends if they have programmed in support for schema
  57. alteration (done via the :doc:`SchemaEditor </ref/schema-editor>` class).
  58. However, some databases are more capable than others when it comes to
  59. schema migrations; some of the caveats are covered below.
  60. PostgreSQL
  61. ~~~~~~~~~~
  62. PostgreSQL is the most capable of all the databases here in terms of schema
  63. support; the only caveat is that adding columns with default values will
  64. cause a full rewrite of the table, for a time proportional to its size.
  65. For this reason, it's recommended you always create new columns with
  66. ``null=True``, as this way they will be added immediately.
  67. MySQL
  68. ~~~~~
  69. MySQL lacks support for transactions around schema alteration operations,
  70. meaning that if a migration fails to apply you will have to manually unpick
  71. the changes in order to try again (it's impossible to roll back to an
  72. earlier point).
  73. In addition, MySQL will fully rewrite tables for almost every schema operation
  74. and generally takes a time proportional to the number of rows in the table to
  75. add or remove columns. On slower hardware this can be worse than a minute per
  76. million rows - adding a few columns to a table with just a few million rows
  77. could lock your site up for over ten minutes.
  78. Finally, MySQL has reasonably small limits on name lengths for columns, tables
  79. and indexes, as well as a limit on the combined size of all columns an index
  80. covers. This means that indexes that are possible on other backends will
  81. fail to be created under MySQL.
  82. SQLite
  83. ~~~~~~
  84. SQLite has very little built-in schema alteration support, and so Django
  85. attempts to emulate it by:
  86. * Creating a new table with the new schema
  87. * Copying the data across
  88. * Dropping the old table
  89. * Renaming the new table to match the original name
  90. This process generally works well, but it can be slow and occasionally
  91. buggy. It is not recommended that you run and migrate SQLite in a
  92. production environment unless you are very aware of the risks and
  93. its limitations; the support Django ships with is designed to allow
  94. developers to use SQLite on their local machines to develop less complex
  95. Django projects without the need for a full database.
  96. Workflow
  97. --------
  98. Working with migrations is simple. Make changes to your models - say, add
  99. a field and remove a model - and then run :djadmin:`makemigrations`::
  100. $ python manage.py makemigrations
  101. Migrations for 'books':
  102. 0003_auto.py:
  103. - Alter field author on book
  104. Your models will be scanned and compared to the versions currently
  105. contained in your migration files, and then a new set of migrations
  106. will be written out. Make sure to read the output to see what
  107. ``makemigrations`` thinks you have changed - it's not perfect, and for
  108. complex changes it might not be detecting what you expect.
  109. Once you have your new migration files, you should apply them to your
  110. database to make sure they work as expected::
  111. $ python manage.py migrate
  112. Operations to perform:
  113. Synchronize unmigrated apps: sessions, admin, messages, auth, staticfiles, contenttypes
  114. Apply all migrations: books
  115. Synchronizing apps without migrations:
  116. Creating tables...
  117. Installing custom SQL...
  118. Installing indexes...
  119. Installed 0 object(s) from 0 fixture(s)
  120. Running migrations:
  121. Applying books.0003_auto... OK
  122. The command runs in two stages; first, it synchronizes unmigrated apps
  123. (performing the same functionality that ``syncdb`` used to provide), and
  124. then it runs any migrations that have not yet been applied.
  125. Once the migration is applied, commit the migration and the models change
  126. to your version control system as a single commit - that way, when other
  127. developers (or your production servers) check out the code, they'll
  128. get both the changes to your models and the accompanying migration at the
  129. same time.
  130. Version control
  131. ~~~~~~~~~~~~~~~
  132. Because migrations are stored in version control, you'll occasionally
  133. come across situations where you and another developer have both committed
  134. a migration to the same app at the same time, resulting in two migrations
  135. with the same number.
  136. Don't worry - the numbers are just there for developers' reference, Django
  137. just cares that each migration has a different name. Migrations specify which
  138. other migrations they depend on - including earlier migrations in the same
  139. app - in the file, so it's possible to detect when there's two new migrations
  140. for the same app that aren't ordered.
  141. When this happens, Django will prompt you and give you some options. If it
  142. thinks it's safe enough, it will offer to automatically linearize the two
  143. migrations for you. If not, you'll have to go in and modify the migrations
  144. yourself - don't worry, this isn't difficult, and is explained more in
  145. :ref:`migration-files` below.
  146. Dependencies
  147. ------------
  148. While migrations are per-app, the tables and relationships implied by
  149. your models are too complex to be created for just one app at a time. When
  150. you make a migration that requires something else to run - for example,
  151. you add a ``ForeignKey`` in your ``books`` app to your ``authors`` app - the
  152. resulting migration will contain a dependency on a migration in ``authors``.
  153. This means that when you run the migrations, the ``authors`` migration runs
  154. first and creates the table the ``ForeignKey`` references, and then the migration
  155. that makes the ``ForeignKey`` column runs afterwards and creates the constraint.
  156. If this didn't happen, the migration would try to create the ``ForeignKey``
  157. column without the table it's referencing existing and your database would
  158. throw an error.
  159. This dependency behavior affects most migration operations where you
  160. restrict to a single app. Restricting to a single app (either in
  161. ``makemigrations`` or ``migrate``) is a best-efforts promise, and not
  162. a guarantee; any other apps that need to be used to get dependencies correct
  163. will be.
  164. .. _unmigrated-dependencies:
  165. Be aware, however, that unmigrated apps cannot depend on migrated apps, by the
  166. very nature of not having migrations. This means that it is not generally
  167. possible to have an unmigrated app have a ``ForeignKey`` or ``ManyToManyField``
  168. to a migrated app; some cases may work, but it will eventually fail.
  169. .. warning::
  170. Even if things appear to work with unmigrated apps depending on migrated
  171. apps, Django may not generate all the necessary foreign key constraints!
  172. This is particularly apparent if you use swappable models (e.g.
  173. ``AUTH_USER_MODEL``), as every app that uses swappable models will need
  174. to have migrations if you're unlucky. As time goes on, more and more
  175. third-party apps will get migrations, but in the meantime you can either
  176. give them migrations yourself (using :setting:`MIGRATION_MODULES` to
  177. store those modules outside of the app's own module if you wish), or
  178. keep the app with your user model unmigrated.
  179. .. _migration-files:
  180. Migration files
  181. ---------------
  182. Migrations are stored as an on-disk format, referred to here as
  183. "migration files". These files are actually just normal Python files with
  184. an agreed-upon object layout, written in a declarative style.
  185. A basic migration file looks like this::
  186. from django.db import migrations, models
  187. class Migration(migrations.Migration):
  188. dependencies = [("migrations", "0001_initial")]
  189. operations = [
  190. migrations.DeleteModel("Tribble"),
  191. migrations.AddField("Author", "rating", models.IntegerField(default=0)),
  192. ]
  193. What Django looks for when it loads a migration file (as a Python module) is
  194. a subclass of ``django.db.migrations.Migration`` called ``Migration``. It then
  195. inspects this object for four attributes, only two of which are used
  196. most of the time:
  197. * ``dependencies``, a list of migrations this one depends on.
  198. * ``operations``, a list of ``Operation`` classes that define what this
  199. migration does.
  200. The operations are the key; they are a set of declarative instructions which
  201. tell Django what schema changes need to be made. Django scans them and
  202. builds an in-memory representation of all of the schema changes to all apps,
  203. and uses this to generate the SQL which makes the schema changes.
  204. That in-memory structure is also used to work out what the differences are
  205. between your models and the current state of your migrations; Django runs
  206. through all the changes, in order, on an in-memory set of models to come
  207. up with the state of your models last time you ran ``makemigrations``. It
  208. then uses these models to compare against the ones in your ``models.py`` files
  209. to work out what you have changed.
  210. You should rarely, if ever, need to edit migration files by hand, but
  211. it's entirely possible to write them manually if you need to. Some of the
  212. more complex operations are not autodetectable and are only available via
  213. a hand-written migration, so don't be scared about editing them if you have to.
  214. Custom fields
  215. ~~~~~~~~~~~~~
  216. You can't modify the number of positional arguments in an already migrated
  217. custom field without raising a ``TypeError``. The old migration will call the
  218. modified ``__init__`` method with the old signature. So if you need a new
  219. argument, please create a keyword argument and add something like
  220. ``assert kwargs.get('argument_name') is not None`` in the constructor.
  221. .. _using-managers-in-migrations:
  222. Model managers
  223. ~~~~~~~~~~~~~~
  224. .. versionadded:: 1.8
  225. You can optionally serialize managers into migrations and have them available
  226. in :class:`~django.db.migrations.operations.RunPython` operations. This is done
  227. by defining a ``use_in_migrations`` attribute on the manager class::
  228. class MyManager(models.Manager):
  229. use_in_migrations = True
  230. class MyModel(models.Model):
  231. objects = MyManager()
  232. If you are using the :meth:`~django.db.models.from_queryset` function to
  233. dynamically generate a manager class, you need to inherit from the generated
  234. class to make it importable::
  235. class MyManager(MyBaseManager.from_queryset(CustomQuerySet)):
  236. use_in_migrations = True
  237. class MyModel(models.Model):
  238. objects = MyManager()
  239. Please refer to the notes about :ref:`historical-models` in migrations to see
  240. the implications that come along.
  241. Adding migrations to apps
  242. -------------------------
  243. Adding migrations to new apps is straightforward - they come preconfigured to
  244. accept migrations, and so just run :djadmin:`makemigrations` once you've made
  245. some changes.
  246. If your app already has models and database tables, and doesn't have migrations
  247. yet (for example, you created it against a previous Django version), you'll
  248. need to convert it to use migrations; this is a simple process::
  249. $ python manage.py makemigrations your_app_label
  250. This will make a new initial migration for your app. Now, when you run
  251. :djadmin:`migrate`, Django will detect that you have an initial migration
  252. *and* that the tables it wants to create already exist, and will mark the
  253. migration as already applied.
  254. Note that this only works given two things:
  255. * You have not changed your models since you made their tables. For migrations
  256. to work, you must make the initial migration *first* and then make changes,
  257. as Django compares changes against migration files, not the database.
  258. * You have not manually edited your database - Django won't be able to detect
  259. that your database doesn't match your models, you'll just get errors when
  260. migrations try to modify those tables.
  261. .. versionadded:: 1.8
  262. If you want to give the migration(s) a meaningful name instead of a generated one,
  263. you can use the :djadminopt:`--name` option::
  264. $ python manage.py makemigrations --name changed_my_model your_app_label
  265. .. _historical-models:
  266. Historical models
  267. -----------------
  268. When you run migrations, Django is working from historical versions of your
  269. models stored in the migration files. If you write Python code using the
  270. :class:`~django.db.migrations.operations.RunPython` operation, or if you have
  271. ``allow_migrate`` methods on your database routers, you will be exposed to
  272. these versions of your models.
  273. Because it's impossible to serialize arbitrary Python code, these historical
  274. models will not have any custom methods that you have defined. They will,
  275. however, have the same fields, relationships, managers (limited to those with
  276. ``use_in_migrations = True``) and ``Meta`` options (also versioned, so they may
  277. be different from your current ones).
  278. .. warning::
  279. This means that you will NOT have custom ``save()`` methods called on objects
  280. when you access them in migrations, and you will NOT have any custom
  281. constructors or instance methods. Plan appropriately!
  282. References to functions in field options such as ``upload_to`` and
  283. ``limit_choices_to`` and model manager declarations with managers having
  284. ``use_in_migrations = True`` are serialized in migrations, so the functions and
  285. classes will need to be kept around for as long as there is a migration
  286. referencing them. Any :doc:`custom model fields </howto/custom-model-fields>`
  287. will also need to be kept, since these are imported directly by migrations.
  288. In addition, the base classes of the model are just stored as pointers, so you
  289. must always keep base classes around for as long as there is a migration that
  290. contains a reference to them. On the plus side, methods and managers from these
  291. base classes inherit normally, so if you absolutely need access to these you
  292. can opt to move them into a superclass.
  293. .. _migrations-removing-model-fields:
  294. Considerations when removing model fields
  295. -----------------------------------------
  296. .. versionadded:: 1.8
  297. Similar to the "references to historical functions" considerations described in
  298. the previous section, removing custom model fields from your project or
  299. third-party app will cause a problem if they are referenced in old migrations.
  300. To help with this situation, Django provides some model field attributes to
  301. assist with model field deprecation using the :doc:`system checks framework
  302. </topics/checks>`.
  303. Add the ``system_check_deprecated_details`` attribute to your model field
  304. similar to the following::
  305. class IPAddressField(Field):
  306. system_check_deprecated_details = {
  307. 'msg': (
  308. 'IPAddressField has been deprecated. Support for it (except '
  309. 'in historical migrations) will be removed in Django 1.9.'
  310. ),
  311. 'hint': 'Use GenericIPAddressField instead.', # optional
  312. 'id': 'fields.W900', # pick a unique ID for your field.
  313. }
  314. After a deprecation period of your choosing (two major releases for fields in
  315. Django itself), change the ``system_check_deprecated_details`` attribute to
  316. ``system_check_removed_details`` and update the dictionary similar to::
  317. class IPAddressField(Field):
  318. system_check_removed_details = {
  319. 'msg': (
  320. 'IPAddressField has been removed except for support in '
  321. 'historical migrations.'
  322. ),
  323. 'hint': 'Use GenericIPAddressField instead.',
  324. 'id': 'fields.E900', # pick a unique ID for your field.
  325. }
  326. You should keep the field's methods that are required for it to operate in
  327. database migrations such as ``__init__()``, ``deconstruct()``, and
  328. ``get_internal_type()``. Keep this stub field for as long as any migrations
  329. which reference the field exist. For example, after squashing migrations and
  330. removing the old ones, you should be able to remove the field completely.
  331. .. _data-migrations:
  332. Data Migrations
  333. ---------------
  334. As well as changing the database schema, you can also use migrations to change
  335. the data in the database itself, in conjunction with the schema if you want.
  336. Migrations that alter data are usually called "data migrations"; they're best
  337. written as separate migrations, sitting alongside your schema migrations.
  338. Django can't automatically generate data migrations for you, as it does with
  339. schema migrations, but it's not very hard to write them. Migration files in
  340. Django are made up of :doc:`Operations </ref/migration-operations>`, and
  341. the main operation you use for data migrations is
  342. :class:`~django.db.migrations.operations.RunPython`.
  343. To start, make an empty migration file you can work from (Django will put
  344. the file in the right place, suggest a name, and add dependencies for you)::
  345. python manage.py makemigrations --empty yourappname
  346. Then, open up the file; it should look something like this::
  347. # -*- coding: utf-8 -*-
  348. from django.db import models, migrations
  349. class Migration(migrations.Migration):
  350. dependencies = [
  351. ('yourappname', '0001_initial'),
  352. ]
  353. operations = [
  354. ]
  355. Now, all you need to do is create a new function and have
  356. :class:`~django.db.migrations.operations.RunPython` use it.
  357. :class:`~django.db.migrations.operations.RunPython` expects a callable as its argument
  358. which takes two arguments - the first is an :doc:`app registry
  359. </ref/applications/>` that has the historical versions of all your models
  360. loaded into it to match where in your history the migration sits, and the
  361. second is a :doc:`SchemaEditor </ref/schema-editor>`, which you can use to
  362. manually effect database schema changes (but beware, doing this can confuse
  363. the migration autodetector!)
  364. Let's write a simple migration that populates our new ``name`` field with the
  365. combined values of ``first_name`` and ``last_name`` (we've come to our senses
  366. and realized that not everyone has first and last names). All we
  367. need to do is use the historical model and iterate over the rows::
  368. # -*- coding: utf-8 -*-
  369. from django.db import models, migrations
  370. def combine_names(apps, schema_editor):
  371. # We can't import the Person model directly as it may be a newer
  372. # version than this migration expects. We use the historical version.
  373. Person = apps.get_model("yourappname", "Person")
  374. for person in Person.objects.all():
  375. person.name = "%s %s" % (person.first_name, person.last_name)
  376. person.save()
  377. class Migration(migrations.Migration):
  378. dependencies = [
  379. ('yourappname', '0001_initial'),
  380. ]
  381. operations = [
  382. migrations.RunPython(combine_names),
  383. ]
  384. Once that's done, we can just run ``python manage.py migrate`` as normal and
  385. the data migration will run in place alongside other migrations.
  386. You can pass a second callable to
  387. :class:`~django.db.migrations.operations.RunPython` to run whatever logic you
  388. want executed when migrating backwards. If this callable is omitted, migrating
  389. backwards will raise an exception.
  390. .. _data-migrations-and-multiple-databases:
  391. Data migrations and multiple databases
  392. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  393. When using multiple databases, you may need to figure out whether or not to
  394. run a migration against a particular database. For example, you may want to
  395. **only** run a migration on a particular database.
  396. In order to do that you can check the database connection's alias inside a
  397. ``RunPython`` operation by looking at the ``schema_editor.connection.alias``
  398. attribute::
  399. from django.db import migrations
  400. def forwards(apps, schema_editor):
  401. if not schema_editor.connection.alias == 'default':
  402. return
  403. # Your migration code goes here
  404. class Migration(migrations.Migration):
  405. dependencies = [
  406. # Dependencies to other migrations
  407. ]
  408. operations = [
  409. migrations.RunPython(forwards),
  410. ]
  411. .. versionadded:: 1.8
  412. You can also provide hints that will be passed to the :meth:`allow_migrate()`
  413. method of database routers as ``**hints``:
  414. .. snippet::
  415. :filename: myapp/dbrouters.py
  416. class MyRouter(object):
  417. def allow_migrate(self, db, model, **hints):
  418. if 'target_db' in hints:
  419. return db == hints['target_db']
  420. return True
  421. Then, to leverage this in your migrations, do the following::
  422. from django.db import migrations
  423. def forwards(apps, schema_editor):
  424. # Your migration code goes here
  425. class Migration(migrations.Migration):
  426. dependencies = [
  427. # Dependencies to other migrations
  428. ]
  429. operations = [
  430. migrations.RunPython(forwards, hints={'target_db': 'default'}),
  431. ]
  432. More advanced migrations
  433. ~~~~~~~~~~~~~~~~~~~~~~~~
  434. If you're interested in the more advanced migration operations, or want
  435. to be able to write your own, see the :doc:`migration operations reference
  436. </ref/migration-operations>`.
  437. .. _migration-squashing:
  438. Squashing migrations
  439. --------------------
  440. You are encouraged to make migrations freely and not worry about how many you
  441. have; the migration code is optimized to deal with hundreds at a time without
  442. much slowdown. However, eventually you will want to move back from having
  443. several hundred migrations to just a few, and that's where squashing comes in.
  444. Squashing is the act of reducing an existing set of many migrations down to
  445. one (or sometimes a few) migrations which still represent the same changes.
  446. Django does this by taking all of your existing migrations, extracting their
  447. ``Operation``\s and putting them all in sequence, and then running an optimizer
  448. over them to try and reduce the length of the list - for example, it knows
  449. that :class:`~django.db.migrations.operations.CreateModel` and
  450. :class:`~django.db.migrations.operations.DeleteModel` cancel each other out,
  451. and it knows that :class:`~django.db.migrations.operations.AddField` can be
  452. rolled into :class:`~django.db.migrations.operations.CreateModel`.
  453. Once the operation sequence has been reduced as much as possible - the amount
  454. possible depends on how closely intertwined your models are and if you have
  455. any :class:`~django.db.migrations.operations.RunSQL`
  456. or :class:`~django.db.migrations.operations.RunPython` operations (which can't
  457. be optimized through) - Django will then write it back out into a new set of
  458. initial migration files.
  459. These files are marked to say they replace the previously-squashed migrations,
  460. so they can coexist with the old migration files, and Django will intelligently
  461. switch between them depending where you are in the history. If you're still
  462. part-way through the set of migrations that you squashed, it will keep using
  463. them until it hits the end and then switch to the squashed history, while new
  464. installs will just use the new squashed migration and skip all the old ones.
  465. This enables you to squash and not mess up systems currently in production
  466. that aren't fully up-to-date yet. The recommended process is to squash, keeping
  467. the old files, commit and release, wait until all systems are upgraded with
  468. the new release (or if you're a third-party project, just ensure your users
  469. upgrade releases in order without skipping any), and then remove the old files,
  470. commit and do a second release.
  471. The command that backs all this is :djadmin:`squashmigrations` - just pass
  472. it the app label and migration name you want to squash up to, and it'll get to
  473. work::
  474. $ ./manage.py squashmigrations myapp 0004
  475. Will squash the following migrations:
  476. - 0001_initial
  477. - 0002_some_change
  478. - 0003_another_change
  479. - 0004_undo_something
  480. Do you wish to proceed? [yN] y
  481. Optimizing...
  482. Optimized from 12 operations to 7 operations.
  483. Created new squashed migration /home/andrew/Programs/DjangoTest/test/migrations/0001_squashed_0004_undo_somthing.py
  484. You should commit this migration but leave the old ones in place;
  485. the new migration will be used for new installs. Once you are sure
  486. all instances of the codebase have applied the migrations you squashed,
  487. you can delete them.
  488. Note that model interdependencies in Django can get very complex, and squashing
  489. may result in migrations that do not run; either mis-optimized (in which case
  490. you can try again with ``--no-optimize``, though you should also report an issue),
  491. or with a ``CircularDependencyError``, in which case you can manually resolve it.
  492. To manually resolve a ``CircularDependencyError``, break out one of
  493. the ForeignKeys in the circular dependency loop into a separate
  494. migration, and move the dependency on the other app with it. If you're unsure,
  495. see how makemigrations deals with the problem when asked to create brand
  496. new migrations from your models. In a future release of Django, squashmigrations
  497. will be updated to attempt to resolve these errors itself.
  498. Once you've squashed your migration, you should then commit it alongside the
  499. migrations it replaces and distribute this change to all running instances
  500. of your application, making sure that they run ``migrate`` to store the change
  501. in their database.
  502. After this has been done, you must then transition the squashed migration to
  503. a normal initial migration, by:
  504. - Deleting all the migration files it replaces
  505. - Removing the ``replaces`` argument in the ``Migration`` class of the
  506. squashed migration (this is how Django tells that it is a squashed migration)
  507. .. note::
  508. Once you've squashed a migration, you should not then re-squash that squashed
  509. migration until you have fully transitioned it to a normal migration.
  510. .. _migration-serializing:
  511. Serializing values
  512. ------------------
  513. Migrations are just Python files containing the old definitions of your models
  514. - thus, to write them, Django must take the current state of your models and
  515. serialize them out into a file.
  516. While Django can serialize most things, there are some things that we just
  517. can't serialize out into a valid Python representation - there's no Python
  518. standard for how a value can be turned back into code (``repr()`` only works
  519. for basic values, and doesn't specify import paths).
  520. Django can serialize the following:
  521. - ``int``, ``long``, ``float``, ``bool``, ``str``, ``unicode``, ``bytes``, ``None``
  522. - ``list``, ``set``, ``tuple``, ``dict``
  523. - ``datetime.date``, ``datetime.time``, and ``datetime.datetime`` instances
  524. (include those that are timezone-aware)
  525. - ``decimal.Decimal`` instances
  526. - Any Django field
  527. - Any function or method reference (e.g. ``datetime.datetime.today``) (must be in module's top-level scope)
  528. - Any class reference (must be in module's top-level scope)
  529. - Anything with a custom ``deconstruct()`` method (:ref:`see below <custom-deconstruct-method>`)
  530. .. versionchanged:: 1.7.1
  531. Support for serializing timezone-aware datetimes was added.
  532. Django can serialize the following on Python 3 only:
  533. - Unbound methods used from within the class body (see below)
  534. Django cannot serialize:
  535. - Nested classes
  536. - Arbitrary class instances (e.g. ``MyClass(4.3, 5.7)``)
  537. - Lambdas
  538. Due to the fact ``__qualname__`` was only introduced in Python 3, Django can only
  539. serialize the following pattern (an unbound method used within the class body)
  540. on Python 3, and will fail to serialize a reference to it on Python 2::
  541. class MyModel(models.Model):
  542. def upload_to(self):
  543. return "something dynamic"
  544. my_file = models.FileField(upload_to=upload_to)
  545. If you are using Python 2, we recommend you move your methods for upload_to
  546. and similar arguments that accept callables (e.g. ``default``) to live in
  547. the main module body, rather than the class body.
  548. .. _custom-deconstruct-method:
  549. Adding a deconstruct() method
  550. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  551. You can let Django serialize your own custom class instances by giving the class
  552. a ``deconstruct()`` method. It takes no arguments, and should return a tuple
  553. of three things ``(path, args, kwargs)``:
  554. * ``path`` should be the Python path to the class, with the class name included
  555. as the last part (for example, ``myapp.custom_things.MyClass``). If your
  556. class is not available at the top level of a module it is not serializable.
  557. * ``args`` should be a list of positional arguments to pass to your class'
  558. ``__init__`` method. Everything in this list should itself be serializable.
  559. * ``kwargs`` should be a dict of keyword arguments to pass to your class'
  560. ``__init__`` method. Every value should itself be serializable.
  561. .. note::
  562. This return value is different from the ``deconstruct()`` method
  563. :ref:`for custom fields <custom-field-deconstruct-method>` which returns a
  564. tuple of four items.
  565. Django will write out the value as an instantiation of your class with the
  566. given arguments, similar to the way it writes out references to Django fields.
  567. To prevent a new migration from being created each time
  568. :djadmin:`makemigrations` is run, you should also add a ``__eq__()`` method to
  569. the decorated class. This function will be called by Django's migration
  570. framework to detect changes between states.
  571. As long as all of the arguments to your class' constructor are themselves
  572. serializable, you can use the ``@deconstructible`` class decorator from
  573. ``django.utils.deconstruct`` to add the ``deconstruct()`` method::
  574. from django.utils.deconstruct import deconstructible
  575. @deconstructible
  576. class MyCustomClass(object):
  577. def __init__(self, foo=1):
  578. self.foo = foo
  579. ...
  580. def __eq__(self, other):
  581. return self.foo == other.foo
  582. The decorator adds logic to capture and preserve the arguments on their
  583. way into your constructor, and then returns those arguments exactly when
  584. deconstruct() is called.
  585. Supporting Python 2 and 3
  586. -------------------------
  587. In order to generate migrations that support both Python 2 and 3, all string
  588. literals used in your models and fields (e.g. ``verbose_name``,
  589. ``related_name``, etc.), must be consistently either bytestrings or text
  590. (unicode) strings in both Python 2 and 3 (rather than bytes in Python 2 and
  591. text in Python 3, the default situation for unmarked string literals.)
  592. Otherwise running :djadmin:`makemigrations` under Python 3 will generate
  593. spurious new migrations to convert all these string attributes to text.
  594. The easiest way to achieve this is to follow the advice in Django's
  595. :doc:`Python 3 porting guide </topics/python3>` and make sure that all your
  596. modules begin with ``from __future__ import unicode_literals``, so that all
  597. unmarked string literals are always unicode, regardless of Python version. When
  598. you add this to an app with existing migrations generated on Python 2, your
  599. next run of :djadmin:`makemigrations` on Python 3 will likely generate many
  600. changes as it converts all the bytestring attributes to text strings; this is
  601. normal and should only happen once.
  602. .. _upgrading-from-south:
  603. Upgrading from South
  604. --------------------
  605. If you already have pre-existing migrations created with
  606. `South <http://south.aeracode.org>`_, then the upgrade process to use
  607. ``django.db.migrations`` is quite simple:
  608. * Ensure all installs are fully up-to-date with their migrations.
  609. * Remove ``'south'`` from :setting:`INSTALLED_APPS`.
  610. * Delete all your (numbered) migration files, but not the directory or
  611. ``__init__.py`` - make sure you remove the ``.pyc`` files too.
  612. * Run ``python manage.py makemigrations``. Django should see the empty
  613. migration directories and make new initial migrations in the new format.
  614. * Run ``python manage.py migrate``. Django will see that the tables for the
  615. initial migrations already exist and mark them as applied without running
  616. them.
  617. That's it! The only complication is if you have a circular dependency loop
  618. of foreign keys; in this case, ``makemigrations`` might make more than one
  619. initial migration, and you'll need to mark them all as applied using::
  620. python manage.py migrate --fake yourappnamehere
  621. Libraries/Third-party Apps
  622. ~~~~~~~~~~~~~~~~~~~~~~~~~~
  623. If you are a library or app maintainer, and wish to support both South migrations
  624. (for Django 1.6 and below) and Django migrations (for 1.7 and above) you should
  625. keep two parallel migration sets in your app, one in each format.
  626. To aid in this, South 1.0 will automatically look for South-format migrations
  627. in a ``south_migrations`` directory first, before looking in ``migrations``,
  628. meaning that users' projects will transparently use the correct set as long
  629. as you put your South migrations in the ``south_migrations`` directory and
  630. your Django migrations in the ``migrations`` directory.
  631. More information is available in the
  632. `South 1.0 release notes <http://south.readthedocs.org/en/latest/releasenotes/1.0.html#library-migration-path>`_.
  633. .. seealso::
  634. :doc:`The Migrations Operations Reference </ref/migration-operations>`
  635. Covers the schema operations API, special operations, and writing your
  636. own operations.