|Version 22 (modified by adrian, 10 years ago) (diff)|
Fields as descriptors
This proposal changes the Django database API substantially.
|Lookup type||Old syntax||New syntax|
|Foreign key field||article.reporter_id (Doesn't do a DB query)||article.reporter.id (Doesn't do a DB query)|
|Foreign key (other end)||reporter.get_article_list()||reporter.article_set|
|Foreign key (other end, count)||reporter.get_article_count()||reporter.article_set.count()|
|Foreign key (other end)||reporter.get_article_list(headline__startswith="This")||reporter.article_set.filter(headline__startswith="This")|
|Adding related objects||reporter.add_article(headline="John's second story", pub_date=datetime(2005, 7, 29))||reporter.article_set.add(headline="John's second story", pub_date=datetime(2005, 7, 29))|
|Many-to-many (adding)||article.set_sites([s1.id, s2.id])||article.site_set.clear(); article.site_set.add(s1); article.site_set.add(s2);|
- Fields would be left as members by the metaclass.
- The real 'data' would end up either in name-mangled instance members, or in a private dictionary.
- When accessed via the class, they would return themselves. eg Reporter.name would be a field class you can inspect. This would make introspection as in the admin easier.
- When accessed via the instance, they would return a representation of the value they
hold. This could be
- the simple data instance from the private dict that was fetched from the DB.
- a lazily computed value, eg a BLOB field which would be fetched from the DB on first access, not at initial load time, or a ForeignKey relationship that hasn't been loaded yet.
- ForeignKeys and other related fields would place another descriptor on the related class. When accessed via the instance, this would return a lazy collection object. It will act like a set (an ordered one if there is an ordering involved).
This would also support other methods in favor of the get_related_list things.
Methods which change the meaning of the lazy collection are as follows:
- .filter(): adds query parameters using Django's normal DB query syntax.
- .order_by(): adds/changes ordering parameters.
The collection supports the appropriate collection protocols: It acts as a set, with ordering if there is an ordering in the underlying query. The query is only done when a collection protocol is used. Sometimes, multiple queries will be used to save traffic, eg if you access reporter.article_set[10000:10020] and then reporter.article_set[:20].