def testWrongCorners(self): """ Check what happens if the upper_left and lower_right corner are specified. Postgres ourght to return the upper_right and lower_left anyway. """ upper_right = GeoTypes.pointFromValues(2.0,2.0) lower_left = GeoTypes.pointFromValues(1.0,1.0) upper_left = GeoTypes.pointFromValues(1.0,2.0) lower_right = GeoTypes.pointFromValues(2.0,1.0) b = GeoTypes.boxFromPoints(upper_left,lower_right) self.curs.execute("INSERT INTO %s VALUES (%%(b)s)" % (self.tbl_name,), {'b':b}) self.curs.execute("SELECT b FROM %s" % (self.tbl_name,)) ret = self.curs.fetchall()[0] ol = ret[0] assert ol.__class__.__name__ == "Box" assert ol.getUpperRight() == upper_right assert ol.getLowerLeft() == lower_left assert ol == b, ("Broken box equallity", ol, b)
def testBox(self): upper_right = GeoTypes.pointFromValues(2.0,2.0) lower_left = GeoTypes.pointFromValues(1.0,1.0) b = GeoTypes.boxFromPoints(upper_right,lower_left) self.curs.execute("INSERT INTO %s VALUES (%%(b)s)" % (self.tbl_name,), {'b':b}) self.curs.execute("SELECT b FROM %s" % (self.tbl_name,)) ret = self.curs.fetchall()[0] ol = ret[0] assert ol.__class__.__name__ == "Box" assert ol.getUpperRight() == upper_right, "%s != %s" % (repr(ol.getUpperRight()),repr(upper_right)) assert ol.getLowerLeft() == lower_left assert ol == b