Re: [Tutor] Runtime error while Test data creation

2011-10-08 Thread Steven D'Aprano
Guess?!? wrote: Hello all, I am trying to create some test data for a search module that I am building. Since I dont want to hit performance related issues late in the game, I decided to create half a million records in the DB. My approach is create a csv file with valid UUIDs which I already h

Re: [Tutor] Runtime error while Test data creation

2011-10-08 Thread Alan Gauld
On 07/10/11 22:32, Guess?!? wrote: Thanks for the suggestions. There is no traceback/stacktrace errors that I can see The key is the last phrase. Your GUI IDE is hiding it. If you run your program from an Operating Command prompt then you should see the full error stack trace which (usually)

Re: [Tutor] Runtime error while Test data creation

2011-10-07 Thread bob gailer
On 10/7/2011 5:32 PM, Guess?!? wrote: A couple of suggestion below (inline with the code): import pyodbc, random, datetime, uuid #INT conn = pyodbc.connect('DRIVER={SQL Server};SERVER=SERVERNAME\INT_FOUNDATIONS;DATABASE=membership_service;UID=int_usr;PWD=blah') c = conn

Re: [Tutor] Runtime error while Test data creation

2011-10-07 Thread bob gailer
On 10/7/2011 5:32 PM, Guess?!? wrote: Hey Bob, Thanks for the suggestions. There is no traceback/stacktrace errors that I can see (may be there is a file that is generated in python or windows directory due to run time failure but I am not able to locate it. Please let me know if you know).

Re: [Tutor] Runtime error while Test data creation

2011-10-07 Thread Prasad, Ramit
From: tutor-bounces+ramit.prasad=jpmorgan@python.org [mailto:tutor-bounces+ramit.prasad=jpmorgan@python.org] On Behalf Of Guess?!? Sent: Friday, October 07, 2011 4:32 PM To: bob gailer Cc: tutor@python.org Subject: Re: [Tutor] Runtime error while Test data creation Hey Bob, Thanks for

Re: [Tutor] Runtime error while Test data creation

2011-10-07 Thread Guess?!?
Hey Bob, Thanks for the suggestions. There is no traceback/stacktrace errors that I can see (may be there is a file that is generated in python or windows directory due to run time failure but I am not able to locate it. Please let me know if you know). The run time error pops up in a windows dia

Re: [Tutor] Runtime error while Test data creation

2011-10-07 Thread bob gailer
On 10/7/2011 2:19 PM, Guess?!? wrote: Hello all, I am trying to create some test data for a search module that I am building. Since I dont want to hit performance related issues late in the game, I decided to create half a million records in the DB. My approach is create a csv file with vali

[Tutor] Runtime error while Test data creation

2011-10-07 Thread Guess?!?
Hello all, I am trying to create some test data for a search module that I am building. Since I dont want to hit performance related issues late in the game, I decided to create half a million records in the DB. My approach is create a csv file with valid UUIDs which I already have. Read each rec