def sql(self):
context = Context(namespace=Names.Update)
context.varTableName = self.model.Name
def gene():
nonlocal context
assert len(self._fields)
if self._where:
context.varWhereExpr = str(self._where)
for field, expr in self._fields:
c = Context(namespace=Names.Update.ColumnsLevel)
c.varColumnName = field.Name
c.varColumnUpdateExpr = expr
context.level(c)
return self.builder.build(context)
if self._instances:
for model_inst in self._instances:
if not self.only_fields:
self._fields = list(zip(self.model, model_inst.storage_values()))
else:
self._fields = [(x, model_inst.storage_value(x)) for x in self.only_fields]
value = model_inst.value(self.model.PrimaryKey())
assert value != None, "Не указано значение первичного ключа для обновления!"
self._where = self.model.PrimaryKey() == value
yield gene()
else:
yield gene()
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)
def sql(self):
context = Context(namespace=Names.Delete)
assert self._where
context.varTableName = self.model.Name
context.varWhereExpr = str(self._where)
return self.builder.build(context)
