def get_opsimValues(opsim, offset=0, drows=nobs):
conn, cursor = ui.sqlConnect()
query = 'select fieldRA*180/PI(), fieldDec*180/PI(), expmjd, filter, altitude*180/PI(), azimuth*180/PI(), airmass, xparency, seeing, sunAlt*180/PI(), sunAz*180/PI(), MoonAlt*180/PI(), moonPhase, moonIllum, skybrightness_modified, 5sigma_modified from %s group by expmjd' %(opsim)
results = ui.sqlQueryLimited(cursor, query, offset=offset, drows=drows)
keys = ('ra', 'dec', 'expmjd', 'filter', 'alt', 'az', 'airmass', 'cloud', 'seeing', 'sunalt', 'sunaz', 'moonalt', 'moonphase', 'moonillum',
'skybright', 'maglimit')
opsimdata = ui.assignResults(results, keys)
ui.sqlEndConnect(conn, cursor)
return opsimdata
def get_opsimObs_inputs(opsim, offset=0, drows=nobs):
conn, cursor = ui.sqlConnect()
query = 'select fieldRA*180/PI(), fieldDec*180/PI(), expmjd, filter, exptime from %s group by expmjd' %(opsim)
results = ui.sqlQueryLimited(cursor, query, offset=offset, drows=drows)
keys = ('ra', 'dec', 'expmjd', 'filter', 'exptime')
keytypes = ('float', 'float', 'float', 'str', 'int')
data = ui.assignResults(results, keys)
ui.writeDatafile('test_%s' %(opsim), data, keys)
ui.sqlEndConnect(conn, cursor)
return
def get_opsimValues(opsim, offset=0, drows=nobs):
conn, cursor = ui.sqlConnect()
query = 'select fieldRA*180/PI(), fieldDec*180/PI(), expmjd, filter, altitude*180/PI(), azimuth*180/PI(), airmass, xparency, seeing, sunAlt*180/PI(), sunAz*180/PI(), MoonAlt*180/PI(), moonPhase, moonIllum, skybrightness_modified, 5sigma_modified from %s group by expmjd' % (
opsim)
results = ui.sqlQueryLimited(cursor, query, offset=offset, drows=drows)
keys = ('ra', 'dec', 'expmjd', 'filter', 'alt', 'az', 'airmass', 'cloud',
'seeing', 'sunalt', 'sunaz', 'moonalt', 'moonphase', 'moonillum',
'skybright', 'maglimit')
opsimdata = ui.assignResults(results, keys)
ui.sqlEndConnect(conn, cursor)
return opsimdata
def get_opsimObs_inputs(opsim, offset=0, drows=nobs):
conn, cursor = ui.sqlConnect()
query = 'select fieldRA*180/PI(), fieldDec*180/PI(), expmjd, filter, exptime from %s group by expmjd' % (
opsim)
results = ui.sqlQueryLimited(cursor, query, offset=offset, drows=drows)
keys = ('ra', 'dec', 'expmjd', 'filter', 'exptime')
keytypes = ('float', 'float', 'float', 'str', 'int')
data = ui.assignResults(results, keys)
ui.writeDatafile('test_%s' % (opsim), data, keys)
ui.sqlEndConnect(conn, cursor)
return
