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