def delete(self): data = IocManager.api.payload job_id = data.get('JobId') # ap_scheduler_job = self.ap_scheduler_job_repository.filter_by( IsDeleted=0, Id=job_id).first() if ap_scheduler_job is None: return CommonModels.get_error_response(f"Job {job_id} not found") self.job_scheduler.remove_job(job_id=ap_scheduler_job.JobId) return CommonModels.get_response( message=f"Job {job_id} removed successfully")
def post(self): data = IocManager.api.payload rune_date_string = data.get('RunDate') # value = data.get('value') # value_for_sum = data.get('value_for_sum') if rune_date_string is None or rune_date_string == '': return CommonModels.get_error_response(message="RunDate Requeired") run_date = datetime.strptime(rune_date_string, "%Y-%m-%dT%H:%M:%S.%fZ") ap_scheduler_job = self.job_operation_service.add_job_with_date(job_function=TestScheduler.sum, run_date=run_date, args=(None, value, value_for_sum,)) result = JobModels.get_ap_scheduler_job_model(ap_scheduler_job) return CommonModels.get_response(result=result)
def get(self, value, count): run_date = datetime.now() ap_scheduler_job = self.job_operation_service.add_job_with_date(job_function=TestParallelScheduler.operation, run_date=run_date, args=(None, value, count,)) result = JobModels.get_ap_scheduler_job_model(ap_scheduler_job) return CommonModels.get_response(result=result)
def get(self): """ Get Connection Types """ connection_types = self.connection_type_service.get() result = ConnectionModels.get_connection_type_models(connection_types) return CommonModels.get_response(result=result)
def get(self): """ Get All Data Operations """ entities = self.data_operation_service.get_data_operations() result = DataOperationModels.get_data_operation_result_models(entities) return CommonModels.get_response(result=result)
def get(self): """ Get All Connections """ entities = self.connection_service.get_connections() result = ConnectionModels.get_connection_result_models(entities) return CommonModels.get_response(result=result)
def delete(self): """ Delete Existing Data Operation """ data = IocManager.api.payload id = data.get('Id') # deletion_result = self.data_operation_service.delete_data_operation(id) return CommonModels.get_response(message="Data Operation removed successfully")
def get(self): data = TestModels.parser.parse_args(request) value = data.get('value') # value_for_sum = data.get( 'value_for_sum') # This is FileStorage instance # url = do_something_with_file(uploaded_file) result = {'sum': value + value_for_sum} return CommonModels.get_response(result=result)
def delete(self): """ Delete Existing Database Connection """ data = IocManager.api.payload id = data.get('Id') # deletion_result = self.connection_service.delete_connection(id) return CommonModels.get_response( message="Connection Removed Successfully")
def post(self): """ Create New Database Connection """ data: CreateConnectionDatabaseModel = json.loads(json.dumps(IocManager.api.payload), object_hook=lambda d: CreateConnectionDatabaseModel(**d)) creation_result = self.connection_service.create_connection_database(data) result = ConnectionModels.get_connection_result_model(creation_result) return CommonModels.get_response(result=result)
def get(self): """ All data_integration data """ data_integrations = self.data_integration_service.get_data_integrations( ) result = DataIntegrationModels.get_data_integration_models( data_integrations) return CommonModels.get_response(result)
def put(self): """ Update existing Data Operation cron job """ data = IocManager.api.payload code = data.get('Code') # cron = data.get('Cron') # start_date = data.get('StartDate') # end_date = data.get('EndDate') # start_operation_result = self.job_operation_service.modify_job( code=code, cron=cron, start_date=start_date, end_date=end_date) if isinstance(start_operation_result, DataOperationJob): result = JobSchedulerModels.get_data_operation_job_model( start_operation_result) return CommonModels.get_response(result=result) else: message = start_operation_result return CommonModels.get_error_response(message=message)
def delete(self): """ Delete Existing Integration Data """ data = IocManager.api.payload code = data.get('Code') # deletion_result = self.data_integration_service.delete_data_integration( code) return CommonModels.get_response( message=f'Data data_integration deletion for {code} is Completed')
def get(self, code): """ Job details with code """ data_integration = self.data_integration_repository.first(Code=code) if data_integration is None: return "Code Not Found" result = DataOperationModels.get_data_operation_job_models( data_integration.Jobs) return CommonModels.get_response(result)
def get(self, job_id): """ Job logs getting with code """ ap_scheduler_job = self.ap_scheduler_job_repository.first(Id=job_id) if ap_scheduler_job is None: return "Job Not Found" logs = self.log_repository.filter_by( JobId=job_id).all() result = DataOperationModels.get_pdi_logs_model(logs) return CommonModels.get_response(result)
def put(self): """ Create Integration Data """ data: CreateDataIntegrationModel = json.loads( json.dumps(IocManager.api.payload), object_hook=lambda d: UpdateDataIntegrationModel(**d)) data_integration = self.data_integration_service.update_data_integration( data) result = DataIntegrationModels.get_data_integration_model( data_integration) return CommonModels.get_response(result=result)
def post(self): """ Schedule Data Operation """ data = IocManager.api.payload operation_name = data.get('OperationName') # run_date = data.get('RunDate') # start_operation_result = self.job_operation_service.add_pdi_job_with_date( operation_name=operation_name, run_date=run_date) result = JobSchedulerModels.get_data_operation_job_model( start_operation_result) return CommonModels.get_response(result=result)
def post(self): data = IocManager.api.payload start_date = data.get('StartDate') # end_date = data.get('EndDate') # cron = data.get('Cron') # value = data.get('value') # value_for_sum = data.get('value_for_sum') ap_scheduler_job = self.job_operation_service.add_job_with_cron(job_function=TestScheduler.sum, cron=cron, start_date=start_date, end_date=end_date, args=(None, value, value_for_sum)) result = JobModels.get_ap_scheduler_job_model(ap_scheduler_job) return CommonModels.get_response(result=result)
def post(self): data = IocManager.api.payload value = data.get('value') # value_for_sum = data.get( 'value_for_sum') # This is FileStorage instance result = { 'sum': value + value_for_sum, "test": [{ "test": 1 }, { "test": 2 }] } return CommonModels.get_response(result=result)
def post(self): """ Schedule Data Operation cron job """ data = IocManager.api.payload operation_name = data.get('OperationName') # cron = data.get('Cron') # start_date = data.get('StartDate') # end_date = data.get('EndDate') # start_operation_result = self.job_operation_service.add_pdi_job_with_cron( operation_name=operation_name, cron=cron, start_date=start_date, end_date=end_date) result = JobSchedulerModels.get_data_operation_job_model( start_operation_result) return CommonModels.get_response(result=result)
def post(self): """ Check Database Connection """ data = IocManager.api.payload name = data.get('Name') # schema = data.get('Schema') # table = data.get('Table') # connection = self.connection_service.get_connection_by_name(name=name) connection_manager = self.connection_service.connection_provider.get_connection_manager( connection=connection) connection_manager.connector.connect() count_of_table = "" if schema is not None and schema != '' and table is not None and table != '': count = connection_manager.get_table_count( f'select * from "{schema}"."{table}"') count_of_table = f"Count of table:{count}" return CommonModels.get_response( result=f"Connection connected successfully. {count_of_table}")
def post(self): """ Data Operation definition """ data: CreateDataOperationModel = json.loads(json.dumps(IocManager.api.payload), object_hook=lambda d: CreateDataOperationModel(**d)) if 'Contacts' in IocManager.api.payload: data.Contacts = json.loads(json.dumps(IocManager.api.payload["Contacts"]), object_hook=lambda d: CreateDataOperationContactModel(**d)) data_operation_integrations: List[CreateDataOperationIntegrationModel] = [] data_operation_integration: CreateDataOperationIntegrationModel = None for data_integration in IocManager.api.payload["Integrations"]: data_operation_integration = CreateDataOperationIntegrationModel() data_operation_integration.Limit = data_integration["Limit"] data_operation_integration.ProcessCount = data_integration["ProcessCount"] data_operation_integration.Integration = json.loads(json.dumps(data_integration["Integration"]), object_hook=lambda d: CreateDataIntegrationModel(**d)) data_operation_integrations.append(data_operation_integration) data.Integrations = data_operation_integrations creation_result = self.data_operation_service.post_data_operation(data,definition_json=json.dumps(IocManager.api.payload)) result = DataOperationModels.get_data_operation_result_model(creation_result) return CommonModels.get_response(result=result)
def get(self, job_id): ap_scheduler_job = self.ap_scheduler_job_repository.get_by_id(job_id) if ap_scheduler_job is None: return CommonModels.get_error_response(f"Job {job_id} not found") result = JobModels.get_ap_scheduler_job_model(ap_scheduler_job) return CommonModels.get_response(result=result)
def get(self, job_id): ap_scheduler_job_events = self.ap_scheduler_job_event_repository.filter_by(ApSchedulerJobId=job_id).all() result = JobModels.get_ap_scheduler_job_events_model(ap_scheduler_job_events) return CommonModels.get_response(result)
def get(self, value): result = self.test_parallel_service.test_performance_parallel(value) return CommonModels.get_response(message=result)
def operation(job_id, value, count): test_parallel_service = IocManager.injector.get(TestParallelService) result = test_parallel_service.test_performance_parallel(value, count) return CommonModels.get_response(message=result)
def get(self, value, value_for_sum): result = {'sum': value + value_for_sum} return CommonModels.get_response(result=result)
def get(self): ap_scheduler_jobs = self.ap_scheduler_job_repository.filter_by( IsDeleted=0).all() result = JobModels.get_ap_scheduler_job_models(ap_scheduler_jobs) return CommonModels.get_response(result=result)