Database.new_entry

Database.new_entry(table_name: str, columns: list, data: list, check_columns: bool = False)

Inserts data into a given table.

See this example for usage examples

Parameters

• table_name (str) – Name of the table where the data has to be inserted

• columns (list[str]) – List of columns names corresponding to the data

• data (list) – Values of the new data entry

• check_columns (bool, optional) – Check that columns exist before insertion, default is False

Raises

• TypeError – Invalid data

• ValueError – Invalid data

• psycopg2.Error – Base exception for all kind of database errors