#25829: Cannot store a dict object into HStoreField
----------------------------------+-------------------------
Reporter: benzid-wael | Owner:
Type: Uncategorized | Status: new
Component: contrib.postgres | Version: 1.8
Severity: Normal | Keywords: HStoreField
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------+-------------------------
I want to store a tweet status in database, below the model definition
{{{#!python
class Status(models.Model):
raw = pgfields.HStoreField()
status = Status(raw=dict_object)
}}}
and I got this error:
{{{
ProgrammingError: ARRAY types integer and integer[] cannot be matched
LINE 1: ... 'id_str', 'screen_name', 'name'], ARRAY[9284062, ARRAY[3, 1...
}}}
below the data that I want to insert:
{{{#!python
{u'contributors': None,
u'coordinates': None,
u'created_at': u'Sat Nov 28 19:36:10 +0000 2015',
u'entities': {u'hashtags': [{u'indices': [67, 78], u'text':
u'devfestlon'}],
u'media': [{u'display_url': u'pic.twitter.com/jsQ5eqTYvD',
u'expanded_url':
u'http://twitter.com/gerardsans/status/670682424477679617/photo/1',
u'id': 670682412188307462,
u'id_str': u'670682412188307462',
u'indices': [114, 137],
u'media_url': u'http://pbs.twimg.com/media/CU6
-GbeWEAYk-2U.jpg',
u'media_url_https':
u'https://pbs.twimg.com/media/CU6-GbeWEAYk-2U.jpg',
u'sizes': {u'large': {u'h': 756,
u'resize': u'fit',
u'w': 1021},
u'medium': {u'h': 444,
u'resize': u'fit',
u'w': 600},
u'small': {u'h': 251,
u'resize': u'fit',
u'w': 340},
u'thumb': {u'h': 150,
u'resize': u'crop',
u'w': 150}},
u'source_status_id': 670682424477679617,
u'source_status_id_str': u'670682424477679617',
u'source_user_id': 9284062,
u'source_user_id_str': u'9284062',
u'type': u'photo',
u'url': u'https://t.co/jsQ5eqTYvD'}],
u'symbols': [],
u'urls': [{u'display_url':
u'slides.com/gerardsans/str\u2026',
u'expanded_url': u'http://slides.com/gerardsans
/streams-in-angular2',
u'indices': [90, 113],
u'url': u'https://t.co/NhKrNLo0og'}],
u'user_mentions': [{u'id': 9284062,
u'id_str': u'9284062',
u'indices': [3, 14],
u'name': u'gerardsans',
u'screen_name': u'gerardsans'},
{u'id': 53442117,
u'id_str': u'53442117',
u'indices': [79, 89],
u'name': u'GDG London',
u'screen_name': u'gdglondon'}]},
u'favorite_count': 0,
u'favorited': False,
u'geo': None,
u'id': 670687648726519809,
u'id_str': u'670687648726519809',
u'in_reply_to_screen_name': None,
u'in_reply_to_status_id': None,
u'in_reply_to_status_id_str': None,
u'in_reply_to_user_id': None,
u'in_reply_to_user_id_str': None,
u'is_quote_status': False,
u'lang': u'en',
u'metadata': {u'iso_language_code': u'en', u'result_type': u'recent'},
u'place': None,
u'possibly_sensitive': False,
u'retweet_count': 2,
u'retweeted': False,
u'retweeted_status': {u'contributors': None,
u'coordinates': None,
u'created_at': u'Sat Nov 28 19:15:25 +0000 2015',
u'entities': {u'hashtags': [{u'indices': [51, 62],
u'text':
u'devfestlon'}],
u'media': [{u'display_url':
u'pic.twitter.com/jsQ5eqTYvD',
u'expanded_url':
u'http://twitter.com/gerardsans/status/670682424477679617/photo/1',
u'id':
670682412188307462,
u'id_str':
u'670682412188307462',
u'indices': [98, 121],
u'media_url':
u'http://pbs.twimg.com/media/CU6-GbeWEAYk-2U.jpg',
u'media_url_https':
u'https://pbs.twimg.com/media/CU6-GbeWEAYk-2U.jpg',
u'sizes': {u'large':
{u'h': 756,
u'resize': u'fit',
u'w': 1021},
u'medium':
{u'h': 444,
u'resize': u'fit',
u'w': 600},
u'small':
{u'h': 251,
u'resize': u'fit',
u'w': 340},
u'thumb':
{u'h': 150,
u'resize': u'crop',
u'w': 150}},
u'type': u'photo',
u'url':
u'https://t.co/jsQ5eqTYvD'}],
u'symbols': [],
u'urls': [{u'display_url':
u'slides.com/gerardsans/str\u2026',
u'expanded_url':
u'http://slides.com/gerardsans/streams-in-angular2',
u'indices': [74, 97],
u'url':
u'https://t.co/NhKrNLo0og'}],
u'user_mentions': [{u'id': 53442117,
u'id_str':
u'53442117',
u'indices': [63,
73],
u'name': u'GDG
London',
u'screen_name':
u'gdglondon'}]},
u'favorite_count': 2,
u'favorited': False,
u'geo': None,
u'id': 670682424477679617,
u'id_str': u'670682424477679617',
u'in_reply_to_screen_name': None,
u'in_reply_to_status_id': None,
u'in_reply_to_status_id_str': None,
u'in_reply_to_user_id': None,
u'in_reply_to_user_id_str': None,
u'is_quote_status': False,
u'lang': u'en',
u'metadata': {u'iso_language_code': u'en',
u'result_type': u'recent'},
u'place': None,
u'possibly_sensitive': False,
u'retweet_count': 2,
u'retweeted': False,
u'source': u'<a
href="http://twitter.com/download/android"; rel="nofollow">Twitter for
Android</a>',
u'text': u'Slides from Asynchronous Data Streams in
Angular 2 #devfestlon @gdglondon https://t.co/NhKrNLo0og
https://t.co/jsQ5eqTYvD',
u'truncated': False,
u'user': {u'contributors_enabled': False,
u'created_at': u'Sat Oct 06 20:04:48
+0000 2007',
u'default_profile': True,
u'default_profile_image': False,
u'description': u'AngularJS GDE | Coding
is fun | Coded something awesome today? | #AngularJS & #JavaScript are the
new kings! \u2764 | @angularjs_labs Meetup organiser',
u'entities': {u'description': {u'urls':
[]},
u'url': {u'urls':
[{u'display_url': u'medium.com/@gerard.sans',
u'expanded_url': u'https://medium.com/@gerard.sans',
u'indices': [0,
23],
u'url':
u'https://t.co/OzlOVVZNqK'}]}},
u'favourites_count': 1237,
u'follow_request_sent': False,
u'followers_count': 768,
u'following': False,
u'friends_count': 785,
u'geo_enabled': True,
u'has_extended_profile': False,
u'id': 9284062,
u'id_str': u'9284062',
u'is_translation_enabled': False,
u'is_translator': False,
u'lang': u'en',
u'listed_count': 102,
u'location': u'London \u2602',
u'name': u'gerardsans',
u'notifications': False,
u'profile_background_color': u'C0DEED',
u'profile_background_image_url':
u'http://abs.twimg.com/images/themes/theme1/bg.png',
u'profile_background_image_url_https':
u'https://abs.twimg.com/images/themes/theme1/bg.png',
u'profile_background_tile': False,
u'profile_banner_url':
u'https://pbs.twimg.com/profile_banners/9284062/1448587325',
u'profile_image_url':
u'http://pbs.twimg.com/profile_images/585578015641448448/pn0ZzQuj_normal.png',
u'profile_image_url_https':
u'https://pbs.twimg.com/profile_images/585578015641448448/pn0ZzQuj_normal.png',
u'profile_link_color': u'0084B4',
u'profile_sidebar_border_color':
u'C0DEED',
u'profile_sidebar_fill_color': u'DDEEF6',
u'profile_text_color': u'333333',
u'profile_use_background_image': True,
u'protected': False,
u'screen_name': u'gerardsans',
u'statuses_count': 1470,
u'time_zone': u'Greenland',
u'url': u'https://t.co/OzlOVVZNqK',
u'utc_offset': -10800,
u'verified': False}},
u'source': u'<a href="http://twitter.com"; rel="nofollow">Twitter Web
Client</a>',
u'text': u'RT @gerardsans: Slides from Asynchronous Data Streams in
Angular 2 #devfestlon @gdglondon https://t.co/NhKrNLo0og
https://t.co/jsQ5eqTYvD',
u'truncated': False,
u'user': {u'contributors_enabled': False,
u'created_at': u'Thu Jun 18 08:40:05 +0000 2009',
u'default_profile': False,
u'default_profile_image': False,
u'description': u'Web Specialist - Java and JavaScript
technologies - @ZenikaLille',
u'entities': {u'description': {u'urls': []},
u'url': {u'urls': [{u'display_url':
u'Gillespie59.github.io',
u'expanded_url':
u'http://Gillespie59.github.io',
u'indices': [0, 23],
u'url':
u'https://t.co/lWeVaL99hb'}]}},
u'favourites_count': 1596,
u'follow_request_sent': False,
u'followers_count': 865,
u'following': False,
u'friends_count': 1448,
u'geo_enabled': True,
u'has_extended_profile': True,
u'id': 48291605,
u'id_str': u'48291605',
u'is_translation_enabled': False,
u'is_translator': False,
u'lang': u'fr',
u'listed_count': 131,
u'location': u'Lille - France',
u'name': u'Emmanuel DEMEY',
u'notifications': False,
u'profile_background_color': u'022330',
u'profile_background_image_url':
u'http://abs.twimg.com/images/themes/theme15/bg.png',
u'profile_background_image_url_https':
u'https://abs.twimg.com/images/themes/theme15/bg.png',
u'profile_background_tile': False,
u'profile_banner_url':
u'https://pbs.twimg.com/profile_banners/48291605/1427485955',
u'profile_image_url':
u'http://pbs.twimg.com/profile_images/628190699951923200/vS3yoC1K_normal.jpg',
u'profile_image_url_https':
u'https://pbs.twimg.com/profile_images/628190699951923200/vS3yoC1K_normal.jpg',
u'profile_link_color': u'0084B4',
u'profile_sidebar_border_color': u'A8C7F7',
u'profile_sidebar_fill_color': u'C0DFEC',
u'profile_text_color': u'333333',
u'profile_use_background_image': True,
u'protected': False,
u'screen_name': u'EmmanuelDemey',
u'statuses_count': 4723,
u'time_zone': u'Paris',
u'url': u'https://t.co/lWeVaL99hb',
u'utc_offset': 3600,
u'verified': False}}
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/25829>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/054.91e03b2c7a0980a0489f9d9e01b314f0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
