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 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
