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)
