def genDataBase(fileName, dataCount): outp = open(fileName, 'w', encoding='utf-8') i = 0 while i < dataCount: people_item = f.genRandomTypes(data_values.people_list) doctor_name = f.genRandomTypes(data_values.name_list) id = f.genPK(19) record_no = people_item['record_id'] name = people_item['name'] resident_name = name gmt_interview = f.genRandomDay() symptom_code = f.genRandomString(10) symptom_desc = f.genRandomString(10) interview_way = f.genRandomString(1) interview_way_desc = f.genRandomString(10) l_sbp = f.genRandomString(10) l_dbp = f.genRandomString(10) r_sbp = f.genRandomString(10) r_dbp = f.genRandomString(10) weight = f.genRandomString(10) bmi = f.genRandomString(10) heart_rate = f.genRandomString(3) dpa = f.genRandomString(5) dpa_desc = f.genRandomString(10) physical_other = f.genRandomString(10) daily_smoke_amount = f.genRandomString(8) daily_drink_amount = f.genRandomString(10) sport_frequency = f.genRandomString(10) sport_duration_per = f.genRandomString(10) staple_food = f.genRandomString(10) mind_status = f.genRandomString(10) mind_desc = f.genRandomString(10) obey_status = f.genRandomString(10) obey_status2 = f.genRandomString(10) fpg = f.genRandomString(10) salt_intake_status = f.genRandomString(10) auxiliary_other = f.genRandomString(10) dar_code = f.genRandomString(10) dar_desc = f.genRandomString(10) rhg_code = f.genRandomString(1) rhg_desc = f.genRandomString(10) drug_dependence_code = f.genRandomString(10) drug_dependence_desc = f.genRandomString(10) classification_code = f.genRandomString(1) classification_desc = f.genRandomString(10) drug_name1 = f.genRandomString(10) drug_way1 = f.genRandomString(10) drug_dose1 = f.genRandomString(10) drug_name2 = f.genRandomString(10) drug_way2 = f.genRandomString(10) drug_dose2 = f.genRandomString(10) drug_name3 = f.genRandomString(10) drug_way3 = f.genRandomString(10) drug_dose3 = f.genRandomString(10) insulin_type = f.genRandomString(10) insulin_way_dose = f.genRandomString(10) tt_code = f.genRandomString(1) tt_reason = f.genRandomString(10) tt_org_name = f.genRandomString(10) tt_department_name = f.genRandomString(10) doctor_id = f.genRandomString(10) doctor_name = data_values.name_list[f.genInt(len( data_values.name_list))] org_id = f.genRandomString(10) org_name = data_values.hospital_list[f.genInt( len(data_values.hospital_list))][1] gmt_next = f.genDateList()[2] create_time = f.createTime() update_time = f.createTime() status = 0 mLine = " %s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s\n" % ( id, record_no, resident_name, gmt_interview, symptom_code, symptom_desc, interview_way, interview_way_desc, l_sbp, l_dbp, r_sbp, r_dbp, weight, bmi, heart_rate, dpa, dpa_desc, physical_other, daily_smoke_amount, daily_drink_amount, sport_frequency, sport_duration_per, staple_food, mind_status, mind_desc, obey_status, obey_status2, fpg, salt_intake_status, auxiliary_other, dar_code, dar_desc, rhg_code, rhg_desc, drug_dependence_code, drug_dependence_desc, classification_code, classification_desc, drug_name1, drug_way1, drug_dose1, drug_name2, drug_way2, drug_dose2, drug_name3, drug_way3, drug_dose3, insulin_type, insulin_way_dose, tt_code, tt_reason, tt_org_name, tt_department_name, doctor_id, doctor_name, org_id, org_name, gmt_next, create_time, update_time, status) outp.write(mLine) i += 1 outp.close()
def genDataBase(fileName, dataCount): outp = open(fileName, 'w',encoding='utf-8') i = 0 while i < dataCount: people_item = f.genRandomTypes(data_values.people_list) doctor_name = f.genRandomTypes(data_values.name_list) id = f.genPK(19) record_no = people_item['record_id'] name = people_item['name'] resident_name = name guardian_name = f.genRandomString(10) relation_name = f.genRandomString(10) guardian_addr = f.genRandomString(10) guardian_tel = f.genPhoneNum() contact_name = f.genRandomString(10) contact_tel = f.genPhoneNum() household_type = f.genRandomString(1) household_desc = f.genRandomString(10) employment_code = f.genRandomString(1) employment_desc = f.genRandomString(10) is_agreed = f.genRandomString(1) is_agreed_desc = f.genRandomString(10) sign_name = f.genRandomString(10) sign_date = str(f.genRandomDay()) first_ill_date = str(f.genRandomDay()) past_symptom = f.genRandomString(10) past_symptom_desc = f.genRandomString(10) past_close_lock = f.genRandomString(1) past_close_lock_desc = f.genRandomString(10) treatment_od_code = f.genRandomString(1) treatment_od_desc = f.genRandomString(10) treatment_od = f.genRandomString(10) treatment_his = f.genRandomString(10) stay_hospital_num = f.genRandomString(6) first_treat_date = str(f.genRandomDay()) diagnosis_desc = f.genRandomString(10) diagnosis_org_id = f.genRandomString(10) diagnosis_org_name = f.genRandomString(10) diagnosis_date = str(f.genRandomDay()) last_effect_code = f.genRandomString(1) last_effect_desc = f.genRandomString(10) has_danger_act = f.genRandomString(10) act_affray_num = f.genRandomString(5) act_trouble_num = f.genRandomString(5) act_disaster_num = f.genRandomString(5) act_other_num = f.genRandomString(5) act_self_injury_num = f.genRandomString(5) act_attempted_suicide_num = f.genRandomString(5) endowment_position = f.genInt(1) endowment_position_desc = f.genRandomString(10) doctor_advice = f.genRandomString(10) reg_date = f.genRandomString(10) doctor_id = f.genRandomString(10) doctor_name = f.genRandomString(10) org_id = f.genRandomString(10) org_name = data_values.hospital_list[f.genInt(len(data_values.hospital_list))][1] create_time = f.createTime() update_time = f.createTime() status = 0 mLine = " %s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s \n" % ( id, record_no, resident_name, guardian_name, relation_name, guardian_addr, guardian_tel, contact_name, contact_tel, household_type, household_desc, employment_code, employment_desc, is_agreed, is_agreed_desc, sign_name, sign_date, first_ill_date, past_symptom, past_symptom_desc, past_close_lock, past_close_lock_desc, treatment_od_code, treatment_od_desc, treatment_od, treatment_his, stay_hospital_num, first_treat_date, diagnosis_desc, diagnosis_org_id, diagnosis_org_name, diagnosis_date, last_effect_code, last_effect_desc, has_danger_act, act_affray_num, act_trouble_num, act_disaster_num, act_other_num, act_self_injury_num, act_attempted_suicide_num, endowment_position, endowment_position_desc, doctor_advice, reg_date, doctor_id, doctor_name, org_id, org_name, create_time, update_time, status) outp.write(mLine) i += 1 outp.close()
def genDataBase(fileName, dataCount): outp = open(fileName, 'w', encoding='utf-8') i = 0 while i < dataCount: people_item = f.genRandomTypes(data_values.people_list) doctor_name = f.genRandomTypes(data_values.name_list) id = f.genPK(19) record_no = people_item['record_id'] name = people_item['name'] flup_date = f.genRandomDay() treat_month = str(f.genInt(29)) steer_person = f.genInt(len(data_values.steer_person_desc)) steer_person_desc = data_values.steer_person_desc[steer_person] flup_type = f.genInt(len(data_values.flup_type_desc)) flup_type_desc = data_values.flup_type_desc[flup_type] symptom_code = f.genRandomString(5) symptom_desc = f.genRandomString(10) daily_smoke = f.genRandomString(8) daily_drink = f.genRandomString(16) chemotherapy_plan = f.genRandomString(32) drug_use = f.genRandomString(1) drug_use_desc = f.genRandomString(32) drug_dose = f.genRandomString(1) drug_dose_desc = f.genRandomString(16) leak_medicine_num = f.genRandomString(3) ad_reaction = f.genRandomString(1) ad_reaction_desc = f.genRandomString(10) complication = f.genInt(9) complication_desc = f.genRandomString(10) referral_reason = f.genRandomString(10) referral_org_name = data_values.dept_list[f.genInt( len(data_values.dept_list))][1] referral_department = data_values.dept_list[f.genInt( len(data_values.dept_list))][1] deal_advice = f.genRandomString(20) two_flup_result = f.genRandomString(10) stop_treat_time = f.genRandomDay() stop_treat_reason = f.genInt(9) stop_treat_reason_desc = f.genRandomString(20) flup_user_num = str(f.genInt(99)) doctor_id = f.genRandomString(19) doctor_name = data_values.name_list[f.genInt(len( data_values.name_list))] gmt_next = f.genDateList()[2] doc = f.genInt(len(data_values.name_list)) assess_doctor_id = doc assess_doctor_name = data_values.name_list[doc] org = f.genInt(len(data_values.hospital_list)) org_id = data_values.hospital_list[org][0] org_name = data_values.hospital_list[org][1] assess_ = f.genInt(len(data_values.hospital_list)) assess_org_id = data_values.hospital_list[assess_][0] assess_org_name = data_values.hospital_list[assess_][1] ttt = f.createTime() create_time = ttt update_time = ttt status = 0 mLine = " %s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s\n" % ( id, record_no, name, flup_date, treat_month, steer_person, steer_person_desc, flup_type, flup_type_desc, symptom_code, symptom_desc, daily_smoke, daily_drink, chemotherapy_plan, drug_use, drug_use_desc, drug_dose, drug_dose_desc, leak_medicine_num, ad_reaction, ad_reaction_desc, complication, complication_desc, referral_reason, referral_org_name, referral_department, deal_advice, two_flup_result, stop_treat_time, stop_treat_reason, stop_treat_reason_desc, flup_user_num, doctor_id, doctor_name, gmt_next, assess_doctor_id, assess_doctor_name, org_id, org_name, assess_org_id, assess_org_name, create_time, update_time, status) outp.write(mLine) i += 1 outp.close()
def genDataBase(fileName, dataCount): outp = open(fileName, 'w',encoding='utf-8') i = 0 while i < dataCount: people_item = f.genRandomTypes(data_values.people_list) doctor_name = f.genRandomTypes(data_values.name_list) id = f.genPK(19) record_no = people_item['record_id'] name = people_item['name'] resident_name = name gmt_interview = f.genRandomString(10) Interview_way = f.genRandomString(1) Interview_way_desc = f.genRandomString(10) loss_flup_reason = f.genRandomString(1) loss_flup_reason_desc = f.genRandomString(10) death_date = f.genRandomDay() die_reason_code = f.genRandomString(10) die_reason_desc = f.genRandomString(16) danger_grade = f.genRandomString(1) danger_grade_desc = f.genRandomString(10) symptom_code = f.genRandomString(32) symptom_desc = f.genRandomString(32) insight = f.genRandomString(1) insight_desc = f.genRandomString(10) sleep = f.genRandomString(1) sleep_desc = f.genRandomString(10) diet = f.genRandomString(1) diet_desc = f.genRandomString(10) sf_cuisine_life = f.genRandomString(1) sf_cuisine_life_desc = f.genRandomString(10) sf_housework = f.genRandomString(1) sf_housework_desc = f.genRandomString(10) sf_labor_work = f.genRandomString(1) sf_labor_work_desc = f.genRandomString(10) sf_learn_ability = f.genRandomString(1) sf_learn_ability_desc = f.genRandomString(10) sf_communication = f.genRandomString(1) sf_communication_desc = f.genRandomString(10) has_danger_act = f.genRandomString(1) has_danger_act_desc = f.genRandomString(10) act_affray_num = f.genRandomString(5) act_trouble_num = f.genRandomString(5) act_disaster_num = f.genRandomString(5) act_other_num = f.genRandomString(5) act_self_injury_num = f.genRandomString(5) act_attempted_suicide_num = f.genRandomString(5) interval_lock = f.genRandomString(1) interval_lock_desc = f.genRandomString(10) interval_his = f.genRandomString(1) interval_his_desc = f.genRandomString(10) leave_hospital_date = f.genRandomDay() lab_check = f.genRandomString(1) lab_check_desc = f.genRandomString(32) drug_dependence_code = f.genRandomString(32) drug_dependence_desc = f.genRandomString(32) dar_code = f.genRandomString(32) dar_desc = f.genRandomString(32) treat_effect = f.genRandomString(1) treat_effect_desc = f.genRandomString(10) tt_code = f.genRandomString(1) tt_desc = f.genRandomString(10) tt_reason = f.genRandomString(1) tt_org_name = data_values.hospital_list[f.genInt(len(data_values.hospital_list))][1] tt_department_name = data_values.hospital_list[f.genInt(len(data_values.hospital_list))][1] used_drug_name1 = f.genRandomString(10) used_drug_way1 = f.genRandomString(10) used_drug_dose1 = f.genRandomString(10) used_drug_name2 = f.genRandomString(10) used_drug_way2 = f.genRandomString(10) used_drug_dose2 = f.genRandomString(10) used_drug_name3 = f.genRandomString(10) used_drug_way3 = f.genRandomString(10) used_drug_dose3 = f.genRandomString(10) guide_drug_name1 = f.genRandomString(10) guide_drug_way1 = f.genRandomString(10) guide_drug_dose1 = f.genRandomString(10) guide_drug_name2 = f.genRandomString(10) guide_drug_way2 = f.genRandomString(10) guide_drug_dose2 = f.genRandomString(10) guide_drug_name3 = f.genRandomString(10) guide_drug_way3 = f.genRandomString(10) guide_drug_dose3 = f.genRandomString(10) rehab_measure = f.genRandomString(10) flup_classification_code = f.genRandomString(1) flup_classification_desc = f.genRandomString(10) doctor_id = f.genRandomString(19) doctor_name = data_values.name_list[f.genInt(len(data_values.name_list))] org_id = f.genRandomString(32) org_name = data_values.hospital_list[f.genInt(len(data_values.hospital_list))][1] gmt_next = f.genDateList()[2] create_time = f.createTime() update_time = f.createTime() status = 0 mLine = " %s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s\n" % ( id, record_no, resident_name, gmt_interview, Interview_way, Interview_way_desc, loss_flup_reason, loss_flup_reason_desc, death_date, die_reason_code, die_reason_desc, danger_grade, danger_grade_desc, symptom_code, symptom_desc, insight, insight_desc, sleep, sleep_desc, diet, diet_desc, sf_cuisine_life, sf_cuisine_life_desc, sf_housework, sf_housework_desc, sf_labor_work, sf_labor_work_desc, sf_learn_ability, sf_learn_ability_desc, sf_communication, sf_communication_desc, has_danger_act, has_danger_act_desc, act_affray_num, act_trouble_num, act_disaster_num, act_other_num, act_self_injury_num, act_attempted_suicide_num, interval_lock, interval_lock_desc, interval_his, interval_his_desc, leave_hospital_date, lab_check, lab_check_desc, drug_dependence_code, drug_dependence_desc, dar_code, dar_desc, treat_effect, treat_effect_desc, tt_code, tt_desc, tt_reason, tt_org_name, tt_department_name, used_drug_name1, used_drug_way1, used_drug_dose1, used_drug_name2, used_drug_way2, used_drug_dose2, used_drug_name3, used_drug_way3, used_drug_dose3, guide_drug_name1, guide_drug_way1, guide_drug_dose1, guide_drug_name2, guide_drug_way2, guide_drug_dose2, guide_drug_name3, guide_drug_way3, guide_drug_dose3, rehab_measure, flup_classification_code, flup_classification_desc, doctor_id, doctor_name, org_id, org_name, gmt_next, create_time, update_time, status) outp.write(mLine) i += 1 outp.close()
def genDataBase(fileName, dataCount): outp = open(fileName, 'w',encoding='utf-8') i = 0 while i < dataCount: people_item = f.genRandomTypes(data_values.people_list) doctor_name = f.genRandomTypes(data_values.name_list) id = f.genPK(19) record_no = people_item['record_id'] name = people_item['name'] flup_date = f.genRandomDay() flup_type = f.genRandomString(1) flup_desc = f.genRandomString(10) user_type = f.genRandomString(1) user_type_desc = f.genRandomString(10) pb_type = f.genRandomString(1) pb_type_desc = f.genRandomString(10) resist_drug_situation = f.genRandomString(1) resist_drug_situation_desc = f.genRandomString(10) symptom_code = f.genRandomString(10) symptom_desc = f.genRandomString(10) chemotherapy_plan = f.genRandomString(10) drug_use = f.genRandomString(1) drug_use_desc = f.genRandomString(10) drug_dose = f.genRandomString(1) drug_dose_desc = f.genRandomString(10) steer_selection = f.genRandomString(1) steer_selection_desc = data_values.steer_person_desc[f.genInt(len(data_values.steer_person_desc))] single_room = f.genRandomString(1) single_room_desc = f.genRandomString(10) ventilation = f.genRandomString(1) ventilation_desc = f.genRandomString(10) daily_smoke = f.genRandomString(8) daily_drink = f.genRandomString(16) drug_addr = f.genRandomString(10) drug_time = f.genRandomString(10) drug_record_form = f.genRandomString(1) drug_record_form_desc = f.genRandomString(10) drug_method_deposit = f.genRandomString(1) drug_method_deposit_desc = f.genRandomString(10) lunger_course = f.genRandomString(1) lunger_course_desc = f.genRandomString(10) irregular_harm = f.genRandomString(1) irregular_harm_desc = f.genRandomString(10) drug_harm_deal = f.genRandomString(1) drug_harm_deal_desc = f.genRandomString(10) phlegm_recovery = f.genRandomString(1) phlegm_recovery_desc = f.genRandomString(10) take_medicine = f.genRandomString(1) take_medicine_desc = f.genRandomString(10) habit_attention_item = f.genRandomString(1) habit_attention_item_desc = f.genRandomString(10) contact_check = f.genRandomString(1) contact_check_desc = f.genRandomString(10) doctor_id = f.genRandomString(10) doctor_name = data_values.name_list[f.genInt(len(data_values.name_list))] org_id = f.genRandomString(10) org_name = data_values.hospital_list[f.genInt(len(data_values.hospital_list))][1] gmt_next = f.genDateList()[2] create_time = f.createTime() update_time = f.createTime() status = 0 mLine = " %s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s \n" % ( id, record_no, name, flup_date, flup_type, flup_desc, user_type, user_type_desc, pb_type, pb_type_desc, resist_drug_situation, resist_drug_situation_desc, symptom_code, symptom_desc, chemotherapy_plan, drug_use, drug_use_desc, drug_dose, drug_dose_desc, steer_selection, steer_selection_desc, single_room, single_room_desc, ventilation, ventilation_desc, daily_smoke, daily_drink, drug_addr, drug_time, drug_record_form, drug_record_form_desc, drug_method_deposit, drug_method_deposit_desc, lunger_course, lunger_course_desc, irregular_harm, irregular_harm_desc, drug_harm_deal, drug_harm_deal_desc, phlegm_recovery, phlegm_recovery_desc, take_medicine, take_medicine_desc, habit_attention_item, habit_attention_item_desc, contact_check, contact_check_desc, doctor_id, doctor_name, org_id, org_name, gmt_next, create_time, update_time, status) outp.write(mLine) i += 1 outp.close()