Uploaded image for project: 'ListenBrainz'
  1. ListenBrainz
  2. LB-761

Dataset hoster should validate type of parameters before using them

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: troi
    • Labels:
      None

      Description

      If you have a dataset that takes UUIDs as input, a dataset will often pass these directly to postgres, causing a failure such as 

      psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type uuid: "a" LINE 12: IN ('a', 'b', 'c')

      These parameters should be validated before use. The easiest way might be for Q{{uery}}s to specify an 'input validator' that is called on each input before passing data into fetch

        Attachments

          Activity

            People

            Assignee:
            rob Robert Kaye
            Reporter:
            alastairp Alastair Porter
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Packages

                Version Package