def gen(t, i):
desc = genDiagnosis()
noevent = int(random.random()*nb_event)
dateA = genAction.genDates(noevent)
no = i+1
values = u''.join((" VALUES (", str(no),", ", \
"", str(noevent + 1) ,", " , str(int(random.random()*nb_doc + 1)), ", ", \
"'", dateA.isoformat(), "', ", \
"'", desc,"');")).encode('utf-8').strip()
print "INSERT INTO " + t
print values
print
def gen(t, i):
med = genMed()
noevent = int(random.random()*nb_event)
dateA = genAction.genDates(noevent)
no = i+1
values = u''.join((" VALUES (", str(no),", ", \
"", str(noevent + 1) ,", " , str(int(random.random()*nb_doc + 1))\
, ", '", genDate(2005) , "'"\
, ", '", med[0] , "' ,'", med[1], "' , '", med[2], "' , '" \
, med[3],"');")).encode('utf-8').strip()
print "INSERT INTO " + t
print values
print
def gen(t, i):
desc = genDesc()
noevent = int(random.random()*nb_event)
dateA = genAction.genDates(noevent)
no = i+1
prob = int(random.random()*2)
if( prob == 1) :
values = u''.join((" VALUES (", str(no),", ", \
"", str(noevent + 1) ,", '" , str(Nurses[int(random.random()*nb_nur)]), "', ", \
"'", dateA.isoformat(), "', ", \
"'", desc,"', '');")).encode('utf-8').strip()
else :
values = u''.join((" VALUES (", str(no),", ", \
"", str(noevent + 1) ,", '" , str(Doctors[int(random.random()*nb_doc)]), "', ", \
"'", dateA.isoformat(), "', ", \
"'", desc,"', '');")).encode('utf-8').strip()
print "INSERT INTO " + t
print values
print