def test_from_postgis_default(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise unittest.case.SkipTest() try: sql = "SELECT * FROM nybb;" df = GeoDataFrame.from_postgis(sql, con) finally: con.close() validate_boro_df(self, df)
def test_from_postgis_default(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = GeoDataFrame.from_postgis(sql, con) finally: con.close() validate_boro_df(df, case_sensitive=False)
def test_read_postgis_default(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con) finally: con.close() validate_boro_df(df)
def test_from_postgis_default(self): con = connect("test_geopandas") if con is None or not create_postgis(self.df): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = GeoDataFrame.from_postgis(sql, con) finally: con.close() validate_boro_df(df, case_sensitive=False)
def test_from_postgis_custom_geom_col(self): con = connect('test_geopandas') geom_col = "the_geom" if con is None or not create_postgis(self.df, geom_col=geom_col): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = GeoDataFrame.from_postgis(sql, con, geom_col=geom_col) finally: con.close() validate_boro_df(df, case_sensitive=False)
def test_read_postgis_custom_geom_col(self): con = connect('test_geopandas') geom_col = "the_geom" if con is None or not create_postgis(self.df, geom_col=geom_col): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con, geom_col=geom_col) finally: con.close() validate_boro_df(df)
def test_read_postgis_custom_geom_col(self, df_nybb): con = connect("test_geopandas") geom_col = "the_geom" if con is None or not create_postgis(df_nybb, geom_col=geom_col): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con, geom_col=geom_col) finally: con.close() validate_boro_df(df)
def test_read_postgis_default(self): con = connect('test_geopandas') if con is None or not create_postgis(self.df): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con) finally: con.close() validate_boro_df(df) # no crs defined on the created geodatabase, and none specified # by user; should not be set to 0, as from get_srid failure assert df.crs is None
def test_read_postgis_default(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise unittest.case.SkipTest() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con) finally: if PANDAS_NEW_SQL_API: # It's not really a connection, it's an engine con = con.connect() con.close() validate_boro_df(self, df)
def test_read_postgis_custom_geom_col(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise unittest.case.SkipTest() try: sql = """SELECT borocode, boroname, shape_leng, shape_area, geom AS __geometry__ FROM nybb;""" df = read_postgis(sql, con, geom_col='__geometry__') finally: con.close() validate_boro_df(self, df)
def test_from_postgis_custom_geom_col(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise pytest.skip() try: sql = """SELECT borocode, boroname, shape_leng, shape_area, geom AS __geometry__ FROM nybb;""" df = GeoDataFrame.from_postgis(sql, con, geom_col='__geometry__') finally: con.close() validate_boro_df(df, case_sensitive=False)
def test_read_postgis_default(self, df_nybb): con = connect("test_geopandas") if con is None or not create_postgis(df_nybb): raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con) finally: con.close() validate_boro_df(df) # no crs defined on the created geodatabase, and none specified # by user; should not be set to 0, as from get_srid failure assert df.crs is None
def test_read_postgis_override_srid(self, df_nybb): """Tests that a user specified CRS overrides the geodatabase SRID.""" orig_crs = df_nybb.crs created = create_postgis(df_nybb, srid=4269) con = connect("test_geopandas") if con is None or not created: raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con, crs=orig_crs) finally: con.close() validate_boro_df(df) assert df.crs == orig_crs
def test_read_postgis_select_geom_as(self, df_nybb): """Tests that a SELECT {geom} AS {some_other_geom} works.""" con = connect("test_geopandas") orig_geom = "geom" out_geom = "the_geom" if con is None or not create_postgis(df_nybb, geom_col=orig_geom): raise pytest.skip() try: sql = """SELECT borocode, boroname, shape_leng, shape_area, {} as {} FROM nybb;""".format(orig_geom, out_geom) df = read_postgis(sql, con, geom_col=out_geom) finally: con.close() validate_boro_df(df)
def test_read_postgis_override_srid(self): """Tests that a user specified CRS overrides the geodatabase SRID.""" orig_crs = self.df.crs created = create_postgis(self.df, srid=4269) con = connect('test_geopandas') if con is None or not created: raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con, crs=orig_crs) finally: con.close() validate_boro_df(df) assert(df.crs == orig_crs)
def test_read_postgis_select_geom_as(self): """Tests that a SELECT {geom} AS {some_other_geom} works.""" con = connect('test_geopandas') orig_geom = "geom" out_geom = "the_geom" if con is None or not create_postgis(self.df, geom_col=orig_geom): raise pytest.skip() try: sql = """SELECT borocode, boroname, shape_leng, shape_area, {} as {} FROM nybb;""".format(orig_geom, out_geom) df = read_postgis(sql, con, geom_col=out_geom) finally: con.close() validate_boro_df(df)
def test_read_postgis_get_srid(self, df_nybb): """Tests that an SRID can be read from a geodatabase (GH #451).""" crs = "epsg:4269" df_reproj = df_nybb.to_crs(crs) created = create_postgis(df_reproj, srid=4269) con = connect("test_geopandas") if con is None or not created: raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con) finally: con.close() validate_boro_df(df) assert df.crs == crs
def test_read_postgis_get_srid(self): """Tests that an SRID can be read from a geodatabase (GH #451).""" crs = {"init": "epsg:4269"} df_reproj = self.df.to_crs(crs) created = create_postgis(df_reproj, srid=4269) con = connect('test_geopandas') if con is None or not created: raise pytest.skip() try: sql = "SELECT * FROM nybb;" df = read_postgis(sql, con) finally: con.close() validate_boro_df(df) assert(df.crs == crs)
def test_read_postgis_custom_geom_col(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise unittest.case.SkipTest() try: sql = """SELECT borocode, boroname, shape_leng, shape_area, geom AS __geometry__ FROM nybb;""" df = read_postgis(sql, con, geom_col='__geometry__') finally: if PANDAS_NEW_SQL_API: # It's not really a connection, it's an engine con = con.connect() con.close() validate_boro_df(self, df)
def test_from_postgis_custom_geom_col(self): con = connect('test_geopandas') if con is None or not create_db(self.df): raise unittest.case.SkipTest() try: sql = """SELECT borocode, boroname, shape_leng, shape_area, geom AS __geometry__ FROM nybb;""" df = GeoDataFrame.from_postgis(sql, con, geom_col='__geometry__') finally: if PANDAS_NEW_SQL_API: # It's not really a connection, it's an engine con = con.connect() con.close() validate_boro_df(self, df)