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()