import MySQLdb

class database(object):
  def __init__(self):
    config = {}
    execfile("config.py",config)
    self.db = MySQLdb.connect(config["host"],config["user"],config["password"],config["database"])

  def insert(self,txt):
    dbc = self.db.cursor()
    try:
      dbc.execute("insert into " + txt)
      dbc.close()
      self.db.commit()
    except Exception as e:
      print(e)
      return False
    return True
  
  def update(self,txt):
    dbc = self.db.cursor()
    try:
      dbc.execute("update from " + txt)
      dbc.close()
      self.db.commit()
    except Exception as e:
      print(e)
      return False
    return True
   
  def select(self,txt):
    dbc = self.db.cursor()
    try:
      dbc.execute("select " + txt)
      result = dbc.fetchall()
    except Exception as e:
      print(e)
      result = None
    dbc.close()
    return result

import MySQLdb

class database(object):
  def __init__(self):
    config = {}
    execfile("config.py",config)
    self.db = MySQLdb.connect(config["host"],config["user"],config["password"],config["database"])
    self.db.autocommit(True)

  def insert(self,txt):
    dbc = self.db.cursor()
    try:
      dbc.execute("insert into " + txt)
      dbc.close()
      self.db.commit()
    except Exception as e:
      print(e)
      return False
    return True
  
  def update(self,txt):
    dbc = self.db.cursor()
    try:
      dbc.execute("update from " + txt)
      dbc.close()
      self.db.commit()
    except Exception as e:
      print(e)
      return False
    return True
   
  def select(self,txt):
    dbc = self.db.cursor()
    try:
      dbc.execute("select " + txt)
      result = dbc.fetchall()
    except Exception as e:
      print(e)
      result = None
    dbc.close()
    return result

Add autocommit to 1 to avoid select cache ¿WTF?
Add autocommit to 1 to avoid select cache ¿WTF?
