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 = ""