Example #1
0
    def time_to_work(self):

        now = datetime.now()

        if now.weekday() not in [0, 1, 2, 3, 4]:
            raise Exception("Today it's Saturnday or Sunday")

        template = "SELECT date FROM ticker WHERE date == '{today}'"
        context = {'today': now.strftime("%Y-%m-%d")}
        query = template.format(**context)

        dbr = DbReader(self.model)
        result = dbr.select(query)

        if result:
            raise Exception("The Robot already fetched the ticker")

        return True
Example #2
0
    def time_to_work(self):

        now = datetime.now()

        if now.weekday() not in [0, 1, 2, 3, 4]:
            raise Exception("Today it's Saturnday or Sunday")

        template = "SELECT date FROM ticker WHERE date == '{today}'"
        context = { 'today': now.strftime("%Y-%m-%d") }
        query = template.format(**context)

        dbr = DbReader(self.model)
        result = dbr.select(query)

        if result:
            raise Exception("The Robot already fetched the ticker")

        return True
Example #3
0
 def not_measured_yet(self):
     dbr = DbReader(self.model)
     query = "SELECT pk, future_date, price FROM prediction"\
         " as t WHERE t.pk NOT IN (SELECT fk FROM truth);"
     qs = dbr.select(query)
     return qs
Example #4
0
 def not_measured_yet(self):
     dbr = DbReader(self.model)
     query = "SELECT pk, future_date, price FROM prediction"\
         " as t WHERE t.pk NOT IN (SELECT fk FROM truth);"
     qs = dbr.select(query)
     return qs