Opened 18 years ago
Last modified 14 years ago
#2616 closed enhancement
additional database api — at Version 1
Reported by: | 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 )
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.
Note:
See TracTickets
for help on using tickets.
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?