Method _get_insert_sentence

database/PostgreSQL.py:262–277

(self, tablename, data, columns=None)

            raise e
    
    def _get_insert_sentence(self, tablename, data, columns=None):
        if columns is None:
                columns = self._get_columns_from_table(tablename)
        elif not self._hashcolumn in columns:
            columns.append(self._hashcolumn)
        
        columns_lower = ', '.join(f'"{column.lower()}"' for column in columns)
        parameters = ','.join('%s' for _ in columns)

        sentence=f"""    
                    INSERT INTO {tablename} ({columns_lower})
                    VALUES ({parameters})
                    ON CONFLICT ({self._hashcolumn}) DO NOTHING
                """

        return sentence

    def insert_data(self, tablename, data, columns=None):
        try: