-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathmodels.py
103 lines (86 loc) · 4.16 KB
/
models.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
from flask_login import LoginManager, UserMixin, login_user, login_required, logout_user, current_user
from flask_sqlalchemy import SQLAlchemy
from fpdf import FPDF
# Globally accessible libraries
db = SQLAlchemy()
SQLALCHEMY_TRACK_MODIFICATIONS = False
class individual(UserMixin, db.Model):
id = db.Column(db.String(10), primary_key = True, nullable = False)
pasw = db.Column(db.String(100), nullable = False)
fname = db.Column(db.String(30), index = False, nullable= False)
lname = db.Column(db.String(30), index = False, nullable= False)
email = db.Column(db.String(30), index = False, nullable= False)
mob = db.Column(db.String(30), index = False, nullable= False)
dob = db.Column(db.String(30), index = False, nullable= False)
gender = db.Column(db.String(30), index = False, nullable= False)
aadhaar = db.Column(db.Integer())
blood = db.Column(db.Text(3), index = False, nullable= False)
state = db.Column(db.String(15), index = False, nullable= False)
city = db.Column(db.String(15), index = False, nullable= False)
district = db.Column(db.String(30), index = False, nullable= True)
pin = db.Column(db.Integer(), index = False, nullable= False)
addr1 = db.Column(db.String(30), index = False, nullable= False)
addr2 = db.Column(db.String(30), index = False, nullable= True)
def get_name(self):
name = self.fname + " " + self.lname
return name
def send_pdf_indi(self):
pdf = FPDF()
# Add a page
pdf.add_page()
# set style and size of font
# that you want in the pdf
pdf.set_font("Arial", size = 15)
# create a cell
pdf.cell(200, 10, txt = "GeeksforGeeks",
ln = 1, align = 'C')
# add another cell
pdf.cell(200, 10, txt = "A Computer Science portal for geeks.",
ln = 2, align = 'C')
pdf.cell(200,10, txt="name"+self.get_name(), ln=3, align='C')
# save the pdf with name .pdf
data = self.get_name()+".pdf"
path = "C:\\minor_project\\"+"GFG.pdf"
pdf.output(path, 'D')
#_____________Added by eshan___________
class doctor(UserMixin, db.Model):
id = db.Column(db.String(10), primary_key = True, nullable = False)
pasw = db.Column(db.String(100), nullable = False)
fname = db.Column(db.String(30), index = False, nullable= False)
lname = db.Column(db.String(30), index = False, nullable= False)
email = db.Column(db.String(30), index = False, nullable= False)
mob = db.Column(db.String(30), index = False, nullable= False)
dob = db.Column(db.String(30), index = False, nullable= False)
gender = db.Column(db.String(30), index = False, nullable= False)
regnum = db.Column(db.Integer(), index = False, nullable= False)
Specialization = db.Column(db.Text(30), index = False, nullable= False)
state = db.Column(db.String(15), index = False, nullable= False)
city = db.Column(db.String(15), index = False, nullable= False)
district = db.Column(db.String(30), index = False, nullable= True)
pin = db.Column(db.Integer(), index = False, nullable= False)
addr1 = db.Column(db.String(30), index = False, nullable= False)
addr2 = db.Column(db.String(30), index = False, nullable= True)
def get_doc(self):
name = self.fname + " " + self.lname
return name
#_____________.________________________
class labs(UserMixin, db.Model):
id = db.Column(db.String(10), primary_key = True, nullable = False)
licenseno = db.Column(db.String(10), index=False, nullable = False)
pasw = db.Column(db.String(100), nullable = False)
labname = db.Column(db.String(30), index = False, nullable= False)
tests_avlbl = db.Column(db.String(30), index = False, nullable= False)
email = db.Column(db.String(30), index = False, nullable= False)
mob = db.Column(db.String(30), index = False, nullable= False)
ownername = db.Column(db.String(30), index = False, nullable= False)
state = db.Column(db.String(15), index = False, nullable= False)
city = db.Column(db.String(15), index = False, nullable= False)
district = db.Column(db.String(30), index = False, nullable= True)
pin = db.Column(db.Integer(), index = False, nullable= False)
addr1 = db.Column(db.String(30), index = False, nullable= False)
addr2 = db.Column(db.String(30), index = False, nullable= True)
def get_labname(self):
name = self.labname
return name
def get_license(self):
return self.licenseno