def ModifyDescriptionOfIncome(idOfIncome, description): """Based on the ID of the Income object the description is modified in database. Parameters ---------- idOfIncome : integer Id of Income object. description : string Description of Income object. """ logs.logger.debug( "Start to modify description of Income based on the ID (%s)." % idOfIncome) try: modifiedIncome = session.query( Income.Income).filter(Income.Income.id == idOfIncome).one() modifiedIncome.description = description session.commit() logs.logger.info("Modify description of Income based on the ID (%s)." % idOfIncome) except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyCategoryOfIncome(idOfIncome, category): """Based on the ID of the Income object the category is modified in database. Parameters ---------- idOfIncome : integer Id of Income object. category : enum Category of Income object. """ logs.logger.debug( "Start to modify category of Income based on the ID (%s)." % idOfIncome) try: modifiedIncome = session.query( Income.Income).filter(Income.Income.id == idOfIncome).one() modifiedIncome.category = category session.commit() logs.logger.info("Modify category of Income based on the ID (%s)." % idOfIncome) except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyRegistrationDateOfIncome(idOfIncome, registrationDate): """Based on the ID of the Income object the registration date is modified in database. Parameters ---------- idOfIncome : integer Id of Income object. registrationDate : date Registration date of Income object. """ logs.logger.debug("Start to modify registration date of Income based\ on the ID (%s)." % idOfIncome) try: modifiedIncome = session.query( Income.Income).filter(Income.Income.id == idOfIncome).one() modifiedIncome.registrationDate = registrationDate session.commit() logs.logger.info( "Modify registration date of Income based on the ID (%s)." % idOfIncome) except Exception as e: logs.logger.error(e, exc_info=True)
def AddCost(Cost): """Add Cost object to the database. Parameters ---------- Cost : object Cost object. """ logs.logger.debug("Start to add Cost object to the database.") try: session.add(Cost) session.commit() logs.logger.info("Add Cost object to the database.") except Exception as e: logs.logger.error(e, exc_info=True)
def AddIncomes(Income): """Add Income object to the database. Parameters ---------- Income : object Income object. """ logs.logger.debug("Start to add Income object to the database.") try: session.add(Income) session.commit() logs.logger.info("Add Income object to the database.") except Exception as e: logs.logger.error(e, exc_info=True)
def InsertNewFiles(path): """Insert new file to the database Parameters ---------- session : session Manages persistence operations for ORM-mapped objects. path : string the path of the file """ logs.logger.debug("Start insert new file (%s) to the database" % path) try: newFile = File.File(path) session.add(newFile) session.commit() logs.logger.info("Insert new file (%s) to the database" % path) except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyCategoryOfCost(idOfCost, category): """Based on the ID of the Cost object the category is modified in database. Parameters ---------- idOfCost : integer Id of Cost object. category : enum Category of Cost object. """ logs.logger.debug("Start to modify category of Cost based on the ID.") try: modifiedCost = session.query(Cost.Cost).filter( Cost.Cost.id == idOfCost).one() modifiedCost.category = category session.commit() logs.logger.info("Modify category of Cost based on the ID.") except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyDescriptionOfCost(idOfCost, description): """Based on the ID of the Cost object the description is modified in database. Parameters ---------- idOfCost : integer Id of Cost object. description : string Description of Cost object. """ logs.logger.debug("Start to modify description of Cost based on the ID.") try: modifiedCost = session.query(Cost.Cost).filter( Cost.Cost.id == idOfCost).one() modifiedCost.description = description session.commit() logs.logger.info("Modify description of Cost based on the ID.") except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyAmountOfCost(idOfCost, amount): """Based on the ID of the Cost object the amount is modified in database. Parameters ---------- idOfCost : integer Id of Cost object. amount : integer Amount of Cost object. """ logs.logger.debug("Start to modify amount of Cost based on the ID.") try: modifiedCost = session.query(Cost.Cost).filter( Cost.Cost.id == idOfCost).one() modifiedCost.amount = amount session.commit() logs.logger.info("Modify amount of Cost based on the ID.") except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyTheFullRowOfCost(idOfCost, registrationDate, dateOfPayment, amount, description, category): """Based on the all given properties of Cost as parameters this method modifys the properties of Cost object in database. Parameters ---------- idOfCost : integer Id of Cost object. registrationDate : date Registration date of Cost object. dateOfPayment : date Payment date of Cost object. amount : integer Amount of Cost object. description : string Description of Cost object. category : enum Category of Cost object. """ logs.logger.debug( "Start to modify the properties of Cost object in database " "based on the all given properties of Cost.") try: modifiedCost = session.query(Cost.Cost).filter( Cost.Cost.id == idOfCost).one() modifiedCost.registrationDate = registrationDate modifiedCost.dateOfPayment = dateOfPayment modifiedCost.amount = amount modifiedCost.description = description modifiedCost.category = category session.commit() logs.logger.info( "Modify the properties of Cost object in database " "based on the all given properties of Cost.") except Exception as e: logs.logger.error(e, exc_info=True)
def DeleteIncome(idOfIncome): """Based on Id parameter of the Income object this method deletes the Income object from database. Parameters ---------- idOfIncome : integer Id of the Income object. """ logs.logger.debug("Start to deletes the Income object from database " "based on Id parameter (%s)." % idOfIncome) try: deletedIncome = session.query( Income.Income).filter(Income.Income.id == idOfIncome).one() session.delete(deletedIncome) session.commit() logs.logger.info("Deletes the Income object from database " "based on Id parameter (%s)." % idOfIncome) except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyStatusOfTheFileFromNewToOld(File): """Modify the status (new = 1, old = 0) of the file from new to old in DB. Parameters ---------- File : object File object Returns ------- File File object """ logs.logger.debug( "Modify the status (new = 1, old = 0) of the file from new to old in\ DB.") try: File.Status = 0 session.commit() return File except Exception as e: logs.logger.error(e, exc_info=True)
def DeleteCost(idOfCost): """Based on Id parameter of the Cost object this method deletes the Cost object from database. Parameters ---------- idOfCost : integer Id of the Cost object. """ logs.logger.debug( "Start to deletes the Cost object from database " "based on Id parameter.") try: deletedCost = session.query(Cost.Cost).filter( Cost.Cost.id == idOfCost).one() session.delete(deletedCost) session.commit() logs.logger.info("Deletes the Cost object from database " "based on Id parameter.") except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyRegistrationDateOfCost(idOfCost, registrationDate): """Based on the ID of the Cost object the registration date is modified in database. Parameters ---------- idOfCost : integer Id of Cost object. registrationDate : date Registration date of Cost object. """ logs.logger.debug( "Start to modify registration date of Cost based on the ID.") try: modifiedCost = session.query(Cost.Cost).filter( Cost.Cost.id == idOfCost).one() modifiedCost.registrationDate = registrationDate session.commit() logs.logger.info("Modify registration date of Cost based on the ID.") except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyAmountOfIncome(idOfIncome, amount): """Based on the ID of the Income object the amount is modified in database. Parameters ---------- idOfIncome : integer Id of Income object. amount : integer Amount of Income object. """ logs.logger.debug( "Start to modify amount of Income based on the ID (%s)." % idOfIncome) try: modifiedIncome = session.query( Income.Income).filter(Income.Income.id == idOfIncome).one() modifiedIncome.amount = amount session.commit() logs.logger.info("Modify amount of Income based on the ID (%s)." % idOfIncome) except Exception as e: logs.logger.error(e, exc_info=True)
def ModifyDateOfPaymentOfIncome(idOfIncome, dateOfPayment): """Based on the ID of the Income object the date of payment is modified in database. Parameters ---------- idOfIncome : integer Id of Income object. dateOfPayment : date Payment date of Income object. """ logs.logger.debug("Start to modify payment date of Income based on the\ ID (%s)." % idOfIncome) try: modifiedIncome = session.query( Income.Income).filter(Income.Income.id == idOfIncome).one() modifiedIncome.dateOfPayment = dateOfPayment session.commit() logs.logger.info("Modify payment date of Income based on the ID(%s)." % idOfIncome) except Exception as e: logs.logger.error(e, exc_info=True)