#29882: UDFs are not dumped to the clone MySQL test db
-------------------------------------+-------------------------------------
Reporter: thomazzo | Owner: thomazzo
Type: Uncategorized | Status: assigned
Component: Database layer | Version: 2.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Dan Davis):
* cc: Dan Davis (added)
* has_patch: 1 => 0
* type: New feature => Uncategorized
Comment:
thomazzo,
Can you clarify your database OPTIONS settings?
Without any options to force clone/mirror, Django should not preserve the
DDL and data in the database. In the normal mode, Django is not cloning
the database using `mysqldump` - it is dropping and recreating the
database, and then running migrations.
I've created a git repository that verifies this occurs, but it is not a
patch, but an example.
The git repo is https://github.com/danizen/django-review-29882.
If you set it up with mysql 5.7 on ubuntu and create a "djangoreview" user
and "djangoreview" and "test_djangoreview" database to which that user has
all privileges, you should be able to run `./manage.py test` and verify
you get:
{{{
django.db.utils.OperationalError: (1305, 'FUNCTION test_djangoreview.HELLO
does not exist')
----------------------------------------------------------------------
Ran 2 tests in 0.026s
FAILED (errors=1)
Destroying test database for alias 'default'...
}}}
If you want, you could try to get this test to work in isolation by
writing a custom migration as follows:
{{{
./manage.py makemigrations app --empty -n add_hello_function
}}}
Then, edit the migration file created, and use the RunSQL migration
operation to run text from the file `sql/ddl/hello.sql`. This shows how
you can use the django migrations system to manage custom defined SQL.
There are add-on packages that do similar things, but I want to emphasize
that Django core contains the functionality to read SQL files.
If you are using Python 3, I recommend you pathlib to read a file to get
the text to run.
--
Ticket URL: <https://code.djangoproject.com/ticket/29882#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/066.3a66f5ac3d8a378ec2f8aa82807c4370%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
