*Solved*
Mistake in query json_array_elements(animated_groups)
Needs change to this: json_array_elements(animated_groups::json)
On Friday, 14 November 2014 17:14:18 UTC, Volodymyr B wrote:
>
> Hi all
>
>
> I have class method in django model which is use json_array_elements
> function.
>
> In case when it performs by browser it works fine.
> But in tests it fails with:
> 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,
> jsonData['groups'][0])
>
> 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
>
> Question on stack
> <http://stackoverflow.com/questions/26932005/postgres-function-json-array-elements-does-not-found-while-djangos-tests>
>
> It was works on Mac OS X 10.9.5.
> But not sure about other software.
>
> And don't know in which software or tool could be bug.
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/d4d89b43-7f3d-4f73-b3c1-e22fdcb027f9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
