<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 10/7/2011 5:32 PM, Guess?!? wrote:<br>
<br>
A couple of suggestion below (inline with the code):<br>
<blockquote
cite="mid:CAEc=J6kvyqA7a7fFZhFnji2VUwzj=Jim9ozcjbcNnSs0g3VH0A@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#FFFFFF" text="#000000">
<blockquote type="cite">
<div>
<div class="h5">
<div>
<div>import pyodbc, random, datetime, uuid</div>
<div> <br>
</div>
<div>#INT</div>
<div>conn = pyodbc.connect('DRIVER={SQL
Server};SERVER=SERVERNAME\INT_FOUNDATIONS;DATABASE=membership_service;UID=int_usr;PWD=blah')</div>
<div><br>
</div>
<div><br>
</div>
<div>c = conn.cursor()</div>
<div><br>
</div>
<div># "enterprise_person_id" TEXT NOT NULL,</div>
<div><br>
</div>
<div># read file</div>
<div>f =
open('C:\\Users\\garora\\Desktop\\INTPPLHALFMIL.csv','r')</div>
<div><br>
</div>
<div># Hardcoded valid seed values</div>
<div><br>
</div>
<div># INT</div>
<div>programId = 50801 </div>
<div>packageId = 46101</div>
<div>pkg_optionId = 40301</div>
<div><br>
</div>
<div><br>
</div>
<div>seed_data = "TEST_DATA"</div>
<div><br>
</div>
<div>numberPrePend = "AAAA-"</div>
<div><br>
</div>
<div>create_dt = datetime.datetime.now();</div>
<div>modified_dt = datetime.datetime.now();</div>
<div><br>
</div>
<div>i = 0</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
f.readline() # to dispense with first line<br>
<blockquote
cite="mid:CAEc=J6kvyqA7a7fFZhFnji2VUwzj=Jim9ozcjbcNnSs0g3VH0A@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#FFFFFF" text="#000000">
<blockquote type="cite">
<div>
<div class="h5">
<div>
<div><br>
</div>
<div>for each in f:</div>
(id, entrpid,) = each.split(',')
<div> print id</div>
<div> id = id.replace('\n', '')</div>
<div> print id</div>
<div> id = uuid.UUID(id)</div>
<div> </div>
<div> </div>
<div> #enterprise_person_id</div>
<div> print entrpid</div>
<div> entrpid = entrpid.replace('\n', '')</div>
<div> print entrpid</div>
<div> entrpid = uuid.UUID(entrpid)</div>
<div> </div>
<div> </div>
<div> #random values for few columns</div>
<div> statusRandom = random.randint(1,4)</div>
<div> sourceRandom = random.randint(1,7)</div>
<div> inputChannelRandom = random.randint(1,5)</div>
<div> marketRandom= random.randint(1,10)</div>
<div> trialRandom = random.randint(0,1)</div>
<div> monthRandom = random.randint(3,12) # prevent
month of feb</div>
<div> dateRandom = random.randint(1,30) # prevent
31st on invalid month</div>
<div> yearRandom = random.randint(2007,2010)</div>
<div> member_start_dt =
datetime.datetime(yearRandom, monthRandom,
dateRandom,0,0,0)</div>
<div> current_term_start_dt =
datetime.datetime(yearRandom, monthRandom,
dateRandom,0,0,0)</div>
<div><br>
</div>
<div> print "id: " + str(i)</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
print id, i # same effect, less code. apply to following lines also<br>
<blockquote
cite="mid:CAEc=J6kvyqA7a7fFZhFnji2VUwzj=Jim9ozcjbcNnSs0g3VH0A@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div bgcolor="#FFFFFF" text="#000000">
<blockquote type="cite">
<div>
<div class="h5">
<div>
<div> print " programId: " + str(programId)</div>
<div> print " packageId: " + str(packageId)</div>
<div> print " pkgoptionId: " + str(pkg_optionId)</div>
<div> print " status id: " + str(statusRandom)</div>
<div> print " source id: " + str(sourceRandom)</div>
<div> print " input channel id: " +
str(inputChannelRandom)</div>
<div> print " market id: " + str(marketRandom)</div>
<div> print " person id: " + str(id)</div>
<div> print "membership id: " + numberPrePend +
str(i)</div>
<div> print " member_start_dt " +
str(member_start_dt)</div>
<div> print " current_term_start_dt " +
str(current_term_start_dt)</div>
<div> print " started_as_trial " + str(trialRandom)</div>
<div> print " enterprise_person_id " + str(entrpid)</div>
<div><br>
</div>
<div> record = (i, programId, packageId,
pkg_optionId, statusRandom, sourceRandom,
inputChannelRandom,</div>
<div> marketRandom, str(id), numberPrePend + str(i),
member_start_dt, current_term_start_dt,
trialRandom</div>
<div> ,seed_data, seed_data, create_dt, modified_dt,
str(entrpid))</div>
<div> </div>
<div> print record</div>
<div> </div>
<div> c.execute("""insert into Members(id,
membership_program_id, membership_package_id,</div>
<div> membership_pkg_option_id,
membership_status_id, membership_source_id,
src_input_channel_id,</div>
<div> src_market_id, person_id_ref, membership_id,
member_start_dt, current_term_start_dt,
started_as_trial,</div>
<div> created_by, modified_by, create_dt,
modified_dt, enterprise_person_id)</div>
<div> values
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)""", record)</div>
<div> conn.commit()</div>
<div> i = i + 1</div>
<div><br>
</div>
<div>c.close()</div>
</div>
<div><br>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Tutor maillist - <a moz-do-not-send="true" href="mailto:Tutor@python.org" target="_blank">Tutor@python.org</a>
To unsubscribe or change subscription options:
<a moz-do-not-send="true" href="http://mail.python.org/mailman/listinfo/tutor" target="_blank">http://mail.python.org/mailman/listinfo/tutor</a>
</pre>
</blockquote>
<font color="#888888"> <br>
<br>
<pre cols="72">--
Bob Gailer
<a moz-do-not-send="true" href="tel:919-636-4239" value="+19196364239" target="_blank">919-636-4239</a>
Chapel Hill NC</pre>
</font></div>
</blockquote>
</div>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Bob Gailer
919-636-4239
Chapel Hill NC</pre>
</body>
</html>