from app import db


class User(db.Model):

    __tablename__ = "students"

    userid = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, nullable=False)
    password = db.Column(db.String, nullable=False)
    gender = db.Column(db.String, nullable=False)
    def __init__(self, userid, username, password,gender):
        seld.userid = userid
		self.username=username
        self.password=password
        self.gender=gender

    def __repr__(self):
        return '<name {}'.format(self.name)

Class Student(db.Model):
    __tablename__="student"
    stuid = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)
    rollno = db.Column(db.String, nullable=False)
    userid = db.Column(db.Integer)
	def __init__(self, stuid, name, rollno, userid,gender):
        self.stuid = stuid
        self.name = name
        self.rollno=rollno
        self.gender=gender


Class Room(db.Model):
    __tablename__ = "rooms"

    roomid = db.Column(db.Integer, primary_key=True)
    room_no = db.Column(db.String, nullable=False)
    occupancy = db.Column(db.Integer, nullable=False)
    occupied = db.Column(db.Boolean, nullable=False)
    roomtype = db.Column(db.String, nullable=False)#Stores Tower or Apartment.
    roomloc = db.Column(db.String, nullable=False)#Stores T1 T2 T3.
    occupant1 = db.Column(db.Integer)
    occupant2 = db.Column(db.Integer)
    occupant3 = db.Column(db.Integer)

    def __init__(self, roomid, room_no, occupancy,occupied,roomtype,roomloc):
        self.roomid = roomid
        self.room_no = room_no
        self.occupancy=occupancy
        self.occupied = occupied
        self.roomtype = roomtype
        self.roomloc = roomloc

    def __repr__(self):
        return '<room_no{}'.format(self.room_no)