ManyToManyBizobjExample: Base.py

# -*- coding: utf-8 -*-

from dabo.lib import getRandomUUID
import dabo.lib.datanav2 as datanav

class Base(datanav.Bizobj):

    def afterInit(self):
        self.super()
        self.setBaseSQL()


    def initProperties(self):
        self.AutoQuoteNames = False
        self.AutoPopulatePK = False
        self.DefaultValues["id"] = getRandomUUID
        self.SaveNewUnchanged = True


    def afterSave(self):
        self.fillDerivedFields()


    def fillDerivedFields(self):
        """Hook for subclasses."""
        pass


    def setBaseSQL(self):
        self.setLimitClause(2000)
        pass


    def addFieldsFromDataStructure(self):
        max_fill = 0
        for field in self.DataStructure:
            if field[3] is not None:
                fill = len("%s.%s" % (field[3], field[4]))
                max_fill = max(max_fill, fill)
        for field in self.DataStructure:
            fill = " " * (max_fill - len("%s.%s" % (field[3], field[4])))
            if field[3] is not None:
                self.addField("%s.%s %sas %s" % (field[3], field[4], fill, field[0]))