Example #1
0
    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)
Example #2
0
    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