def sql(self):
table = self.model.Name
context = Context(namespace=Names.Select)
context.varSelectTable = table
if self._where:
context.varWhereExpr = str(self._where)
if self._fields:
names = [f.name for f in self._fields]
for name in names:
c = Context(namespace=Names.Select.ColumnsLevel)
c.varTableName = table
c.varColumnName = name
context.level(c)
return self.builder.build(context)
def sql(self):
context = Context(namespace=Names.Insert)
context.varTableName = self.model.Name
for instance in self.models:
for name, value in instance.storage_items():
c = Context(namespace=Names.Insert.ValuesLevel)
c.varValue = value
field = instance[name]
for feature in field.features:
feature.insertHook(self, instance, field , c)
context.level(c)
yield self.builder.build(context)
def sql(self):
context = Context(namespace=Names.Create)
context.varTableName = self.model.Name
for field in self.model:
context.level(self.field(self.model, field))
return self.builder.build(context)
