docstr: Tests that GeoDataFrame can be written to PostGIS with defaults.
docstr_tok: ["Tests","that","GeoDataFrame","can","be","written","to","PostGIS","with","defaults","."]
code: def test_write_postgis_sqlalchemy_connection(
      self, engine_postgis, df_nybb
  ):
      """Tests that GeoDataFrame can be written to PostGIS with defaults."""
      with engine_postgis.begin() as con:
          table = "nybb_con"
  
          # If table exists, delete it before trying to write with defaults
          drop_table_if_exists(con, table)
  
          # Write to db
          write_postgis(df_nybb, con=con, name=table, if_exists="fail")
          # Validate
          sql = text("SELECT * FROM {table};".format(table=table))
          df = read_postgis(sql, con, geom_col="geometry")
          validate_boro_df(df)
  
imports: import os
  import warnings
  import pandas
  import geopandas
  from geopandas import GeoDataFrame, read_file, read_postgis
  import geopandas._compat
  from geopandas.io.sql import _get_conn, _write_postgis
  from geopandas.tests.util import create_postgis, create_spatialite, validate_boro_df
  import pytest
label_desc: Use image node_id 15 for calling the TestIO obj's underlying member method code with example usage: obj.test_write_postgis_sqlalchemy_connection(engine_postgis, df_nybb) without return types