o g @s*ddlmZddlmZGdddZdS))datetime)FinancialInformationPagec@sTeZdZeddZeddZeddZeddZed d Zed d Z d S)FinancialInformationPageServicecs@tdi|t|jd}||j||IdH}|S)z Insert a new record into the financial_information_pages table using MySQLDB's execute_insert. :param db: An instance of MySQLDB :param kwargs: Dictionary of column values for the new record ) created_at created_byN)rrnowuser_id update_modifyexecute_insert)db current_userkwargs new_recordrecordrr@/var/www/html/XCapMarket/services/financial_info/page_service.pyinsert_new_records z1FinancialInformationPageService.insert_new_recordcs|tIdHS)zM Get all records from the financial_information_pages table. N) execute_queryr)r rrrget_all_recordssz/FinancialInformationPageService.get_all_recordscs"tj|kg}|jt|dIdHS)zP Get a record from the financial_information_pages table by id. filtersN)ridrr page_idrrrrget_record_by_ids z0FinancialInformationPageService.get_record_by_idcs$tj|kg}|jt||dIdHS)zS Delete a record from the financial_information_pages table by id. ) record_idrN)rr delete_recordrrrrdelete_record_by_id&s   z3FinancialInformationPageService.delete_record_by_idcs*tj|ktjdkg}|jt|dIdHS)z[ Get all records from the financial_information_pages table for a project. TrN)r project_id is_activer)r rrrrrget_all_records_for_project0s z;FinancialInformationPageService.get_all_records_for_projectcs:t|d<|j|d<tj|kg}|jt||dIdHS)z Update a record in the financial_information_pages table by id. :param db: An instance of MySQLDB :param page_id: The ID of the record to update :param kwargs: Dictionary of column values to update modified_at modified_by)rvaluesN)rrr rr update_record)r rr rrrrrupdate_record_by_id;s   z3FinancialInformationPageService.update_record_by_idN) __name__ __module__ __qualname__ staticmethodrrrrr r%rrrrrs      rN)rmodels.financial_informationrrrrrrs