def runTest():
field_count = 100
db = wgdb.attach_database("1", 1073741824);
for x in range(0, 680000):
record = wgdb.create_record(db, field_count)
for j in range(0,field_count):
wgdb.set_field(db, record, j, j)
wgdb.detach_database(db);
wgdb.delete_database("1");
count += 1
try:
record = wgdb.get_next_record(db, record);
except wgdb.error:
record = None
db = wgdb.attach_database("1", 1073741824);
with open('../worldcitiespop.txt', 'rb') as csvfile:
reader = csv.reader(csvfile, delimiter=',', quotechar='|')
firstRow = True
for row in reader:
if firstRow:
firstRow = False
continue
record = wgdb.create_record(db, 5)
wgdb.set_field(db, record, 0, row[0])
wgdb.set_field(db, record, 1, row[1])
wgdb.set_field(db, record, 2, row[2])
wgdb.set_field(db, record, 3, row[3])
wgdb.set_field(db, record, 4, row[4])
for i in range(0,20):
start = time.clock();
runTest();
print time.clock() - start
wgdb.detach_database(db);
wgdb.delete_database("1");
def close(self):
"""Close the connection."""
if self._db:
wgdb.detach_database(self._db)
self._db = None
def tearDown(self):
wgdb.detach_database(self.d)
def _close(self):
wgdb.detach_database(self.db)
self.ready = False
self.name = ""
