Why is data not being written to SQlite?

Question

Python

def add_randcode(self, code):
        with self.connection:
            code = self.cursor.execute("SELECT * FROM `subscriptions` WHERE `code` = ?", (code, )).fetchone()
            if code == None:
                code = random.randint(1000,9999)
                self.cursor.execute("""INSERT INTO subscriptions(code) 
                VALUES (?)""", (code, ))
                return code
            else:
                return code

Good day, SQL syntax does not work, SELECT always returns None, and INSERT does not write anything to the database

Answer 1

Why duplicate the question? They answered you there, you need to make a commit
self.connection.commit()