Bulket insert data to MySQL by python

bulket.py

#coding=utf8

import MySQLdb


class Connectdb():

    def __init__(self):
        self._conn = MySQLdb.connect("localhost", "root", "letmein",
                                     "db_test", charset="utf8")

    def __enter__(self):
        return self._conn

    def __exit__(self, exc_type, exc_val, exc_tb):
        self._conn.close()


def connectdb():
    return Connectdb()


if __name__ == '__main__':
    with connectdb() as conn:
        cursor = conn.cursor()
        cursor.execute("SELECT VERSION()")
        data = cursor.fetchone()
        print("Database version : %s " % data)

        # Insert data
        sql = "insert into t_limit(val, source) values(%s, %s)"
        for j in xrange(50):
            param = []
            for i in xrange(100000):
                param.append((i, i))

            try:
                cursor.executemany(sql, param)
                conn.commit()
                print("batch %s done" % j)
            except:
                conn.rollback()