def commitToDatabase(self): """ This method should commit the calls to the database. """ my_args = (self.date, self.TotalCalls, self.sub50, self.sub100, self.sub200, self.sub300, self.sub400, self.sub2000, self.sub5000, self.sub8000, self.plus8000) try: new_row = dbSetup.StatLogSCP1(my_args) session = dbSetup.initdb() session.add(new_row) session.commit() print "Commit" except SQLAlchemyError as error: print error finally: return
def checkInDatabase(self): """ This method should commit the calls to the database. """ my_args = (self.date) try: new_row = dbSetup.StatLogSCP1(my_args) session = dbSetup.initdb() getrow = session.query(dbSetup.StatLogSCP1).filter(dbSetup.StatLogSCP1.date == my_args).one() if getrow.date: #date = datetime.strftime(getrow[0], time_format) date = getrow.date.strftime(time_format) if (date == self.date): self.inDB = True except SQLAlchemyError as error: print error finally: return
def checkInDatabase(self): """ This method should commit the calls to the database. """ my_args = (self.date) try: new_row = dbSetup.StatLogSCP1(my_args) session = dbSetup.initdb() getrow = session.query(dbSetup.StatLogSCP1).filter( dbSetup.StatLogSCP1.date == my_args).one() if getrow.date: #date = datetime.strftime(getrow[0], time_format) date = getrow.date.strftime(time_format) if (date == self.date): self.inDB = True except SQLAlchemyError as error: print error finally: return