django PostgreSQL arrayfield store a 3 dimension array

Question

This is the list I want to store in my database :

[30, 9.45, 
[3.4499999999999993, 1.0500000000000007], 
[10.625, 12.875], 
[14.075, 11.825], 
[9.0, 15.0], 
[12.904858299595142, 15.637651821862349], 
[15.0, 18.0], 
[1.0, 1.0], 
[6.0, 10.5], 
[10.5, 6.0], 
[0.0, 0.0], 
[[3, 6], [3, 6, 6]], 
[[6.0, 1.5], [10.5, 6.0, 4.5]], 
[27.0, 94.5], 
[110.1141194331984, 106.83476720647775]]

my models.py :

D240_TOTAL = ArrayField(
            ArrayField(
                models.FloatField(max_length=10, blank=True),
                blank=True, null=True,
            ),
            blank=True, null=True,
        )

but am getting the error :

Field 'D240_TOTAL' expected a number but got [3, 6].

because my field is 2-d array but i am giving him a 3d array

my edited field :

M_BC_TOTAL = ArrayField(
                ArrayField(

                    ArrayField(
                        models.FloatField(max_length=10, blank=True),
                        blank=True, null=True,
                    ), blank=True,null=True),
                blank=True, null=True,
        )

but am getting this error : can't adapt type 'numpy.int32'

change your code so that you store a 2D array, or add another ArrayField, or use a JSONField to store any list — Louis-Justin Tallot
– Louis-Justin Tallot, Commented Jul 8, 2021 at 13:47
@Louis-JustinTallot i tried to add another Arrayfield but i am getting this error : can't adapt type 'numpy.int32' you can take a look at my edited question — NAS
– NAS, Commented Jul 8, 2021 at 13:54
the problem here is that your array is heterogeneous : [1, [2, 3] , [[4, 5], [6, 7]]] so Django cannot pass a number as an array. You should use JSONField (cf my answer below) — Louis-Justin Tallot
– Louis-Justin Tallot, Commented Jul 8, 2021 at 13:58

Louis-Justin Tallot · Accepted Answer · 2021-07-08 13:50:37Z

1

You can change you Model to use a JSONField instead. This will allow you to store any list :

from django.db import models
from django.contrib.postgres.fields import JSONField

D240_TOTAL = JSONField()

See also here for an how-to of JSONField.

answered Jul 8, 2021 at 13:50

Louis-Justin Tallot

4805 silver badges15 bronze badges

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

1 Comment

Louis-Justin Tallot Over a year ago

don't forget to run migrations after you changed your model !

Collectives™ on Stack Overflow

django PostgreSQL arrayfield store a 3 dimension array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related