Load Testing with Iron Python

import clr
clr.AddReference('System.Data')

from System import DateTime, Random
from System.Timers import Timer
from System.Threading import Thread
import System.Data.SqlClient as client

connStr = "Data Source=.\SQL2008;Initial Catalog=MyDB;Integrated Security=True"

digits = '0123456789'
letters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
digitsAndLetter = digits + letters

def replaceIf(value, badValue, replacingValue):
    return value if value != badValue else replacingValue

def generateRandomString(length, source):
    rnd = Random(DateTime.Now.Second)
    return ''.join([source[rnd.Next(len(source))] for i in range(length)])

def generateOrderInfo():
    rnd = Random(DateTime.Now.Second)
    return {
        '[COL1]': generateRandomString(255, digitsAndLetter),
        '[COL2]': generateRandomString(255, digitsAndLetter),
        '[COL3]': generateRandomString(rnd.Next(255), letters),
        '[COL4]': generateRandomString(255, digitsAndLetter),
        '[COL5]': replaceIf(rnd.Next(100), 0, 3),
    }

def insertInfo(conn, info):
    with conn.CreateCommand() as comm:
        comm.CommandText =  '''
            INSERT INTO [Table]({0})
            VALUES({1})'''.format(
                ','.join([k for k in info.keys()]),
                ','.join(["'{0}'".format(v) for v in info.values()]))
        comm.ExecuteNonQuery()

def onTimedEvent(source, e):
    rnd = Random(DateTime.Now.Second)

    with client.SqlConnection(connStr) as conn:
        conn.Open()
        for i in range(rnd.Next(5)):
            insertInfo(conn, generateOrderInfo())
        conn.Close()

    source.Interval = replaceIf(rnd.Next(15), 0, 15)
    source.Start()

if __name__ == '__main__':
    timer = Timer(1)
    timer.Elapsed += onTimedEvent
    timer.AutoReset = False
    timer.Start()
    while True:
        Thread.Sleep(300)