models.py

# from app import db
from rdb import db
from datetime import date, datetime

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    uname = db.Column(db.String(30))
    upass = db.Column(db.String(30))
    email = db.Column(db.String(30))
    name = db.Column(db.String(30))
    roll_no = db.Column(db.String(20))
    branch = db.Column(db.String(30))
    # date_of_join = db.Column(db.DateTime())
    usertags = db.relationship('UserTag', backref='user', lazy="dynamic")
    questions = db.relationship('Question', backref='user', lazy="dynamic")
    answers =  db.relationship('Answer', backref='user', lazy="dynamic")
    user_date = db.Column(db.DateTime)
    
    def __init__(self, uname, upass, email, name, roll_no, branch):
        self.uname = uname
        self.upass = upass
        self.email = email
        self.name = name
        self.roll_no = roll_no
        self.branch = branch
        user_date = date.today()
        self.user_date = user_date
     

        
        
    def __repr__(self):
        return ('<User {}>'.format(self.uname))

class Question(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    question_text = db.Column(db.String(1000))
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    question_tags = db.relationship('QuestionTag', backref='question', lazy = 'dynamic')#relatioship with question
    answers = db.relationship('Answer', backref='question', lazy = 'dynamic')
    qu_date = db.Column(db.DateTime)
    
    def __init__ (self,question_text,user):
        self.question_text = question_text
        self.user = user
        qu_date = date.today()
        self.qu_date = qu_date
        
    def __repr__(self):
        return ('<Question :{}>'.format(self.question_text))


class Answer(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    answer_text = db.Column(db.String(1000))
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
    ans_date = db.Column(db.DateTime)
    
    def __init__ (self,answer_text, user, question):
        self.answer_text = answer_text
        self.user = user
        self.question = question
        ans_date = date.today()
        self.ans_date = ans_date

    def __repr__(self):
        return ('<answer {}>'.format(self.answer_text))

class QuestionTag(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(1000))
    question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
    qt_date = db.Column(db.DateTime)
    
    def __init__ (self,name,question):
        self.name = name
        self.question = question
        qt_date = date.today()
        self.qt_date = qt_date

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

class UserTag(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(220))
    user_id =  db.Column(db.Integer, db.ForeignKey('user.id'))
    ut_date = db.Column(db.DateTime)
    
    def __init__(self, name, user):
        self.name = name
        self.user = user
        ut_date = date.today()
        self.ut_date = ut_date

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


# class AnswerTag(db.Model):
    # id = db.Column(db.Integer, primary_key=True)
    # answertagname = db.Column(db.String(1000))
    # answer_id =  db.Column(db.Integer, db.ForeignKey('answer.id'))#foreign key to link with answer
      
    # def __init__ (self,answertagname,answer):
        # self.answertagname = answertagname
        # self.answer = answer

    # def __repr__(self):
        # return ('<answertag {}>'.format(self.answertagname))