Insert List<int> to Hasura Postgresql

Question

How can I insert list of Integers to Hasura Postgresql?

I'm not sure what should be column_type - when I set type as "Integer[]" - that type in Hasura was automatically changed to int4[] - it might be okey, but I don't know what type I should declare in my mutation.

gqlInsert = """
    mutation InsertMutation(
      \$is_enabled: Boolean,
      \$weekdays: [Int], <-- what type should be in this place?
      \$name: String
    ) {
      insert_reminder_one(object: {
        is_enabled: \$is_enabled
        weekdays: \$weekdays
        name: \$name
      }) {
        id
      }
    }
    """;

If I have type as [Int] I have error like that:

GraphQLError(message: variable repeated_weekdays of type [Int] is used in position expecting _int4

Jesse Carter · Accepted Answer · 2022-03-11 17:51:29Z

1

The expected type is listed in your error message. It's supposed to be _int4. The underscore prefix on the front indicates its an array (a Hasura convention).

Hasura doesn't have great support at the moment for native array columns and you're supposed to pass array values in as a Postgres array literal string as documented here.

It should be $weekdays: _int4 and the value you pass in should look like '{1, 2, 3}' (as a string).

You might want to consider using a jsonb column instead of an array for now.

edited Mar 11, 2022 at 17:51

answered Mar 11, 2022 at 17:13

Jesse Carter

21.3k8 gold badges71 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Captivity Over a year ago

Thank you for your answer! I changed type in my dart code, but I have still error: GraphQLError(message: A string is expected for type: _int4) I'm trying pass value like {1, 2, 3, 4} so it's weird why in this error is "String" type. Do you know why?

Jesse Carter Over a year ago

Like I mentioned in my comment, its expected that you pass it as a string. Notice how I added quotes around the the example. Its on the Hasura roadmap to have better built in support for array columns in the future but this is the way you have to do it right now

Collectives™ on Stack Overflow

Insert List<int> to Hasura Postgresql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related