def db_pair_test(): print 'create database with capacity 100000 test is started..\n' open(os.getcwd() + '/storage/student.txt', 'wb').close() db = Table(filename=os.getcwd() + '/storage/student.txt', type=student, index_attrs=['name'], key_sizes=[26]) # studs = get_shuffled_dataset() print('loading dataset') pairs = [] size = 1000 for i in range(size): p = pair(id=i, id1=i, id2=i) pairs.append(p) i = 0 for p in pairs: with Profiler() as p: db.put(p.get_key(), p) i += 1 if i % 50 == 0: print('#', i) # print(db.get('581200', 1)) # print(db.trees['name']['Matthew Cervantes']) db.save()
def db_test(): print 'create database with capacity 100000 test is started..\n' open(os.getcwd() + '/storage/student.txt', 'wb').close() open(os.getcwd() + '/times.txt', 'wb').close() db = Table(filename=os.getcwd() + '/storage/student.txt', type=student, index_attrs=['name'], key_sizes=[26]) # studs = get_shuffled_dataset() print('loading dataset') studs = get_shuffled_million() i = 0 for stud in studs[:10000]: with Profiler() as p: db.put(stud.get_key(), stud) i += 1 if i % 50 == 0: print('#', i) db.b_index() for index in db.index_attrs: tree = db.trees[index] # print(db.get('581200', 1)) # print(db.trees['name']['Matthew Cervantes']) db.save()
def __init__(self, applicationWindow): """ @type applicationWindow: MainApplicationWindow """ self.applicationWindow = applicationWindow self.tableTab = applicationWindow.mainWindow.tableTab self.table = Table("", None) # Set this to True when programmatically manipulating the columns table # to prevent GUI events from causing sync issues with our columns self.lockCellChanges = False self.previousState = None mainWindow = applicationWindow.mainWindow mainWindow.addColumnButton.clicked.connect(self.addNewRow) mainWindow.removeColumnButton.clicked.connect( self.removeCurrentColumnRow) mainWindow.moveColumnDownButton.clicked.connect( self.moveCurrentColumnDown) mainWindow.moveColumnUpButton.clicked.connect(self.moveCurrentColumnUp) mainWindow.discardTableButton.clicked.connect(self.discardChanges) mainWindow.saveTableButton.clicked.connect(self.saveChanges) mainWindow.tableName.textEdited.connect(self.nameEdited) mainWindow.tableInfoTable.itemSelectionChanged.connect( self.selectedColumnChanged)
def cursor_test(): from database.cursor import cursor db = Table(type=student, from_dump=True) c = cursor(db=db, filename=db.filename) # c = select_cursor(db=db,filename=db.filename, on_field='name', greater_than=None, less_than="B") # c = project_cursor(db=db,filename=db.filename, fields=['name', 'email'], ordered_on='name') c = select_cursor(filename=db.filename, on_field='name', greater_than='G', less_than='K', on_cursor=c) while c.has_next(): print c.next()
def db_load_test(): print 'load test is started..\n' db = Table(type=student, from_dump=True) # print student(db.get('581200', 1)).attrs print 'test get student with id = 581200..\n' print(student(to_parse=db.get('581200', 1))) print 'test neighbours of Matthew Cervantes..\n' nbrs = db.neighbours('name', 'Matthew Cervantes', 10) for nbr in nbrs: print nbr.attrs print 'test update Matthew Cervantes to Kamil..\n' print(student(to_parse=db.get('581200', 1)).attrs) db.update('581200', 1, {'name': 'Kamil'}) print(student(to_parse=db.get('581200', 1)).attrs) print 'test remove Kamil by his id..\n' db.remove('581200', 1) if db.get('581200', 1) == None: print('Kamil is removed!')
def load_author_names(): conn = psycopg2.connect( "dbname='citadel' user='******' host='localhost' password=''") cur = conn.cursor() cur.execute("select * from author_names") rows = cur.fetchall() print("\nShow me the databases:\n") from relations.edges import edge open(os.getcwd() + '/storage/edge.txt', 'wb').close() db = Table(filename=os.getcwd() + '/storage/author_names.txt', type=edge, index_attrs=['name'], key_sizes=[26]) i = 1 for row in rows: el = author_name(id=row[0], name=row[1]) db.put(el.get_key(), el) i += 1 if i % 1000 == 0: print("i=", i) print("storing records is done, b_index started..") db.b_index() db.save() print("database created and saved")
def setUp(self): self.R = Table() self.R1 = Table() self.S = Table()
def add_to_database(self, types): self.db.add_table(Table(type=types, from_dump=True))