('mokaiaaa',)
INSERT INTO drinks ('navn') VALUES ('mokaiaaa')
Traceback (most recent call last):
  File "C:UsersRasmusworkspaceEksamensrcDatabaseConnector.py", line 60, in <module>
    d.Insert("drinks", "mokaiaaa")
  File "C:UsersRasmusworkspaceEksamensrcDatabaseConnector.py", line 17, in Insert
    cursor.execute(query)
  File "C:Anaconda3libsite-packagesmysqlconnectorcursor.py", line 515, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "C:Anaconda3libsite-packagesmysqlconnectorconnection.py", line 488, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "C:Anaconda3libsite-packagesmysqlconnectorconnection.py", line 395, in _handle_result
    raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''navn') VALUES ('mokaiaaa')' at line 1

class MysqlManager():
    def __init__(self):
        self.sqlQueries = {"drinks" : """INSERT INTO drinks ('navn') VALUES ('%s')"""}

    def Insert(self, tableName, *args):
        print(args)
        cursor, cnx = self.Connect()

        query = self.sqlQueries[tableName] % args

        print(query)

        cursor.execute(query)

        cnx.commit
        cursor.close()
        cnx.close()

    def Connect(self):
        cnx = mysql.connector.connect(user="root", password="pass", host="127.0.0.1", database="mydb")
        cursor = cnx.cursor()
        return cursor, cnx