def create_table(self, statement1): if not isinstance(statement1, createTableStatement): raise Exception("need create table statement " +statement1) store[statement1.table.title] = statement1.table #TODO put to file return result.success()
def insert(self,statement1): if not isinstance(statement1,insertStatement): raise Exception("not insertStatement " + statement1) table = store[statement1.table] d = {} for c,v in statement1.values: d[c]=v ins = [] for i in range(len(table.columns)): v = None if isinstance(table.columns[i].datatype,string): v = d[table.columns[i].label][1:-1] elif isinstance(table.columns[i].datatype,integer): v = int(d[table.columns[i].label]) ins.append(v) ins = tuple(ins) table.data.append(ins) #TODO write to file return result.success()