Method insert_data

database/SQliteDB.py:196–218

(self, tablename, data, columns=None)

                self._execute(sentence)
                
    def insert_data(self, tablename, data, columns=None):
        exists = self._check_exists(tablename, self._hashcolumn, data[-1])
        if  exists == False:
            columns = self._get_columns(tablename)
            hash_column = columns.pop(0)
            columns.append(hash_column)
            columns_insert=''
            parameters = ''
            
            for index, c in enumerate(columns):
                columns_insert+=f'"{c.lower()}"'
                if index != len(columns)-1:
                    columns_insert+=','
            
            for index, _ in enumerate(data):
                parameters+="?"
                if index != len(data)-1:
                    parameters+=","

            sentence=f"""    
                        INSERT INTO {tablename} ({columns_insert})
                        VALUES ({parameters})"""
            self._execute(sentence, data)

    def _get_insert_sentence(self, tablename, data, columns=None):
        if columns is None: