Method create_columns

database/SQliteDB.py:187–194

(self, tablename:str, columns)

            self.create_columns(name, columns)
    
    def create_columns(self, tablename:str, columns):
        if self._hashcolumn not in columns:
            columns.append(self._hashcolumn)

        for _,column in enumerate(columns):
            if not self._check_exists_column(tablename, column):
                sentence = f"ALTER TABLE {tablename} ADD COLUMN [{column.lower()}] TEXT"
                self._execute(sentence)
                
    def insert_data(self, tablename, data, columns=None):
        exists = self._check_exists(tablename, self._hashcolumn, data[-1])