class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
messages = db.relationship('Message', backref='author', lazy=True)
def __str__(self):
return self.username
class Message(db.Model):
__tablename__ = 'message'
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.String(STRING_LEN), nullable=False)
emotion = db.Column(db.Enum('angry', 'scared', 'sad', 'happy', 'normal'))
timestamp = db.Column(db.DateTime)
family_id = db.Column(db.Integer, db.ForeignKey('family.id'))
sender_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
place = db.Column(db.String(STRING_LEN))
class Message(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.String(150), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __str__(self):
return self.id
class Ans(db.Model):
__tablename__ = 'ans'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
ans_desc = db.Column(db.String(10000), nullable=False)
def __init__(self, ans_desc):
self.ans_desc = ans_desc
def __ref__(self):
return f"chatbot_ans('{self.ans_id}' , '{self.ans_desc}')"
class Family(db.Model):
__tablename__ = 'family'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(STRING_LEN), nullable=False)
slug = db.Column(db.String(STRING_LEN))
admin_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
home_lat = db.Column(db.Float)
home_long = db.Column(db.Float)
def __unicode__(self):
return self.name
def get_absolute_url(self):
return url_for('room', slug=self.slug)
def save(self, *args, **kwargs):
if not self.slug:
self.slug = slugify(self.name)
db.session.add(self)
db.session.commit()
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.String(80), unique=True)
email = db.Column(db.String(120), unique=True)
name = db.Column(db.String(120), unique=True)
def __init__(self, user_id, email, name):
self.user_id = user_id
self.email = email
self.name = name
def __repr__(self):
return '<User %r>' % self.user_id
def get_dict(self):
return dict(id=self.id, user_id=self.user_id, email=self.email,
name=self.name)
class User(db.Model, flask_login.UserMixin):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(STRING_LEN), nullable=False)
email = db.Column(db.String(STRING_LEN))
status_code = db.Column(db.SmallInteger, default=INACTIVE)
work_lat = db.Column(db.Float)
work_long = db.Column(db.Float)
_password = db.Column('password', db.String(STRING_LEN), nullable=False)
def _get_password(self):
return self._password
def _set_password(self, password):
self._password = generate_password_hash(password)
# Hide password encryption by exposing password field only.
password = db.synonym('_password',
descriptor=property(_get_password, _set_password))
type_id = db.Column(db.Integer, db.ForeignKey('user_type.id'))
family_id = db.Column(db.Integer, db.ForeignKey('family.id'))
def check_password(self, password):
if self.password is None:
return False
return check_password_hash(self.password, password)
@classmethod
def authenticate(cls, email, password):
user_login = cls.query.filter(User.email == email).first()
if user_login:
authenticated = user_login.check_password(password)
else:
authenticated = False
return user_login, authenticated
class Connection(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
provider_id = db.Column(db.String(255))
provider_user_id = db.Column(db.String(255))
access_token = db.Column(db.String(255))
secret = db.Column(db.String(255))
display_name = db.Column(db.String(255))
profile_url = db.Column(db.String(512))
image_url = db.Column(db.String(512))
rank = db.Column(db.Integer)
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(60),
nullable=False,
unique=True,
index=True)
hash_password = db.Column(db.String(128), nullable=True)
email = db.Column(db.String(80), unique=True, index=True)
# tasks = db.relationship('Task', backref='user', lazy='dynamic')
rooms = db.relationship('Room',
secondary=userroom,
lazy='subquery',
backref="users")
messages = db.relationship('Message', backref="user", lazy='dynamic')
def __repr__(self):
return f'User {self.id} ; name="{self.username}"'
def set_password(self, pw):
self.hash_password = generate_password_hash(pw)
def check_password(self, pw):
return check_password_hash(self.hash_password, pw)
class SensorValue(db.Model):
__tablename__ = 'sensor_value'
id = db.Column(db.Integer, primary_key=True)
value = db.Column(db.String(STRING_LEN), nullable=False)
timestamp = db.Column(db.DateTime)
sensor_id = db.Column(db.Integer, db.ForeignKey('sensor.id'))
@property
def serialize(self):
"""Return object data in easily serializeable format"""
return {
'id': self.id,
'value': self.value,
'sensor_id': self.sensor_id,
'timestamp': json.dumps(self.timestamp.isoformat())
}
class Sub_ques(db.Model):
__tablename__ = 'sub_ques'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
sub_ques_id = db.Column(db.Integer, nullable=False)
perv_ans_id = db.Column(db.Integer, db.ForeignKey(Ans.id), nullable=False)
next_ans_id = db.Column(db.Integer, db.ForeignKey(Ans.id), nullable=False)
sub_ques_desc = db.Column(db.String(1000), nullable=False)
def __init__(self, sub_ques_id, perv_ans_id, next_ans_id, sub_ques_desc):
self.sub_ques_id = sub_ques_id
self.perv_ans_id = perv_ans_id
self.next_ans_id = next_ans_id
self.sub_ques_desc = sub_ques_desc
def __ref__(self):
return f"chatbot_sub_ques('{self.sub_ques_id}' , '{self.perv_ans_id}' , '{self.next_ans_id}' , '{self.sub_ques_desc}')"
class Sensor(db.Model):
__tablename__ = 'sensor'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(STRING_LEN), nullable=False)
owner_user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
type_id = db.Column(db.Integer, db.ForeignKey('sensor_type.id'))
class SensorType(db.Model):
__tablename__ = 'sensor_type'
id = db.Column(db.Integer, primary_key=True)
typename = db.Column(db.String(STRING_LEN), nullable=False)
class Room(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(150), nullable=False)
messages = db.relationship("Message", backref="room", lazy="dynamic")