filters.py 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580
  1. import django_filters
  2. import netaddr
  3. from django.core.exceptions import ValidationError
  4. from django.db.models import Q
  5. from netaddr.core import AddrFormatError
  6. from dcim.models import Device, Interface, Region, Site
  7. from extras.filters import CustomFieldFilterSet, CreatedUpdatedFilterSet
  8. from tenancy.filters import TenancyFilterSet
  9. from utilities.filters import (
  10. BaseFilterSet, MultiValueCharFilter, MultiValueNumberFilter, NameSlugSearchFilterSet, NumericArrayFilter, TagFilter,
  11. TreeNodeMultipleChoiceFilter,
  12. )
  13. from virtualization.models import VirtualMachine, VMInterface
  14. from .choices import *
  15. from .models import Aggregate, IPAddress, Prefix, RIR, Role, RouteTarget, Service, VLAN, VLANGroup, VRF
  16. __all__ = (
  17. 'AggregateFilterSet',
  18. 'IPAddressFilterSet',
  19. 'PrefixFilterSet',
  20. 'RIRFilterSet',
  21. 'RoleFilterSet',
  22. 'RouteTargetFilterSet',
  23. 'ServiceFilterSet',
  24. 'VLANFilterSet',
  25. 'VLANGroupFilterSet',
  26. 'VRFFilterSet',
  27. )
  28. class VRFFilterSet(BaseFilterSet, TenancyFilterSet, CustomFieldFilterSet, CreatedUpdatedFilterSet):
  29. q = django_filters.CharFilter(
  30. method='search',
  31. label='Search',
  32. )
  33. tag = TagFilter()
  34. def search(self, queryset, name, value):
  35. if not value.strip():
  36. return queryset
  37. return queryset.filter(
  38. Q(name__icontains=value) |
  39. Q(rd__icontains=value) |
  40. Q(description__icontains=value)
  41. )
  42. class Meta:
  43. model = VRF
  44. fields = ['id', 'name', 'rd', 'enforce_unique']
  45. class RouteTargetFilterSet(BaseFilterSet, TenancyFilterSet, CustomFieldFilterSet, CreatedUpdatedFilterSet):
  46. q = django_filters.CharFilter(
  47. method='search',
  48. label='Search',
  49. )
  50. tag = TagFilter()
  51. def search(self, queryset, name, value):
  52. if not value.strip():
  53. return queryset
  54. return queryset.filter(
  55. Q(name__icontains=value) |
  56. Q(description__icontains=value)
  57. )
  58. class Meta:
  59. model = RouteTarget
  60. fields = ['id', 'name']
  61. class RIRFilterSet(BaseFilterSet, NameSlugSearchFilterSet):
  62. class Meta:
  63. model = RIR
  64. fields = ['id', 'name', 'slug', 'is_private', 'description']
  65. class AggregateFilterSet(BaseFilterSet, CustomFieldFilterSet, CreatedUpdatedFilterSet):
  66. q = django_filters.CharFilter(
  67. method='search',
  68. label='Search',
  69. )
  70. family = django_filters.NumberFilter(
  71. field_name='prefix',
  72. lookup_expr='family'
  73. )
  74. prefix = django_filters.CharFilter(
  75. method='filter_prefix',
  76. label='Prefix',
  77. )
  78. rir_id = django_filters.ModelMultipleChoiceFilter(
  79. queryset=RIR.objects.all(),
  80. label='RIR (ID)',
  81. )
  82. rir = django_filters.ModelMultipleChoiceFilter(
  83. field_name='rir__slug',
  84. queryset=RIR.objects.all(),
  85. to_field_name='slug',
  86. label='RIR (slug)',
  87. )
  88. tag = TagFilter()
  89. class Meta:
  90. model = Aggregate
  91. fields = ['id', 'date_added']
  92. def search(self, queryset, name, value):
  93. if not value.strip():
  94. return queryset
  95. qs_filter = Q(description__icontains=value)
  96. try:
  97. prefix = str(netaddr.IPNetwork(value.strip()).cidr)
  98. qs_filter |= Q(prefix__net_contains_or_equals=prefix)
  99. except (AddrFormatError, ValueError):
  100. pass
  101. return queryset.filter(qs_filter)
  102. def filter_prefix(self, queryset, name, value):
  103. if not value.strip():
  104. return queryset
  105. try:
  106. query = str(netaddr.IPNetwork(value).cidr)
  107. return queryset.filter(prefix=query)
  108. except (AddrFormatError, ValueError):
  109. return queryset.none()
  110. class RoleFilterSet(BaseFilterSet, NameSlugSearchFilterSet):
  111. q = django_filters.CharFilter(
  112. method='search',
  113. label='Search',
  114. )
  115. class Meta:
  116. model = Role
  117. fields = ['id', 'name', 'slug']
  118. class PrefixFilterSet(BaseFilterSet, TenancyFilterSet, CustomFieldFilterSet, CreatedUpdatedFilterSet):
  119. q = django_filters.CharFilter(
  120. method='search',
  121. label='Search',
  122. )
  123. family = django_filters.NumberFilter(
  124. field_name='prefix',
  125. lookup_expr='family'
  126. )
  127. prefix = django_filters.CharFilter(
  128. method='filter_prefix',
  129. label='Prefix',
  130. )
  131. within = django_filters.CharFilter(
  132. method='search_within',
  133. label='Within prefix',
  134. )
  135. within_include = django_filters.CharFilter(
  136. method='search_within_include',
  137. label='Within and including prefix',
  138. )
  139. contains = django_filters.CharFilter(
  140. method='search_contains',
  141. label='Prefixes which contain this prefix or IP',
  142. )
  143. mask_length = django_filters.NumberFilter(
  144. field_name='prefix',
  145. lookup_expr='net_mask_length'
  146. )
  147. mask_length__gte = django_filters.NumberFilter(
  148. field_name='prefix',
  149. lookup_expr='net_mask_length__gte'
  150. )
  151. mask_length__lte = django_filters.NumberFilter(
  152. field_name='prefix',
  153. lookup_expr='net_mask_length__lte'
  154. )
  155. vrf_id = django_filters.ModelMultipleChoiceFilter(
  156. queryset=VRF.objects.all(),
  157. label='VRF',
  158. )
  159. vrf = django_filters.ModelMultipleChoiceFilter(
  160. field_name='vrf__rd',
  161. queryset=VRF.objects.all(),
  162. to_field_name='rd',
  163. label='VRF (RD)',
  164. )
  165. region_id = TreeNodeMultipleChoiceFilter(
  166. queryset=Region.objects.all(),
  167. field_name='site__region',
  168. lookup_expr='in',
  169. label='Region (ID)',
  170. )
  171. region = TreeNodeMultipleChoiceFilter(
  172. queryset=Region.objects.all(),
  173. field_name='site__region',
  174. lookup_expr='in',
  175. to_field_name='slug',
  176. label='Region (slug)',
  177. )
  178. site_id = django_filters.ModelMultipleChoiceFilter(
  179. queryset=Site.objects.all(),
  180. label='Site (ID)',
  181. )
  182. site = django_filters.ModelMultipleChoiceFilter(
  183. field_name='site__slug',
  184. queryset=Site.objects.all(),
  185. to_field_name='slug',
  186. label='Site (slug)',
  187. )
  188. vlan_id = django_filters.ModelMultipleChoiceFilter(
  189. queryset=VLAN.objects.all(),
  190. label='VLAN (ID)',
  191. )
  192. vlan_vid = django_filters.NumberFilter(
  193. field_name='vlan__vid',
  194. label='VLAN number (1-4095)',
  195. )
  196. role_id = django_filters.ModelMultipleChoiceFilter(
  197. queryset=Role.objects.all(),
  198. label='Role (ID)',
  199. )
  200. role = django_filters.ModelMultipleChoiceFilter(
  201. field_name='role__slug',
  202. queryset=Role.objects.all(),
  203. to_field_name='slug',
  204. label='Role (slug)',
  205. )
  206. status = django_filters.MultipleChoiceFilter(
  207. choices=PrefixStatusChoices,
  208. null_value=None
  209. )
  210. tag = TagFilter()
  211. class Meta:
  212. model = Prefix
  213. fields = ['id', 'is_pool']
  214. def search(self, queryset, name, value):
  215. if not value.strip():
  216. return queryset
  217. qs_filter = Q(description__icontains=value)
  218. try:
  219. prefix = str(netaddr.IPNetwork(value.strip()).cidr)
  220. qs_filter |= Q(prefix__net_contains_or_equals=prefix)
  221. except (AddrFormatError, ValueError):
  222. pass
  223. return queryset.filter(qs_filter)
  224. def filter_prefix(self, queryset, name, value):
  225. if not value.strip():
  226. return queryset
  227. try:
  228. query = str(netaddr.IPNetwork(value).cidr)
  229. return queryset.filter(prefix=query)
  230. except (AddrFormatError, ValueError):
  231. return queryset.none()
  232. def search_within(self, queryset, name, value):
  233. value = value.strip()
  234. if not value:
  235. return queryset
  236. try:
  237. query = str(netaddr.IPNetwork(value).cidr)
  238. return queryset.filter(prefix__net_contained=query)
  239. except (AddrFormatError, ValueError):
  240. return queryset.none()
  241. def search_within_include(self, queryset, name, value):
  242. value = value.strip()
  243. if not value:
  244. return queryset
  245. try:
  246. query = str(netaddr.IPNetwork(value).cidr)
  247. return queryset.filter(prefix__net_contained_or_equal=query)
  248. except (AddrFormatError, ValueError):
  249. return queryset.none()
  250. def search_contains(self, queryset, name, value):
  251. value = value.strip()
  252. if not value:
  253. return queryset
  254. try:
  255. # Searching by prefix
  256. if '/' in value:
  257. return queryset.filter(prefix__net_contains_or_equals=str(netaddr.IPNetwork(value).cidr))
  258. # Searching by IP address
  259. else:
  260. return queryset.filter(prefix__net_contains=str(netaddr.IPAddress(value)))
  261. except (AddrFormatError, ValueError):
  262. return queryset.none()
  263. class IPAddressFilterSet(BaseFilterSet, TenancyFilterSet, CustomFieldFilterSet, CreatedUpdatedFilterSet):
  264. q = django_filters.CharFilter(
  265. method='search',
  266. label='Search',
  267. )
  268. family = django_filters.NumberFilter(
  269. field_name='address',
  270. lookup_expr='family'
  271. )
  272. parent = django_filters.CharFilter(
  273. method='search_by_parent',
  274. label='Parent prefix',
  275. )
  276. address = MultiValueCharFilter(
  277. method='filter_address',
  278. label='Address',
  279. )
  280. mask_length = django_filters.NumberFilter(
  281. method='filter_mask_length',
  282. label='Mask length',
  283. )
  284. vrf_id = django_filters.ModelMultipleChoiceFilter(
  285. queryset=VRF.objects.all(),
  286. label='VRF',
  287. )
  288. vrf = django_filters.ModelMultipleChoiceFilter(
  289. field_name='vrf__rd',
  290. queryset=VRF.objects.all(),
  291. to_field_name='rd',
  292. label='VRF (RD)',
  293. )
  294. device = MultiValueCharFilter(
  295. method='filter_device',
  296. field_name='name',
  297. label='Device (name)',
  298. )
  299. device_id = MultiValueNumberFilter(
  300. method='filter_device',
  301. field_name='pk',
  302. label='Device (ID)',
  303. )
  304. virtual_machine = MultiValueCharFilter(
  305. method='filter_virtual_machine',
  306. field_name='name',
  307. label='Virtual machine (name)',
  308. )
  309. virtual_machine_id = MultiValueNumberFilter(
  310. method='filter_virtual_machine',
  311. field_name='pk',
  312. label='Virtual machine (ID)',
  313. )
  314. interface = django_filters.ModelMultipleChoiceFilter(
  315. field_name='interface__name',
  316. queryset=Interface.objects.all(),
  317. to_field_name='name',
  318. label='Interface (name)',
  319. )
  320. interface_id = django_filters.ModelMultipleChoiceFilter(
  321. field_name='interface',
  322. queryset=Interface.objects.all(),
  323. label='Interface (ID)',
  324. )
  325. vminterface = django_filters.ModelMultipleChoiceFilter(
  326. field_name='vminterface__name',
  327. queryset=VMInterface.objects.all(),
  328. to_field_name='name',
  329. label='VM interface (name)',
  330. )
  331. vminterface_id = django_filters.ModelMultipleChoiceFilter(
  332. field_name='vminterface',
  333. queryset=VMInterface.objects.all(),
  334. label='VM interface (ID)',
  335. )
  336. assigned_to_interface = django_filters.BooleanFilter(
  337. method='_assigned_to_interface',
  338. label='Is assigned to an interface',
  339. )
  340. status = django_filters.MultipleChoiceFilter(
  341. choices=IPAddressStatusChoices,
  342. null_value=None
  343. )
  344. role = django_filters.MultipleChoiceFilter(
  345. choices=IPAddressRoleChoices
  346. )
  347. tag = TagFilter()
  348. class Meta:
  349. model = IPAddress
  350. fields = ['id', 'dns_name']
  351. def search(self, queryset, name, value):
  352. if not value.strip():
  353. return queryset
  354. qs_filter = (
  355. Q(dns_name__icontains=value) |
  356. Q(description__icontains=value) |
  357. Q(address__istartswith=value)
  358. )
  359. return queryset.filter(qs_filter)
  360. def search_by_parent(self, queryset, name, value):
  361. value = value.strip()
  362. if not value:
  363. return queryset
  364. try:
  365. query = str(netaddr.IPNetwork(value.strip()).cidr)
  366. return queryset.filter(address__net_host_contained=query)
  367. except (AddrFormatError, ValueError):
  368. return queryset.none()
  369. def filter_address(self, queryset, name, value):
  370. try:
  371. return queryset.filter(address__net_in=value)
  372. except ValidationError:
  373. return queryset.none()
  374. def filter_mask_length(self, queryset, name, value):
  375. if not value:
  376. return queryset
  377. return queryset.filter(address__net_mask_length=value)
  378. def filter_device(self, queryset, name, value):
  379. devices = Device.objects.filter(**{'{}__in'.format(name): value})
  380. if not devices.exists():
  381. return queryset.none()
  382. interface_ids = []
  383. for device in devices:
  384. interface_ids.extend(device.vc_interfaces.values_list('id', flat=True))
  385. return queryset.filter(
  386. interface__in=interface_ids
  387. )
  388. def filter_virtual_machine(self, queryset, name, value):
  389. virtual_machines = VirtualMachine.objects.filter(**{'{}__in'.format(name): value})
  390. if not virtual_machines.exists():
  391. return queryset.none()
  392. interface_ids = []
  393. for vm in virtual_machines:
  394. interface_ids.extend(vm.interfaces.values_list('id', flat=True))
  395. return queryset.filter(
  396. vminterface__in=interface_ids
  397. )
  398. def _assigned_to_interface(self, queryset, name, value):
  399. return queryset.exclude(assigned_object_id__isnull=value)
  400. class VLANGroupFilterSet(BaseFilterSet, NameSlugSearchFilterSet):
  401. region_id = TreeNodeMultipleChoiceFilter(
  402. queryset=Region.objects.all(),
  403. field_name='site__region',
  404. lookup_expr='in',
  405. label='Region (ID)',
  406. )
  407. region = TreeNodeMultipleChoiceFilter(
  408. queryset=Region.objects.all(),
  409. field_name='site__region',
  410. lookup_expr='in',
  411. to_field_name='slug',
  412. label='Region (slug)',
  413. )
  414. site_id = django_filters.ModelMultipleChoiceFilter(
  415. queryset=Site.objects.all(),
  416. label='Site (ID)',
  417. )
  418. site = django_filters.ModelMultipleChoiceFilter(
  419. field_name='site__slug',
  420. queryset=Site.objects.all(),
  421. to_field_name='slug',
  422. label='Site (slug)',
  423. )
  424. class Meta:
  425. model = VLANGroup
  426. fields = ['id', 'name', 'slug', 'description']
  427. class VLANFilterSet(BaseFilterSet, TenancyFilterSet, CustomFieldFilterSet, CreatedUpdatedFilterSet):
  428. q = django_filters.CharFilter(
  429. method='search',
  430. label='Search',
  431. )
  432. region_id = TreeNodeMultipleChoiceFilter(
  433. queryset=Region.objects.all(),
  434. field_name='site__region',
  435. lookup_expr='in',
  436. label='Region (ID)',
  437. )
  438. region = TreeNodeMultipleChoiceFilter(
  439. queryset=Region.objects.all(),
  440. field_name='site__region',
  441. lookup_expr='in',
  442. to_field_name='slug',
  443. label='Region (slug)',
  444. )
  445. site_id = django_filters.ModelMultipleChoiceFilter(
  446. queryset=Site.objects.all(),
  447. label='Site (ID)',
  448. )
  449. site = django_filters.ModelMultipleChoiceFilter(
  450. field_name='site__slug',
  451. queryset=Site.objects.all(),
  452. to_field_name='slug',
  453. label='Site (slug)',
  454. )
  455. group_id = django_filters.ModelMultipleChoiceFilter(
  456. queryset=VLANGroup.objects.all(),
  457. label='Group (ID)',
  458. )
  459. group = django_filters.ModelMultipleChoiceFilter(
  460. field_name='group__slug',
  461. queryset=VLANGroup.objects.all(),
  462. to_field_name='slug',
  463. label='Group',
  464. )
  465. role_id = django_filters.ModelMultipleChoiceFilter(
  466. queryset=Role.objects.all(),
  467. label='Role (ID)',
  468. )
  469. role = django_filters.ModelMultipleChoiceFilter(
  470. field_name='role__slug',
  471. queryset=Role.objects.all(),
  472. to_field_name='slug',
  473. label='Role (slug)',
  474. )
  475. status = django_filters.MultipleChoiceFilter(
  476. choices=VLANStatusChoices,
  477. null_value=None
  478. )
  479. tag = TagFilter()
  480. class Meta:
  481. model = VLAN
  482. fields = ['id', 'vid', 'name']
  483. def search(self, queryset, name, value):
  484. if not value.strip():
  485. return queryset
  486. qs_filter = Q(name__icontains=value) | Q(description__icontains=value)
  487. try:
  488. qs_filter |= Q(vid=int(value.strip()))
  489. except ValueError:
  490. pass
  491. return queryset.filter(qs_filter)
  492. class ServiceFilterSet(BaseFilterSet, CreatedUpdatedFilterSet):
  493. q = django_filters.CharFilter(
  494. method='search',
  495. label='Search',
  496. )
  497. device_id = django_filters.ModelMultipleChoiceFilter(
  498. queryset=Device.objects.all(),
  499. label='Device (ID)',
  500. )
  501. device = django_filters.ModelMultipleChoiceFilter(
  502. field_name='device__name',
  503. queryset=Device.objects.all(),
  504. to_field_name='name',
  505. label='Device (name)',
  506. )
  507. virtual_machine_id = django_filters.ModelMultipleChoiceFilter(
  508. queryset=VirtualMachine.objects.all(),
  509. label='Virtual machine (ID)',
  510. )
  511. virtual_machine = django_filters.ModelMultipleChoiceFilter(
  512. field_name='virtual_machine__name',
  513. queryset=VirtualMachine.objects.all(),
  514. to_field_name='name',
  515. label='Virtual machine (name)',
  516. )
  517. port = NumericArrayFilter(
  518. field_name='ports',
  519. lookup_expr='contains'
  520. )
  521. tag = TagFilter()
  522. class Meta:
  523. model = Service
  524. fields = ['id', 'name', 'protocol']
  525. def search(self, queryset, name, value):
  526. if not value.strip():
  527. return queryset
  528. qs_filter = Q(name__icontains=value) | Q(description__icontains=value)
  529. return queryset.filter(qs_filter)