René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Fetch with as_dict=True raises a confusing error when the attribute list is specified.","articleBody":"When using fetch(1), as_dict works only in certain cases. Some examples:\r\n\r\n```\r\nIn [73]: reso.schema.jobs\r\nOut[73]: \r\n*table_name    *key_hash      status       error_message  user           host           pid      connection_id  timestamp      key        error_stack   \r\n+------------+ +------------+ +----------+ +------------+ +------------+ +------------+ +------+ +------------+ +------------+ +--------+ +------------+\r\n__segmentation 30fff7922ea185 reserved                    ecobost@10.28. d6f4e9bc8ab8   2482     1221199        2017-11-13 21: \u003cBLOB\u003e     \u003cBLOB\u003e        \r\n (1 tuples)\r\n\r\nIn [74]: reso.schema.jobs.fetch1(as_dict=True)\r\nOut[74]: \r\nOrderedDict([('table_name', '__segmentation'),\r\n             ('key_hash', '30fff7922ea18543ea1f298418673640'),\r\n             ('status', 'reserved'),\r\n             ('key', rec.array([(1, 1, 1, 3, 3, 10577, 1)], \r\n                        dtype=[('scan_idx', 'O'), ('channel', 'O'), ('session', 'O'), ('segmentation_method', 'O'), ('field', 'O'), ('animal_id', 'O'), ('pipe_version', 'O')])),\r\n             ('error_message', ''),\r\n             ('error_stack', None),\r\n             ('user', 'ecobost@10.28.2.115'),\r\n             ('host', 'd6f4e9bc8ab8'),\r\n             ('pid', 2482),\r\n             ('connection_id', 1221199),\r\n             ('timestamp', datetime.datetime(2017, 11, 13, 21, 51, 5))])\r\n\r\nIn [75]: reso.schema.jobs.fetch1('status', 'pid')\r\nOut[75]: ('reserved', 2482)\r\n\r\nIn [76]: reso.schema.jobs.fetch1('status', 'pid', as_dict=True) # does not return a dict\r\nOut[76]: ('reserved', 2482)\r\n\r\nIn [77]: type(_)\r\nOut[77]: tuple\r\n```\r\n\r\nAnd with fetch, it just fails\r\n```\r\nIn [86]: reso.schema.jobs.fetch('status', 'pid')\r\nOut[86]: [array(['reserved'], dtype=object), array([2482])]\r\n\r\nIn [88]: reso.schema.jobs.fetch('status', 'pid', as_dict=True)\r\n---------------------------------------------------------------------------\r\nTypeError                                 Traceback (most recent call last)\r\n\u003cipython-input-79-e0ee9a14edc6\u003e in \u003cmodule\u003e()\r\n----\u003e 1 reso.schema.jobs.fetch('status', 'pid', as_dict=True)\r\n\r\n/usr/local/lib/python3.5/dist-packages/datajoint/fetch.py in __call__(self, *attrs, **kwargs)\r\n    208                 list(to_dicts(result[self._relation.primary_key]))\r\n    209                 if attribute is PRIMARY_KEY else result[attribute]\r\n--\u003e 210                 for attribute in attrs]\r\n    211             ret = return_values[0] if len(attrs) == 1 else return_values\r\n    212 \r\n\r\n/usr/local/lib/python3.5/dist-packages/datajoint/fetch.py in \u003clistcomp\u003e(.0)\r\n    208                 list(to_dicts(result[self._relation.primary_key]))\r\n    209                 if attribute is PRIMARY_KEY else result[attribute]\r\n--\u003e 210                 for attribute in attrs]\r\n    211             ret = return_values[0] if len(attrs) == 1 else return_values\r\n    212 \r\n\r\nTypeError: list indices must be integers or slices, not str\r\n```","author":{"url":"https://github.com/ecobost","@type":"Person","name":"ecobost"},"datePublished":"2017-11-14T04:42:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/391/datajoint-python/issues/391"}