Topology Maps - Regexp with comma failed #485

New Issue

adam · 2025-12-29T16:22:35+01:00

adam commented

2025-12-29 16:22:35 +01:00

Originally created by @kryskool on GitHub (Oct 22, 2016).

Hi

Thanks for this great app.

I found an issue with this Regexp when i would like to find Switch1 to Switch999

Switch[0-9]{1,3}

When the ligne is split with comma to compose the topology map, it failed with this message

Exception Type: DataError
Exception Value: ERREUR:  expression rationnelle invalide : braces {} not balanced

params (u'(Switch){1',)
self    <django.db.backends.utils.CursorDebugWrapper object at 0xb4906a6c>

sql u'SELECT (CAST(SUBSTRING(dcim_device.name FROM \'(\\d+)$\') AS integer)) AS "_dcim_device_name3", (SUBSTRING(dcim_device.name FROM \'^\\d*(.*?)\\d*$\')) AS "_dcim_device_name2", (CAST(SUBSTRING(dcim_device.name FROM \'^(\\d+)\') AS integer)) AS "_dcim_device_name1", "dcim_device"."id", "dcim_device"."created", "dcim_device"."last_updated", "dcim_device"."device_type_id", "dcim_device"."device_role_id", "dcim_device"."tenant_id", "dcim_device"."platform_id", "dcim_device"."name", "dcim_device"."serial", "dcim_device"."asset_tag", "dcim_device"."rack_id", "dcim_device"."position", "dcim_device"."face", "dcim_device"."status", "dcim_device"."primary_ip4_id", "dcim_device"."primary_ip6_id", "dcim_device"."comments" FROM "dcim_device" WHERE "dcim_device"."name"::text ~ %s ORDER BY "_dcim_device_name1" ASC, "_dcim_device_name2" ASC, "_dcim_device_name3" ASC'

I think the comma must be replace by semicolon ; as the line separator (because semicolon is a reserve character in SQL and not use as part of the regexp)

A migration script can migrate all existings regexp with no problem

Regards,

Originally created by @kryskool on GitHub (Oct 22, 2016). Hi Thanks for this great app. I found an issue with this Regexp when i would like to find **Switch1** to **Switch999** ``` Switch[0-9]{1,3} ``` When the ligne is split with comma to compose the topology map, it failed with this message ``` Exception Type: DataError Exception Value: ERREUR: expression rationnelle invalide : braces {} not balanced params (u'(Switch){1',) self <django.db.backends.utils.CursorDebugWrapper object at 0xb4906a6c> sql u'SELECT (CAST(SUBSTRING(dcim_device.name FROM \'(\\d+)$\') AS integer)) AS "_dcim_device_name3", (SUBSTRING(dcim_device.name FROM \'^\\d*(.*?)\\d*$\')) AS "_dcim_device_name2", (CAST(SUBSTRING(dcim_device.name FROM \'^(\\d+)\') AS integer)) AS "_dcim_device_name1", "dcim_device"."id", "dcim_device"."created", "dcim_device"."last_updated", "dcim_device"."device_type_id", "dcim_device"."device_role_id", "dcim_device"."tenant_id", "dcim_device"."platform_id", "dcim_device"."name", "dcim_device"."serial", "dcim_device"."asset_tag", "dcim_device"."rack_id", "dcim_device"."position", "dcim_device"."face", "dcim_device"."status", "dcim_device"."primary_ip4_id", "dcim_device"."primary_ip6_id", "dcim_device"."comments" FROM "dcim_device" WHERE "dcim_device"."name"::text ~ %s ORDER BY "_dcim_device_name1" ASC, "_dcim_device_name2" ASC, "_dcim_device_name3" ASC' ``` I think the comma must be replace by semicolon **;** as the line separator (because semicolon is a reserve character in SQL and not use as part of the regexp) A migration script can migrate all existings regexp with no problem Regards,

adam added the type: bug label 2025-12-29 16:22:35 +01:00

adam closed this issue

2025-12-29 16:22:35 +01:00

Sign in to join this conversation.

Branches Tags

main

21102-fix-graphiql-explorer

update-changelog-comments-docs

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#485