starred/netbox
1
0
Fork 0
mirror of https://github.com/netbox-community/netbox.git synced 2026-01-11 21:10:29 +01:00
Code Issues 273 Packages Projects Releases 10 Wiki Activity

prefix__net_contains not working with /32 prefix #7506

New Issue
Closed
opened 2025-12-29 20:24:27 +01:00 by adam · 2 comments
adam commented 2025-12-29 20:24:27 +01:00
Owner
Copy Link

Originally created by @dainok on GitHub (Jan 13, 2023).

NetBox version

v3.4.2

Python version

3.10

Steps to Reproduce

Open a Django shell:

from ipam.models import Prefix
p1, c1 = Prefix.objects.get_or_create(prefix="1.1.1.1/32")
p2, c2 = Prefix.objects.get_or_create(prefix="1.1.1.0/24")
Prefix.objects.filter(prefix__net_contains="1.1.1.1")

Expected Behavior

Only p2 (1.1.1.0/24) is returned.

<PrefixQuerySet [<Prefix: 1.1.1.0/24>]>

Observed Behavior

p1 (1.1.1.1/32) should also returned.

Originally created by @dainok on GitHub (Jan 13, 2023). ### NetBox version v3.4.2 ### Python version 3.10 ### Steps to Reproduce Open a Django shell: ~~~ from ipam.models import Prefix p1, c1 = Prefix.objects.get_or_create(prefix="1.1.1.1/32") p2, c2 = Prefix.objects.get_or_create(prefix="1.1.1.0/24") Prefix.objects.filter(prefix__net_contains="1.1.1.1") ~~~ ### Expected Behavior Only p2 (1.1.1.0/24) is returned. ~~~ <PrefixQuerySet [<Prefix: 1.1.1.0/24>]> ~~~ ### Observed Behavior p1 (1.1.1.1/32) should also returned.
adam closed this issue 2025-12-29 20:24:28 +01:00
adam commented 2025-12-29 20:24:28 +01:00
Author
Owner
Copy Link

@kkthxbye-code commented on GitHub (Jan 13, 2023):

Not sure I follow here, I think it operates as is intended:

>>> p1, c1 = Prefix.objects.get_or_create(prefix="1.1.1.1/32")
>>> p2, c2 = Prefix.objects.get_or_create(prefix="1.1.1.0/24")
>>> Prefix.objects.filter(prefix__net_contains="1.1.1.1")
<PrefixQuerySet [<Prefix: 1.1.1.0/24>]>
>>> Prefix.objects.filter(prefix__net_contains_or_equals="1.1.1.1")
<PrefixQuerySet [<Prefix: 1.1.1.0/24>, <Prefix: 1.1.1.1/32>]>

They are basic wrappers around these:
https://www.postgresql.org/docs/9.3/functions-net.html

@kkthxbye-code commented on GitHub (Jan 13, 2023): Not sure I follow here, I think it operates as is intended: ``` >>> p1, c1 = Prefix.objects.get_or_create(prefix="1.1.1.1/32") >>> p2, c2 = Prefix.objects.get_or_create(prefix="1.1.1.0/24") >>> Prefix.objects.filter(prefix__net_contains="1.1.1.1") <PrefixQuerySet [<Prefix: 1.1.1.0/24>]> >>> Prefix.objects.filter(prefix__net_contains_or_equals="1.1.1.1") <PrefixQuerySet [<Prefix: 1.1.1.0/24>, <Prefix: 1.1.1.1/32>]> ``` They are basic wrappers around these: https://www.postgresql.org/docs/9.3/functions-net.html
adam commented 2025-12-29 20:24:28 +01:00
Author
Owner
Copy Link

@dainok commented on GitHub (Jan 13, 2023):

Make sense, thank you! I was using the networking mindset not the DBA ones!

@dainok commented on GitHub (Jan 13, 2023): Make sense, thank you! I was using the networking mindset not the DBA ones!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
beta
breaking change
complexity: high
complexity: low
complexity: medium
needs milestone
netbox
pending closure
plugin candidate
pull-request
Mirrored from GitHub Pull Request
 severity: high
severity: low
severity: medium
status: accepted
status: backlog
status: blocked
status: duplicate
status: needs owner
status: needs triage
status: revisions needed
status: under review
topic: GraphQL
topic: Internationalization
topic: OpenAPI
topic: UI/UX
topic: cabling
topic: event rules
topic: htmx navigation
topic: industrialization
topic: migrations
topic: plugins
topic: scripts
topic: templating
topic: testing
type: bug
type: deprecation
type: documentation
type: feature
type: housekeeping
type: translation
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#7506
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?