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)