/otis/ops/src/python/ps1util.py in selectOneValue(connection=<_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 558bf4dedea0>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n ')
1964 # query via the given MySQL DB connection.
1965 def selectOneValue(connection, query):
=> 1966 return selectOneRow(connection, query)[0]
1967
1968
globalselectOneRow = <function selectOneRow>, connection = <_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 558bf4dedea0>, query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n '
/otis/ops/src/python/ps1util.py in selectOneRow(connection=<_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 558bf4dedea0>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n ')
1957 if selectCursor.rowcount != 1:
1958 raise RuntimeError("selectOneRow(%s) resulted in %d rows!" %
=> 1959 (query, selectCursor.rowcount))
1960 return selectCursor.fetchone()
1961
query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n ', selectCursor = <MySQLdb.cursors.Cursor object>, selectCursor.rowcount = 0L
<type 'exceptions.RuntimeError'>: selectOneRow(
SELECT SUBSTR(name, 1, 10)
FROM colorAllSkyCameraImages
WHERE time = 1594305988
) resulted in 0 rows!
args =
('selectOneRow(\n SELECT SUBSTR(name, 1...me = 1594305988\n ) resulted in 0 rows!',)
message =
'selectOneRow(\n SELECT SUBSTR(name, 1...me = 1594305988\n ) resulted in 0 rows!'