def __init__(self, crosserTable, crosserColumn, crosseeTable, crosseeColumn): """ Class Constructor. :param crosserTable: :param crosserColumn: :param crosseeTable: :param crosseeColumn: """ # Logger.log(logging.DEBUG, "Log Object Creation", {"scope":__name__, "arguments":" ".join({""})}) ruleTableName = "Rule %s %s Cross %s %s" % ( crosserTable, crosserColumn, crosseeTable, crosseeColumn) Rule.__init__(self, ruleTableName) if crosserTable == crosseeTable: self._selectQuery = "select r.Date, r.Code, %s as Crosser, %s as Crossee from %s r" % ( crosserColumn, crosseeColumn, crosserTable) else: self._selectQuery = "select r.Date, r.Code, r.%s as Crosser, e.%s as Crossee from %s r inner join %s e on r.Date = e.Date and r.Code = e.Code" % ( crosserColumn, crosseeColumn, crosserTable, crosseeTable) self._crosserColumn = crosserColumn self._crosseeColumn = crosseeColumn
def __init__(self, indicatorTable, indicatorColumn, relativeIndex, comparison, multiplier=1.00): """ Class Constructor. :param indicatorTable: :param indicatorColumn: :param relativeIndex: Relative Index to compare the Indicator Column e.g. -1 means previous day and -5 means five days ago :param comparison: :param multiplier: """ # Logger.log(logging.DEBUG, "Log Object Creation", {"scope":__name__, "arguments":" ".join({""})}) ruleTableName = "Rule %s %s %s %s %s" % ( indicatorTable, indicatorColumn, relativeIndex, comparison, multiplier) Rule.__init__(self, ruleTableName) self._selectQuery = "select Date, Code, %s from %s" % (indicatorColumn, indicatorTable) self._indicatorColumn = indicatorColumn self._relativeIndex = relativeIndex self._comparison = comparison self._multiplier = multiplier
def __init__(self, indicatorTable, indicatorRule): """ Class Constructor. :param ? """ # Logger.log(logging.DEBUG, "Log Object Creation", {"scope":__name__, "arguments":" ".join({""})}) ruleTableName = "Rule %s %s" % (indicatorTable, indicatorRule) Rule.__init__(self, ruleTableName) self._selectQuery = "select Date, Code, %s as Match from %s" % (indicatorRule, indicatorTable)
def __init__(self, indicatorTable1, indicatorTable2, indicatorRule): """ Class Constructor. :param ? :param ? :param indicatorRule: Columns should be prefixed with t1 and t2 """ # Logger.log(logging.DEBUG, "Log Object Creation", {"scope":__name__, "arguments":" ".join({""})}) ruleTableName = "Rule %s %s %s" % (indicatorTable1, indicatorTable2, indicatorRule) Rule.__init__(self, ruleTableName) self._selectQuery = "select t1.Date, t1.Code, %s as Match from %s t1 inner join %s t2 on t1.Date = t2.Date and t1.Code = t2.Code" % (indicatorRule, indicatorTable1, indicatorTable2)
def __init__(self, crosserTable, crosserColumn, crosseeTable, crosseeColumn): """ Class Constructor. :param crosserTable: :param crosserColumn: :param crosseeTable: :param crosseeColumn: """ # Logger.log(logging.DEBUG, "Log Object Creation", {"scope":__name__, "arguments":" ".join({""})}) ruleTableName = "Rule %s %s Cross %s %s" % (crosserTable, crosserColumn, crosseeTable, crosseeColumn) Rule.__init__(self, ruleTableName) if crosserTable == crosseeTable: self._selectQuery = "select r.Date, r.Code, %s as Crosser, %s as Crossee from %s r" % (crosserColumn, crosseeColumn, crosserTable) else: self._selectQuery = "select r.Date, r.Code, r.%s as Crosser, e.%s as Crossee from %s r inner join %s e on r.Date = e.Date and r.Code = e.Code" % (crosserColumn, crosseeColumn, crosserTable, crosseeTable) self._crosserColumn = crosserColumn self._crosseeColumn = crosseeColumn
def __init__(self, indicatorTable, indicatorColumn, relativeIndex, comparison, multiplier=1.00): """ Class Constructor. :param indicatorTable: :param indicatorColumn: :param relativeIndex: Relative Index to compare the Indicator Column e.g. -1 means previous day and -5 means five days ago :param comparison: :param multiplier: """ # Logger.log(logging.DEBUG, "Log Object Creation", {"scope":__name__, "arguments":" ".join({""})}) ruleTableName = "Rule %s %s %s %s %s" % (indicatorTable, indicatorColumn, relativeIndex, comparison, multiplier) Rule.__init__(self, ruleTableName) self._selectQuery = "select Date, Code, %s from %s" % (indicatorColumn, indicatorTable) self._indicatorColumn = indicatorColumn self._relativeIndex = relativeIndex self._comparison = comparison self._multiplier = multiplier