docstr: Tests that insert works with if_exists='append' when table does not exist yet.
docstr_tok: ["Tests","that","insert","works","with","if_exists='append","'","when","table","does","not","exist","yet","."]
code: def test_append_before_table_exists(self, engine_postgis, df_nybb):
      """
      Tests that insert works with if_exists='append' when table does not exist yet.
      """
      engine = engine_postgis
  
      table = "nybb"
      # If table exists, delete it before trying to write with defaults
      drop_table_if_exists(engine, table)
  
      write_postgis(df_nybb, con=engine, name=table, if_exists="append")
  
      # Check that the row order matches
      sql = text("SELECT * FROM {table};".format(table=table))
      df = read_postgis(sql, engine, 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 29 for calling the TestIO obj's underlying member method code with example usage: obj.test_append_before_table_exists(engine_postgis, df_nybb) without return types