def op50(self):
machine_master_data = []
master_dict = {}
machine_code = 'OP50' # 설비 코드명
machine_class = 'MCO2' # 용접 조립
machine_process_time = 'exp10'
machine_assembly = 'op40_flange2'
machine_data_code = 'T01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
MySQL_query.insert_machine_master(machine_master_data)
return master_dict
def op30(self):
machine_master_data = []
master_dict = {}
machine_code = 'OP30' # 설비 코드명
machine_class = 'MCO1' # 단순 조립
machine_process_time = 'exp10'
machine_assembly = 'op20_pipe2'
machine_data_code = 'E01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
MySQL_query.insert_machine_master(machine_master_data)
return master_dict
def op60(self):
machine_master_data = []
master_dict = {}
machine_code = 'OP60' # 설비 코드명
machine_class = 'MCO3' # 최종 검사
machine_process_time = 'exp10'
machine_assembly = 'final_test'
machine_data_code = 'TEST'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
MySQL_query.insert_machine_master(machine_master_data)
return master_dict
def machine_master():
machine_master_data = []
### 10
master_dict = {}
machine_code = 'OP10' # 설비 코드명
machine_class = 'MCO1' # 단순 조립
machine_process_time = 'exp10'
machine_assembly = 'body_wavyfin'
machine_data_code = 'E01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
### 20
master_dict = {}
machine_code = 'OP20' # 설비 코드명
machine_class = 'MCO1' # 단순 조립
machine_process_time = 'exp10'
machine_assembly = 'op10_pipe1'
machine_data_code = 'E01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
### 30
master_dict = {}
machine_code = 'OP30' # 설비 코드명
machine_class = 'MCO1' # 단순 조립
machine_process_time = 'exp10'
machine_assembly = 'op20_pipe2'
machine_data_code = 'E01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
### 40
master_dict = {}
machine_code = 'OP40' # 설비 코드명
machine_class = 'MCO2' # 용접 조립
machine_process_time = 'exp10'
machine_assembly = 'op30_flange1'
machine_data_code = 'T01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
### 50
master_dict = {}
machine_code = 'OP50' # 설비 코드명
machine_class = 'MCO2' # 용접 조립
machine_process_time = 'exp10'
machine_assembly = 'op40_flange2'
machine_data_code = 'T01'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
### 60
master_dict = {}
machine_code = 'OP60' # 설비 코드명
machine_class = 'MCO3' # 최종 검사
machine_process_time = 'exp10'
machine_assembly = 'final_test'
machine_data_code = 'TEST'
master_dict['machine_code'] = machine_code # PK
master_dict['machine_class'] = machine_class
master_dict['machine_process_time'] = machine_process_time
master_dict['machine_assembly'] = machine_assembly
master_dict['machine_data_code'] = machine_data_code
machine_master_data.append(master_dict)
MySQL_query.insert_machine_master(machine_master_data)
return machine_master_data
from SQL import MySQL_query from machine_master_table import machine_master op10 = machine_master.op10(1) op20 = machine_master.op20(1) op30 = machine_master.op30(1) op40 = machine_master.op40(1) op50 = machine_master.op50(1) op60 = machine_master.op60(1) MySQL_query.insert_machine_master(op10) MySQL_query.insert_machine_master(op20) MySQL_query.insert_machine_master(op30) MySQL_query.insert_machine_master(op40) MySQL_query.insert_machine_master(op50) MySQL_query.insert_machine_master(op60)