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