Django

Code

Changeset 7161

Show
Ignore:
Timestamp:
02/26/08 17:12:47 (4 months ago)
Author:
jacob
Message:

Re-enable substring lookups for IP address fields in Postgres using HOST() Thanks for the suggestion, Thomas Adamcik. Fixes #708.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • django/trunk/django/db/backends/postgresql/operations.py

    r7160 r7161  
    2727    def deferrable_sql(self): 
    2828        return " DEFERRABLE INITIALLY DEFERRED" 
     29 
     30    def field_cast_sql(self, db_type): 
     31        if db_type == 'inet': 
     32            return 'HOST(%s)' 
     33        return '%s' 
    2934 
    3035    def last_insert_id(self, cursor, table_name, pk_name): 

  • django/trunk/tests/regressiontests/string_lookup/models.py

    r7160 r7161  
    4040    name = models.CharField(max_length=50) 
    4141    text = models.TextField() 
     42    submitted_from = models.IPAddressField(blank=True, null=True) 
    4243 
    4344    def __str__(self): 
    …… 
    99100>>> Article.objects.get(text__contains='quick brown fox') 
    100101<Article: Article Test> 
     102 
     103# Regression test for #708: "like" queries on IP address fields require casting 
     104# to text (on PostgreSQL). 
     105>>> Article(name='IP test', text='The body', submitted_from='192.0.2.100').save() 
     106>>> Article.objects.filter(submitted_from__contains='192.0.2') 
     107[<Article: Article IP test>] 
     108 
    101109"""}