Opened 18 years ago

Closed 14 years ago

Last modified 14 years ago

#2616 closed enhancement (wontfix)

Add DB API support for lookup against IP address fields

Reported by: kirk.reeves@… Owned by: nobody
Component: Database layer (models, ORM) Version:
Severity: normal Keywords:
Cc: Triage Stage: Design decision needed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Jacob)

please add an additional key word for querysets when searching with the inet datatype..

and example would be
assume a table constructed as follows.

create table network_interfaces(
id serial,
ip inet,
interface char(20)
)

--The SQL Syntax ---
SELECT * from network_interface where ip << '10.210.0.0/16';

--possible Django syntax ---
Interfaces.objects.filter(ip_within='10.210.0.0/16')

Thanks. Django is a great project.

Change History (7)

comment:1 by Jacob, 18 years ago

Description: modified (diff)

This is a nice idea (I'd think that overloading the "in" lookup type would work best) here, but I'm concerned that there's not a way to do this in a database-agnostic manner. Kirk, do you think you could do a quick survey of databases and see if it's going to be possible to do this generically?

comment:2 by Adrian Holovaty, 18 years ago

Summary: additional database apiAdd DB API support for lookup against IP address fields

comment:3 by mir@…, 18 years ago

Triage Stage: UnreviewedDesign decision needed

comment:4 by Jacob, 17 years ago

Keywords: qs-rf added

comment:5 by Malcolm Tredinnick, 17 years ago

Keywords: qs-rf removed

Not a feature worth holding up queryset-refactor for. It can be done after the merge back into trunk. Removing the keyword.

comment:6 by Malcolm Tredinnick, 14 years ago

Resolution: wontfix
Status: newclosed

This is solved by adding the ability for custom (per-field) lookup types to the ORM syntax. Adding specific new lookup types is going to generally deferred until somebody implements that.

comment:7 by Carl Meyer, 14 years ago

Ticket for allowing custom lookup types is #14263.

Note: See TracTickets for help on using tickets.
Back to Top