def populate_date():
s_date = date(2020, 6, 20)
e_date = date(2020, 12, 31)
conn = ex.connect()
cur = conn.cursor()
delta = e_date - s_date
days = [
"Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday",
"Friday"
]
dayI = 0
for i in range(delta.days + 1):
day = s_date + timedelta(days=i)
hol = False
weknd = False
if (dayI + i) % 7 == 6:
weknd = True
# print(str(day) + " " + days[(dayI + i) % 7])
sql = ''' insert into HOSPITAL.CALENDER(DATE_ID, FULL_DATE, DAY_IN_WEEK, DAY_NAME, IS_HOLIDAY)
VALUES(:ID, :FULLDATE, :DIW, :DN, :IS_HOLI)'''
try:
cur.execute(
sql,
[i + 1, day, (dayI + i) % 7 + 1, days[(dayI + i) % 7], "No"])
conn.commit()
except cx_Oracle.Error as error:
print("Error occured")
print(error)
def populate_doctor(N=10):
random.seed(0)
Faker.seed(0)
fake = Faker()
specialization = [
"Cardiology", "Neurology", "Orthopedics", "Physiotherapy", "Dentistry",
"Oncology", "Pediatrics", "Obstetrics and Gynocology",
"Gastroenterology and Hepatology", "Dermatology and Venereology",
"Medicine", "Ophthalmologists"
]
designation = [
"Assistant Professor", "Professor", "Associate Professor",
"Dr. Professor", "Consultant"
]
qualification = ["PhD,DPhil", "MPhil", "MM,MMed", "MSurg", "FCPS", "FRCPS"]
conn = ex.connect()
cur = conn.cursor()
for i in range(N):
id = int(GenerateToken("staff", "doctor", str(i)).returnId())
fname = fake.first_name()
lname = fake.last_name()
email = fname + lname + "@gmail.com"
phn = str(fake.msisdn())
dob = fake.date_time(end_datetime=datetime(1992, 12, 31, 23, 59, 59))
hire = fake.date_time()
addr = fake.address()
spec = specialization[random.randint(0, 11)]
status = "active"
des = designation[random.randint(0, 4)]
qua = qualification[random.randint(0, 5)] + ", MBBS"
gender = "Male"
wrap = [
id, fname, lname, email, phn, hire, gender, spec, des, qua, status,
addr, dob
]
sql = '''insert into HOSPITAL.DOCTORS(DOC_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,
GENDER, SPECIALIZATION, DESIGNATION, QUALIFICATION, STATUS, ADDRESS, DATE_OF_BIRTH)
VALUES(:ID, :FNAME, :LNAME, :EMAIL, :PHN, :HIRE, :GEN, :SPEC, :DES, :QUA, :STAT, :ADDR, :DOB)'''
try:
cur.execute(sql, wrap)
conn.commit()
except cx_Oracle.Error as error:
print("Error occured")
print(error)
def savetoDB(self):
conn = ex.connect()
cur = conn.cursor()
self.getBuiltId(cur)
#print(self.patientid)
self.datadict['id'] = int(self.patientid)
#print(self.datadict)
try:
cur.execute(self.insert_sql, [
self.datadict['id'], self.datadict['fname'],
self.datadict['lname'], self.datadict['email'],
self.datadict['phn'], self.datadict['gender'],
self.datadict['address'], self.datadict['dob']
])
#conn.commit()
except cx_Oracle.Error as error:
print("Error occured")
print(error)
def populate_time_table():
fhand = open("timetable.txt", "r")
if fhand.mode == 'r':
lines = fhand.readlines()
for line in lines:
line = line.rstrip()
line = line.split()
cat = ""
for i in range(3, len(line)):
cat = cat + line[i]
if i != len(line) - 1:
cat = cat + " "
sql = '''insert into HOSPITAL.TIME_TABLE(TIME_ID, START_TIME, END_TIME, SHIFT_TITLE)
VALUES(:ID, :START_TIME, :END_TIME, :TITLE)'''
conn = ex.connect()
cur = conn.cursor()
try:
cur.execute(sql, [line[0], line[1], line[2], cat])
conn.commit()
except cx_Oracle.Error as error:
print("Error occured")
print(error)
def index2(request):
c = ex.connect('hospital', 'hospital')
str = ex.getDoctorInfo(c)
print(str)
c.close()
return HttpResponse(str, content_type="text/plain")