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()
