DataError: value "578094500011955" is out of range for type integer

[sentry]

Sentry Issue: GENLAB-1Y

NumericValueOutOfRange: value "578094500011955" is out of range for type integer
  File "django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
  File "psycopg/cursor.py", line 97, in execute
    raise ex.with_traceback(None)

DataError: value "578094500011955" is out of range for type integer
(83 additional frame(s) were not displayed)
...
  File "django/db/backends/utils.py", line 92, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "django/db/backends/utils.py", line 100, in _execute
    with self.db.wrap_database_errors:
  File "django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "django/db/backends/utils.py", line 105, in _execute
    return self.cursor.execute(sql, params)
  File "psycopg/cursor.py", line 97, in execute
    raise ex.with_traceback(None)

[nicokant]

This seems to be happening in "/staff/orders/extraction/73/samples/"

[nicokant]

Casting should be done only for strings of max length of 18 digits, and the output field should be BigIntegerField.

genlab_bestilling/src/staff/views.py

Line 252 in 2aca6f0

name__regex=r"^\d+$",

TODO: use this regex: ^\d{1,18}$ instead and add a test to make sure that it's resilient enough

[omfj]

Fixed in #426