BRAINSia/SlicerQAExtension — pull request #13 by reginakim (2013-06-17 16:28:55+00:00)
Title: Free surfer scan rescan review

Dave,

I have made a few fix on QA module so that it works upto 'permission' part. It seems that recordID is a number, but dealt as string (or vice versa whichever your intenstion was.)

Please review the changes and see if that was proper. For now, I got permission error and I do not know how to proceed from here.

Thank you Dave,

The error I got::::
QPixmap::scaled: Pixmap is a null pixmap
Show module (name): "DerivedImageQA"
__main__:127: DeprecationWarning: integer argument expected, got float
[(15903, u'20130613_BRAINSCut_FREESURFER', u'98727', u'/hjohnson/HDNI', u'U', 2)]
(15903, u'20130613_BRAINSCut_FREESURFER', u'98727', u'/hjohnson/HDNI', u'U', 2)
0
^^^^^^^^^^^^^^^^^^^^^^^^^^^
recordID = 15903
valueString = ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
reviewTable:::::freesurfer_scanrescan_reviews
Traceback (most recent call last):
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/DerivedImageQA.py", line 252, in onGetBatchFilesClicked
self.logic.writeToDatabase(values)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/QALib/derived_images/logic.py", line 130, in writeToDatabase
self.database.writeReview(values)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/QALib/derived_images/helper.py", line 319, in writeReview
self.cursor.execute(sqlCommand, values + (self.reviewer_id,))
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/dbapi.py", line 243, in _fn
return fn(self, *args, **kwargs)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/dbapi.py", line 314, in execute
self._execute(operation, args)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/dbapi.py", line 319, in _execute
self.cursor.execute(new_query, *new_args)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/interface.py", line 304, in execute
self._stmt.execute(*args, **kwargs)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/interface.py", line 139, in execute
self._row_desc, cmd = self.c.bind(self._portal_name, self._statement_name, args, self._parse_row_desc, kwargs.get("stream"))
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/protocol.py", line 913, in _fn
return fn(self, *args, **kwargs)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/protocol.py", line 1107, in bind
return reader.handle_messages()
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/protocol.py", line 881, in handle_messages
retval = handler(msg, *args, **kwargs)
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/protocol.py", line 1146, in _bind_nodata
reader.handle_messages()
File "/Volumes/scratch/eunyokim/src/SlicerQAExtension/Resources/Python/pg8000-1.08/pg8000/protocol.py", line 886, in handle_messages
raise exc
pg8000.errors.ProgrammingError: ('ERROR', '42501', 'permission denied for sequence freesurfer_scanrescan_reviews_review_id_seq')

====