René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error in DataLoggerFiles and DataLoggerFileColumns","articleBody":"@lsetiawan \r\n\r\nI'm trying to run a JupyterNotebook with ODM2 PythonAPI and I'm getting errors acessing DataLoggerFiles and DataLoggerFileColumns\r\nWhen I run:\r\n```\r\nfrom odm2api.ODMconnection import dbconnection\r\nimport odm2api.ODM2.services.readService as odm2\r\nfrom odm2api.ODM2.models import *\r\nsession_factory = dbconnection.createConnection('postgresql', 'x.x.x.x', 'db', \r\n                                                'user', 'pwd')\r\nDBSession = session_factory.getSession()\r\n\r\ntemplate_dataloggerfile =  DBSession.query(DataLoggerFiles).filter_by(DataLoggerFileID=9).one()\r\nprint(template_dataloggerfile)\r\n```\r\nI get:\r\n\r\n\r\n```\r\nProgrammingErrorTraceback (most recent call last)\r\n\u003cipython-input-5-3dd04b4287d7\u003e in \u003cmodule\u003e()\r\n----\u003e 1 template_dataloggerfile =  DBSession.query(DataLoggerFiles).filter_by(DataLoggerFileID=9).one()\r\n      2 print(template_dataloggerfile)\r\n      3 # dlfcs = DBSession.query(DataLoggerFileColumns).filter_by(DataLoggerFileID=9)\r\n      4 # for dlfc in dlfcs:\r\n      5 #    print(dlfc)\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in one(self)\r\n   2812         \"\"\"\r\n   2813         try:\r\n-\u003e 2814             ret = self.one_or_none()\r\n   2815         except orm_exc.MultipleResultsFound:\r\n   2816             raise orm_exc.MultipleResultsFound(\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in one_or_none(self)\r\n   2782 \r\n   2783         \"\"\"\r\n-\u003e 2784         ret = list(self)\r\n   2785 \r\n   2786         l = len(ret)\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in __iter__(self)\r\n   2853         if self._autoflush and not self._populate_existing:\r\n   2854             self.session._autoflush()\r\n-\u003e 2855         return self._execute_and_instances(context)\r\n   2856 \r\n   2857     def __str__(self):\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in _execute_and_instances(self, querycontext)\r\n   2876             close_with_result=True)\r\n   2877 \r\n-\u003e 2878         result = conn.execute(querycontext.statement, self._params)\r\n   2879         return loading.instances(querycontext.query, result, querycontext)\r\n   2880 \r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in execute(self, object, *multiparams, **params)\r\n    943             raise exc.ObjectNotExecutableError(object)\r\n    944         else:\r\n--\u003e 945             return meth(self, multiparams, params)\r\n    946 \r\n    947     def _execute_function(self, func, multiparams, params):\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/sql/elements.pyc in _execute_on_connection(self, connection, multiparams, params)\r\n    261     def _execute_on_connection(self, connection, multiparams, params):\r\n    262         if self.supports_execution:\r\n--\u003e 263             return connection._execute_clauseelement(self, multiparams, params)\r\n    264         else:\r\n    265             raise exc.ObjectNotExecutableError(self)\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_clauseelement(self, elem, multiparams, params)\r\n   1051             compiled_sql,\r\n   1052             distilled_params,\r\n-\u003e 1053             compiled_sql, distilled_params\r\n   1054         )\r\n   1055         if self._has_events or self.engine._has_events:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)\r\n   1187                 parameters,\r\n   1188                 cursor,\r\n-\u003e 1189                 context)\r\n   1190 \r\n   1191         if self._has_events or self.engine._has_events:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _handle_dbapi_exception(self, e, statement, parameters, cursor, context)\r\n   1392                 util.raise_from_cause(\r\n   1393                     sqlalchemy_exception,\r\n-\u003e 1394                     exc_info\r\n   1395                 )\r\n   1396             else:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/util/compat.pyc in raise_from_cause(exception, exc_info)\r\n    201     exc_type, exc_value, exc_tb = exc_info\r\n    202     cause = exc_value if exc_value is not exception else None\r\n--\u003e 203     reraise(type(exception), exception, tb=exc_tb, cause=cause)\r\n    204 \r\n    205 if py3k:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)\r\n   1180                         statement,\r\n   1181                         parameters,\r\n-\u003e 1182                         context)\r\n   1183         except BaseException as e:\r\n   1184             self._handle_dbapi_exception(\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/default.pyc in do_execute(self, cursor, statement, parameters, context)\r\n    468 \r\n    469     def do_execute(self, cursor, statement, parameters, context=None):\r\n--\u003e 470         cursor.execute(statement, parameters)\r\n    471 \r\n    472     def do_execute_no_params(self, cursor, statement, context=None):\r\n\r\nProgrammingError: (psycopg2.ProgrammingError) column dataloggerfiles.actionid does not exist\r\nLINE 1: ...rfileid AS odm2_dataloggerfiles_dataloggerfileid, odm2.datal...\r\n                                                             ^\r\n [SQL: 'SELECT odm2.dataloggerfiles.dataloggerfileid AS odm2_dataloggerfiles_dataloggerfileid, odm2.dataloggerfiles.actionid AS odm2_dataloggerfiles_actionid, odm2.dataloggerfiles.dataloggerfilename AS odm2_dataloggerfiles_dataloggerfilename, odm2.dataloggerfiles.dataloggeroutputfiledescription AS odm2_dataloggerfiles_dataloggeroutputfiledescription, odm2.dataloggerfiles.dataloggeroutputfilelink AS odm2_dataloggerfiles_dataloggeroutputfilelink \\nFROM odm2.dataloggerfiles \\nWHERE odm2.dataloggerfiles.dataloggerfileid = %(dataloggerfileid_1)s'] [parameters: {'dataloggerfileid_1': 9}]\r\n\r\n```\r\n\r\nWhen I then run:\r\n```\r\ndlfcs = DBSession.query(DataLoggerFileColumns).filter_by(DataLoggerFileID=9)\r\nfor dlfc in dlfcs:\r\n    print(dlfc)\r\n```\r\nI get: \r\n```\r\n\r\nProgrammingErrorTraceback (most recent call last)\r\n\u003cipython-input-12-27db1134ef98\u003e in \u003cmodule\u003e()\r\n      2 #print(template_dataloggerfile)\r\n      3 dlfcs = DBSession.query(DataLoggerFileColumns).filter_by(DataLoggerFileID=9)\r\n----\u003e 4 for dlfc in dlfcs:\r\n      5     print(dlfc)\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in __iter__(self)\r\n   2853         if self._autoflush and not self._populate_existing:\r\n   2854             self.session._autoflush()\r\n-\u003e 2855         return self._execute_and_instances(context)\r\n   2856 \r\n   2857     def __str__(self):\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/orm/query.pyc in _execute_and_instances(self, querycontext)\r\n   2876             close_with_result=True)\r\n   2877 \r\n-\u003e 2878         result = conn.execute(querycontext.statement, self._params)\r\n   2879         return loading.instances(querycontext.query, result, querycontext)\r\n   2880 \r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in execute(self, object, *multiparams, **params)\r\n    943             raise exc.ObjectNotExecutableError(object)\r\n    944         else:\r\n--\u003e 945             return meth(self, multiparams, params)\r\n    946 \r\n    947     def _execute_function(self, func, multiparams, params):\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/sql/elements.pyc in _execute_on_connection(self, connection, multiparams, params)\r\n    261     def _execute_on_connection(self, connection, multiparams, params):\r\n    262         if self.supports_execution:\r\n--\u003e 263             return connection._execute_clauseelement(self, multiparams, params)\r\n    264         else:\r\n    265             raise exc.ObjectNotExecutableError(self)\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_clauseelement(self, elem, multiparams, params)\r\n   1051             compiled_sql,\r\n   1052             distilled_params,\r\n-\u003e 1053             compiled_sql, distilled_params\r\n   1054         )\r\n   1055         if self._has_events or self.engine._has_events:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)\r\n   1187                 parameters,\r\n   1188                 cursor,\r\n-\u003e 1189                 context)\r\n   1190 \r\n   1191         if self._has_events or self.engine._has_events:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _handle_dbapi_exception(self, e, statement, parameters, cursor, context)\r\n   1392                 util.raise_from_cause(\r\n   1393                     sqlalchemy_exception,\r\n-\u003e 1394                     exc_info\r\n   1395                 )\r\n   1396             else:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/util/compat.pyc in raise_from_cause(exception, exc_info)\r\n    201     exc_type, exc_value, exc_tb = exc_info\r\n    202     cause = exc_value if exc_value is not exception else None\r\n--\u003e 203     reraise(type(exception), exception, tb=exc_tb, cause=cause)\r\n    204 \r\n    205 if py3k:\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)\r\n   1180                         statement,\r\n   1181                         parameters,\r\n-\u003e 1182                         context)\r\n   1183         except BaseException as e:\r\n   1184             self._handle_dbapi_exception(\r\n\r\n/opt/conda/envs/python2/lib/python2.7/site-packages/sqlalchemy/engine/default.pyc in do_execute(self, cursor, statement, parameters, context)\r\n    468 \r\n    469     def do_execute(self, cursor, statement, parameters, context=None):\r\n--\u003e 470         cursor.execute(statement, parameters)\r\n    471 \r\n    472     def do_execute_no_params(self, cursor, statement, context=None):\r\n\r\nProgrammingError: (psycopg2.ProgrammingError) column dataloggerfilecolumns.measurmentequation does not exist\r\nLINE 1: ... AS odm2_dataloggerfilecolumns_columndescription, odm2.datal...\r\n                                                             ^\r\nHINT:  Perhaps you meant to reference the column \"dataloggerfilecolumns.measurementequation\".\r\n [SQL: 'SELECT odm2.dataloggerfilecolumns.dataloggerfilecolumnid AS odm2_dataloggerfilecolumns_dataloggerfilecolumnid, odm2.dataloggerfilecolumns.resultid AS odm2_dataloggerfilecolumns_resultid, odm2.dataloggerfilecolumns.dataloggerfileid AS odm2_dataloggerfilecolumns_dataloggerfileid, odm2.dataloggerfilecolumns.instrumentoutputvariableid AS odm2_dataloggerfilecolumns_instrumentoutputvariableid, odm2.dataloggerfilecolumns.columnlabel AS odm2_dataloggerfilecolumns_columnlabel, odm2.dataloggerfilecolumns.columndescription AS odm2_dataloggerfilecolumns_columndescription, odm2.dataloggerfilecolumns.measurmentequation AS odm2_dataloggerfilecolumns_measurmentequation, odm2.dataloggerfilecolumns.scaninterval AS odm2_dataloggerfilecolumns_scaninterval, odm2.dataloggerfilecolumns.scanintervalunitsid AS odm2_dataloggerfilecolumns_scanintervalunitsid, odm2.dataloggerfilecolumns.recordinginterval AS odm2_dataloggerfilecolumns_recordinginterval, odm2.dataloggerfilecolumns.recordingintervalunitsid AS odm2_dataloggerfilecolumns_recordingintervalunitsid, odm2.dataloggerfilecolumns.aggregationstatisticcv AS odm2_dataloggerfilecolumns_aggregationstatisticcv \\nFROM odm2.dataloggerfilecolumns \\nWHERE odm2.dataloggerfilecolumns.dataloggerfileid = %(dataloggerfileid_1)s'] [parameters: {'dataloggerfileid_1': 9}]\r\n\r\n```\r\n\r\nIt looks like in the first one odm2.dataloggerfiles.actionid is not a column.\r\n\r\nIn the second one dataloggerfilecolumns.measurementequation is misspelled I'm trying to run this on jupyter.cuahsi.org it has odm2api v0.6.0.a0 that appears to be the latest release. I also tried setting up a new conda environment but I got the same result.  \r\n\r\n ","author":{"url":"https://github.com/miguelcleon","@type":"Person","name":"miguelcleon"},"datePublished":"2017-12-18T18:35:23.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/132/ODM2PythonAPI/issues/132"}