Postgres function json_array_elements does not found while django's tests

Question

I have class method in django model which is using json_array_elements function.

In case when it performs by browser it works fine. But in tests it fails. python manage.py test

Traceback (most recent call last):
  File "path_to_project/dj_server/model_animations/tests.py", line 94, in test_cteating
    response_first = model_animations.views.get_animations_list(request, groupid)
  File "path_to_project/dj_server/model_animations/views.py", line 37, in get_animations_list
    for model_anim in listArray:
  File "/Library/Python/2.7/site-packages/django/db/models/query.py", line 1535, in __iter__
    query = iter(self.query)
  File "/Library/Python/2.7/site-packages/django/db/models/sql/query.py", line 76, in __iter__
    self._execute_query()
  File "/Library/Python/2.7/site-packages/django/db/models/sql/query.py", line 90, in _execute_query
    self.cursor.execute(self.sql, self.params)
  File "/Library/Python/2.7/site-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "/Library/Python/2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/Library/Python/2.7/site-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
ProgrammingError: function json_array_elements(text) does not exist
LINE 1: ...on_name FROM model_animations_model, json_array...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

in models.py

@classmethod
def animations_list(self, group_id):
    if group_id:
        try:
            listArray = ModelAnimationList.objects.raw(('SELECT * FROM model_animations_model, json_array_elements(animated_groups) AS data WHERE \'"%s"\' = data::text' %group_id))
            return listArray
        except:
            pass
    return None

in views.py def get_animations_list(request, group_id): ...

listArray = ModelAnimationList.animations_list(group_id)
if listArray:
    for model_anim in listArray:
        if model_anim:
            anim_dict = { 'a_id'  : model_anim.id, 'a_name' : model_anim.animation_name }
            result_anim_list.append(anim_dict)

...

in tests.py

request = HttpRequest()
response_first = model_animations.views.get_animations_list(request, groupid)

Installed:
python 2.7
Django 1.7.1
Postgres 9.3.5
psycopg2 2.5.4
Mac 10.10 yosemite

Could you please post the code for your failing test cases?

adds68
– adds68

2014-11-14 14:57:05 +00:00
Commented Nov 14, 2014 at 14:57 — adds68
– adds68, Commented Nov 14, 2014 at 14:57
oh, it's a lot of code. I will try make something simple.

Volodymyr B.
– Volodymyr B.

2014-11-14 16:37:17 +00:00
Commented Nov 14, 2014 at 16:37 — Volodymyr B.
– Volodymyr B., Commented Nov 14, 2014 at 16:37

Volodymyr B. · Accepted Answer · 2014-11-17 13:28:03Z

36

Mistake in query json_array_elements(animated_groups)

Needs change to this: json_array_elements(animated_groups::json)

answered Nov 17, 2014 at 13:28

Volodymyr B.

3,4492 gold badges32 silver badges50 bronze badges

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

1 Comment

Sheharyar Over a year ago

For me, I had to use to_jsonb. E.g. json_array_elements(to_jsonb(items))

Yogesh Kumar · Accepted Answer · 2019-01-05 13:25:42Z

10

Postgres JSON processing functions such as json_array_elements(animated_groups::json), jsonb_array_elements(animated_groups::jsonb) will take json or jsonb values.

Because postgres JSON field(animated_groups) are store as text format or binary format. so we need to convert the type by using either ::json or ::jsonb it give the json or jsonb format

check here

edited Jan 5, 2019 at 13:25

answered Jan 5, 2019 at 12:32

Yogesh Kumar

1091 silver badge5 bronze badges

Collectives™ on Stack Overflow

Postgres function json_array_elements does not found while django's tests

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related