#24104: SQLite schema should to look for internal type of field instead of class
instance when choosing a default for created fields
-------------------------------------+-------------------------------------
Reporter: coldmind | Owner: coldmind
Type: | Status: new
Cleanup/optimization |
Component: Database layer | Version: 1.7
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by coldmind):
Some conversation logs:
{{{
<MarkusH> Hey timograham
<MarkusH> What are the implications if we force people to have a
get_internal_type() returning "ManyToMany" for their fields thought they
are not m2m fields?
<MarkusH> /cc truecoldmind ---^
<truecoldmind> MarkusH, we do not force people. For now e.g. django-taggit
with its m2m-fields will not work as expected, because they do not inherit
ManyToManyField. So, if they want to do something custom, but with the
same behavior, they should have ability to do this. For now they does not
have this ability due to `isinstance` checks
<MarkusH> I get that
<MarkusH> The problem they run into on SQLite is the way Django creates
the new table and fills in the values for the new columns
<MarkusH> That is, the default value
<MarkusH> right?
<truecoldmind> MarkusH,
https://github.com/django/django/pull/3865#issuecomment-69796289
<collinanderson> I think isinstance(field, ManyToManyField) should be
"field.many_to_many"
<MarkusH> collinanderson: yes, but not on 1.7
<collinanderson> MarkusH: yes. true
<MarkusH> taggit runs into a problem on >=1.7.2
<truecoldmind> MarkusH, what problems with internal type checks ?
<truecoldmind> for 1.7
<MarkusH> I don't know where they are used internally in the ORM
<MarkusH> it probably affects the lookups
<timograham> the effective_default solution seems a bit closer to what we
had before, I think I'd favor that, at least for 1.7, unless there is some
problem with it
<truecoldmind> timograham, which solution ?
<truecoldmind> timograham, please take a look for
https://github.com/django/django/pull/3865#issuecomment-69796289
<truecoldmind> if it will not call `_remake_table`, it will not reach this
stuff with effective default, right?
<timograham> I didn't look into it. Markus said that fix makes the problem
go away -- are you saying it doesn't?
<truecoldmind> It will fix problem if we will don't fix check in
`add_field`. If field is m2mlike, it should call another method,
`create_table`, not `_remake_table`. So if I understand right it will work
incorrect at least for django-taggit
<truecoldmind> * `create_model`
<truecoldmind> but for example from taggit issue it should call
`_remake_table`, since `field.rel.through._meta.auto_created == False`
(i'm about this check
https://github.com/django/django/blob/cbbe6a6abba6510716e25b7ee9364274334ffcfe/django/db/backends/sqlite3/schema.py#L175)
<truecoldmind> Fix that MarkusH proposed will work for this concrete
issue, but None can be as effective default
<truecoldmind> but with that fix None will be skipped and not added to
mapping
<truecoldmind> so it is not correct
<MarkusH> truecoldmind: can you give me a test that shows the erroneous
behavior?
<truecoldmind> which behavior? where?
<MarkusH> the one you just described
<truecoldmind> if you look in source of effective_default
(https://github.com/django/django/blob/stable/1.7.x/django/db/backends/schema.py#L182)
you can see that None can be chosen as default, but with check you wrote
`if default is not None` it will skip this and will not add to mapping
<MarkusH> right
<MarkusH> but do we need the mapping?
<truecoldmind> you mean in case if default is None?
<MarkusH> ahh, got you: mapping[field.column] =
self.effective_default(field) should be enough?
<MarkusH> mapping[field.column] =
self.quote_value(self.effective_default(field))
<MarkusH> should be sufficient
<truecoldmind> well, not, because for ManyToMany it will choose None as
default, which is not correct
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/24104#comment:7>
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.854e430f3c0e36e522045bb2a8e505d2%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
