Insert data into mysql, commit() does not work

Question

I wanted to enter in the database definitely. But with this code I am not able, the record is saved but does not commit():

import MySQLdb

def conn():
  try:
    db = MySQLdb.connect(host="127.0.0.1",user="root",passwd="",db="yoo")
    return db
  except:
    exit("sorry can't connect")

def insert(cur, names):
  try:
    for i in names:
      cur.execute("INSERT INTO test (person) VALUES (%s)", str(i))
    conn().commit() #write up in DB definitly
    return "success"
  except:
    return "Something went wrong with the insertion"

def main():
  conn()
  cur = conn().cursor()

  numOfNames = int(raw_input("how many names?\n"))
  names = []

  for i in range(numOfNames):
    name = raw_input("Insert a name\n")
    names.append(name)

  print insert(cur, names)

main()

Answer 1

I believe that it is because it is lost the reference of the variable being treated, try so ve se da

import MySQLdb

def conn():
  try:
    db = MySQLdb.connect(host="127.0.0.1",user="root",passwd="",db="yoo")
    return db
  except:
    exit("sorry can't connect")

def insert(db, names):
  try:
    for i in names:
      db.cursor().execute("INSERT INTO test (person) VALUES (%s)", str(i))
    db.commit() #write up in DB definitly
    return "success"
  except:
    return "Something went wrong with the insertion"

def main():
  db = conn()

  numOfNames = int(raw_input("how many names?\n"))
  names = []

  for i in range(numOfNames):
    name = raw_input("Insert a name\n")
    names.append(name)

  print insert(db, names)

main()