I want to create array type test data in postgres, but I’m struggling

[ipposhi39]

I created the following yml file and ran it, but I am getting an error

users.yml

- id: 1
  warehouse_ids:
    - 1
    - 2

error

&testfixtures.InsertError{
  Err: &pq.Error{
    Severity:         "ERROR",
    Code:             "22P02",
    Message:          "malformed array literal: \"[1,2]\"",
    Detail:           "Missing \"]\" after array dimensions.",
    Hint:             "",
    Position:         "",
    InternalPosition: "",
    InternalQuery:    "",
    Where:            "",
    Schema:           "",
    Table:            "",
    Column:           "",
    DataTypeName:     "",
    Constraint:       "",
    File:             "arrayfuncs.c",
    Line:             "292",
    Routine:          "array_in",
  },
   SQL:    "INSERT INTO \"users\" (\"id\", \"warehouse_ids\") VALUES ($1, $2)",
 Params: []interface {}{
    1,
    "[1,2]",
  },
}

How can I solve this?

[aashestakov]

You can use special prefix:
RAW=
for example, if your column "warehouse_ids" in PostgreSQL has type integer[] (array integer), then in fixture file it is possible to make so:

- id: 1
  warehouse_ids: RAW='{2639,4000}'

this prefix is mentioned in README.md

[andreynering]

Yeah, unfortunately we don't support every column type that exists. Arrays and maps are assumed to be JSON columns. Anything different needs the RAW= prefix currently.

If anyone has an idea for a better syntax, let me know.