-
Notifications
You must be signed in to change notification settings - Fork 0
/
__init__.py
28 lines (20 loc) · 899 Bytes
/
__init__.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
from flask_sqlalchemy import SQLAlchemy
from app import app
dbURI = 'sqlite:///models/myDB.db'
""" database setup to support db examples """
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = dbURI
db = SQLAlchemy(app)
# declare the users database model
class Users(db.Model):
UserID = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(255), unique=True, nullable=False)
password = db.Column(db.String(255), unique=True, nullable=False)
# Declare emails database model
class Emails(db.Model):
UserID = db.Column(db.Integer, primary_key=True)
email_address = db.Column(db.String(255), unique=True, nullable=False)
# declare phone numbers database model
class PhoneNumbers(db.Model):
UserID = db.Column(db.Integer, primary_key=True)
phone_number = db.Column(db.String(255), unique=True, nullable=False)