def db_table(
request,
con: redshift_connector.Connection) -> redshift_connector.Connection:
filterwarnings("ignore", "DB-API extension cursor.next()")
filterwarnings("ignore", "DB-API extension cursor.__iter__()")
con.paramstyle = "format" # type: ignore
with con.cursor() as cursor:
cursor.execute("drop table if exists book")
cursor.execute(
"create Temp table book(bookname varchar,author varchar)")
def fin() -> None:
try:
with con.cursor() as cursor:
cursor.execute("drop table if exists book")
except redshift_connector.ProgrammingError:
pass
request.addfinalizer(fin)
return con
def db_table(
request,
con: redshift_connector.Connection) -> redshift_connector.Connection:
filterwarnings("ignore", "DB-API extension cursor.next()")
filterwarnings("ignore", "DB-API extension cursor.__iter__()")
con.paramstyle = "format" # type: ignore
with con.cursor() as cursor:
cursor.execute("DROP TABLE IF EXISTS t1")
cursor.execute(
"CREATE TEMPORARY TABLE t1 (f1 int primary key, f2 bigint not null, f3 varchar(50) null) "
)
def fin() -> None:
try:
with con.cursor() as cursor:
cursor.execute("drop table if exists t1")
except redshift_connector.ProgrammingError:
pass
request.addfinalizer(fin)
return con
