memerkida-fullstack/models.py at develop · Devbijwe/memerkida-fullstack · GitHub

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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197

from __init__ import db
from datetime import datetime
from sqlalchemy import inspect

class Customize(db.Model):
    __tablename__ = 'customize'
    id=db.Column(db.Integer,primary_key=True)
    publicId=db.Column(db.String(50),nullable=False)
    feature_name=db.Column(db.String(100),nullable=False,unique=True)
    value=db.Column(db.String(200),nullable=True)
    status=db.Column(db.String(20),nullable=True)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }


class Tshirts(db.Model):
    __tablename__ = 'tshirts'
    id=db.Column(db.Integer,primary_key=True)
    publicId=db.Column(db.String(50),nullable=False)
    tshirtId=db.Column(db.Integer,nullable=False)
    subId=db.Column(db.Integer,nullable=False)
    type=db.Column(db.String(20),nullable=False)
    name=db.Column(db.String(100),nullable=False)
    description=db.Column(db.String(200),nullable=False)
    price=db.Column(db.String(11),nullable=False)
    img=db.Column(db.String(100),nullable=False)
    colour=db.Column(db.String(200),nullable=False)
    sleeve=db.Column(db.String(50),nullable=False)
    size=db.Column(db.String(100),nullable=False)
    neck=db.Column(db.String(50),nullable=False)
    status=db.Column(db.String(20),nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Customers(db.Model):
    __tablename__ = 'customers'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    name=db.Column(db.String(50),nullable=False)
    mobile=db.Column(db.String(15),nullable=True,unique=True)
    pswd=db.Column(db.String(20),nullable=False)
    email=db.Column(db.String(75),nullable=True)
    loggedFrom=db.Column(db.String(20),nullable=False)
    address1=db.Column(db.String(200),nullable=True)
    address2=db.Column(db.String(200),nullable=True)
    city=db.Column(db.String(50),nullable=True)
    state=db.Column(db.String(50),nullable=True)
    zip=db.Column(db.Integer,nullable=True)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Templates(db.Model):
    __tablename__ = 'templates'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    title=db.Column(db.String(250),nullable=False)
    category=db.Column(db.String(50),nullable=False)
    keywords=db.Column(db.String(100),nullable=True)
    price=db.Column(db.String(10),nullable=False)
    lightTemplate=db.Column(db.String(200),nullable=False)
    lightTshirt=db.Column(db.String(200),nullable=False)
    lightBG=db.Column(db.String(50),nullable=False)
    darkTemplate=db.Column(db.String(200),nullable=False)
    darkTshirt=db.Column(db.String(200),nullable=False)
    darkBG=db.Column(db.String(50),nullable=False)
    carousel=db.Column(db.Boolean, default=False,nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }


class Admin(db.Model):
    __tablename__ = 'admin'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    name=db.Column(db.String(50),nullable=False)
    username=db.Column(db.String(50),nullable=False)
    email=db.Column(db.String(75),nullable=False,unique=True)
    password=db.Column(db.String(50),nullable=False)
    secretkey=db.Column(db.String(100),nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Orders(db.Model):
    __tablename__ = 'orders'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    custId=db.Column(db.String(50),nullable=False)
    paymentId=db.Column(db.String(50),nullable=True,unique=True)
    trackingId=db.Column(db.String(50),nullable=True,unique=True)
    type=db.Column(db.String(25),nullable=False)
    tshirtImg=db.Column(db.String(200),nullable=False)
    printImg=db.Column(db.String(200),nullable=False)
    theme=db.Column(db.String(20),nullable=False)
    details=db.Column(db.String(500),nullable=True)
    quantity=db.Column(db.Integer,nullable=True)
    price=db.Column(db.String(10),nullable=False)
    colour=db.Column(db.String(25),nullable=False)
    size=db.Column(db.String(10),nullable=False)
    invoice=db.Column(db.String(200),nullable=True)
    status=db.Column(db.String(50),nullable=True)
    delivered=db.Column(db.String(10),nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Payments(db.Model):
    __tablename__ = 'payments'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    custId=db.Column(db.String(50),nullable=False)
    orderId=db.Column(db.String(50),nullable=False,unique=True)
    transactionId=db.Column(db.String(50),nullable=True,unique=True)
    payMethods=db.Column(db.String(50),nullable=False)
    name=db.Column(db.String(75),nullable=False)
    mobile=db.Column(db.String(15),nullable=False)
    address1=db.Column(db.String(200),nullable=False)
    address2=db.Column(db.String(200),nullable=False)
    city=db.Column(db.String(50),nullable=False)
    state=db.Column(db.String(50),nullable=False)
    zip=db.Column(db.Integer,nullable=False)
    subtotal=db.Column(db.Integer,nullable=False)
    charges=db.Column(db.Integer,nullable=False)
    total=db.Column(db.Integer,nullable=False)
    status=db.Column(db.String(20),nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Transaction(db.Model):
    __tablename__ = 'transaction'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    custId=db.Column(db.String(50),nullable=False)
    orderId=db.Column(db.String(50),nullable=False,unique=True)
    name=db.Column(db.String(75),nullable=False)
    tracking_id=db.Column(db.String(15),nullable=True)
    bank_ref_no=db.Column(db.String(75),nullable=True)
    amount=db.Column(db.String(15),nullable=True)
    order_status=db.Column(db.String(20),nullable=True)
    currency=db.Column(db.String(5),nullable=True)
    payment_mode=db.Column(db.String(20),nullable=True)
    failure_message=db.Column(db.String(100),nullable=True)


    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Edituploads(db.Model):
    __tablename__ = 'edituploads'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    custId=db.Column(db.String(50),nullable=True)
    sorter=db.Column(db.String(20),nullable=True)
    tshirtId=db.Column(db.String(50),nullable=True)
    tshirtImg=db.Column(db.String(200),nullable=True)
    printImg=db.Column(db.String(200),nullable=True)
    details=db.Column(db.String(100),nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Carts(db.Model):
    __tablename__ = 'carts'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    publicId=db.Column(db.String(50),nullable=False,unique=True)
    custId=db.Column(db.String(50),nullable=False)
    type=db.Column(db.String(25),nullable=False)
    tshirtId=db.Column(db.String(50),nullable=False)
    printId=db.Column(db.String(50),nullable=False)
    theme=db.Column(db.String(20),nullable=False)
    details=db.Column(db.String(200),nullable=False)
    colour=db.Column(db.String(25),nullable=True)
    size=db.Column(db.String(25),nullable=True)
    price=db.Column(db.Integer,nullable=False)
    quantity=db.Column(db.Integer,nullable=True)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }

class Chats(db.Model):
    __tablename__ = 'chats'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True,unique=True)
    custId=db.Column(db.String(50),db.ForeignKey('customers.publicId'),nullable=False)
    sender=db.Column(db.String(50),nullable=False)
    receiver=db.Column(db.String(50),nullable=False)
    msg=db.Column(db.String(250),nullable=False)
    date=db.Column(db.DateTime, default=datetime.now(),nullable=True)
    customer = db.relationship('Customers', backref='chats')
    def toDict(self):
        return { c.key: getattr(self, c.key) for c in inspect(self).mapper.column_attrs }