def drop_table(tname):
catalog.init_catalog()
catalog.exist_table(tname, False)
index.delete_table(tname)
catalog.delete_table(tname)
record.delete_table(tname)
catalog.finalize()
def delete_tuple(tname, condition):
catalog.init_catalog()
catalog.exist_table(tname, False)
clause = extract_condition(condition)
length = catalog.get_length(tname)
index_name = catalog.get_column_with_index(tname)
where = record.delete_record(tname, clause, length)
index.delete_entries(where, tname, index_name)
catalog.finalize()
def select(table, condition):
catalog.init_catalog()
catalog.exist_table(table, False)
clause = extract_condition(condition)
attr_list = catalog.get_column_name(table)
length = catalog.get_length(table)
index_name = catalog.get_column_with_index(table)
where = index.select_from_table(table, clause, index_name)
list_res = record.select_record(table, attr_list, clause, where, length)
catalog.finalize()
return list_res
def insert(tname, values):
catalog.init_catalog()
catalog.exist_table(tname, False)
catalog.check_type(tname, values)
index_name = catalog.get_column_with_index(tname)
idx = catalog.get_index_of_attribute(tname, index_name)
key = []
for dxtemp in idx:
key.append(values[dxtemp])
index.insert_entry(tname, index_name, key, values)
record.insert(tname, values)
catalog.finalize()
def create_table(name, attribute, PK):
catalog.init_catalog()
catalog.exist_table(name, True)
pidx = [x[0] for x in attribute].index(PK)
if len(attribute[pidx]) != 5 or attribute[pidx][-1] != 1:
raise Exception('Primary key is not a unique attribute!')
catalog.create_table(name, attribute, PK)
record.create_table(name)
index.create_table(name, PK)
for x in attribute:
if PK not in x and len(x) == 5 and x[-1] == 1:
index.create_index(name, 'Uni_' + x[0], x[0])
catalog.finalize()
def create_index(tname, iname, iattr):
catalog.init_catalog()
catalog.exist_index(tname, iname, True)
index.create_index(tname, iname, iattr)
catalog.create_index(tname, iname, iattr)
catalog.finalize()
def drop_index(iname):
catalog.init_catalog()
catalog.exist_index(iname, False)
catalog.delete_index(iname)
index.delete_index(iname)
catalog.finalize()
def finalize_all():
index.finalize_index()
catalog.finalize()
record.finalize()