in evalbench/databases/postgres.py [0:0]
def insert_data(self, data: dict[str, List[str]], setup: Optional[List[str]] = None):
if not data:
return
insertion_statements = []
for table_name in data:
for row in data[table_name]:
inline_columns = ", ".join([f"{value}" for value in row])
insertion_statements.append(
f"INSERT INTO public.{table_name} VALUES ({inline_columns});"
)
try:
self.batch_execute(insertion_statements)
except RuntimeError as error:
raise RuntimeError(f"Could not insert data into database: {error}")