import MySQLdb

class DBParameter:
    HOST_NAME = "zte.ca"
    USER_NAME = "root"
    PASSWORD = "SCxU2QnaD4"
    DB_NAME = "IV_DB"

    @staticmethod
    def runSQLByMySQL(sqlStr):
        conn = MySQLdb.connect(DBParameter.HOST_NAME, DBParameter.USER_NAME, DBParameter.PASSWORD, DBParameter.DB_NAME)

        cur = conn.cursor()
        cur.execute(sqlStr)
        
        conn.commit()
        conn.close()
        
        return
