Exemplo n.º 1
0
def M31RegionSQLGen():
    sql_select = "SELECT * FROM dr3.M31_Coordinate"
    sql_select_vo = "SELECT objID,ra,dec,petroMag_u,petroMag_g,petroMag_r,petroMag_i,petroMag_z FROM BestDR12.dbo.PhotoObjALl WHERE "

    conn, data = sqlHelper.getFetchMany(sql_select)
    dic_radec = util.getRaDecMap(data)

    sql_whereList = []
    for ra in dic_radec.keys():
        minDec = min(dic_radec[ra])
        maxDec = max(dic_radec[ra])
        sql_whereList.append(genSQL(ra, minDec, maxDec))

    sql_where = util.listToString(sql_whereList, "or")

    sql_select_vo += sql_where
    print sql_select_vo