Python Column 예제들

예제 #1

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(20), unique=True, nullable=False)
    image_file = db.Column(db.String(20),
                           nullable=False,
                           default='default.jpg')
    password = db.Column(db.String(60), nullable=False)

    def get_reset_token(self, expires_sec=1800):
        s = Serializer(app.config['SECRET_KEY'], expires_sec)
        return s.dumps({'user_id': self.id}).decode('utf-8')

    def verify_reset_token(token):
        s = Serializer(app.config['SECRET_KEY'])
        print("Entered verify_reset_token() Method")
        try:
            user_id = s.loads(token)['user_id']
            print(user_id)
        except:
            print("Exception occured")
            return None
        return User.query.get(user_id)

    def __repr__(self):
        return "User('{}', '{}', '{}')".format(self.username, self.email,
                                               self.image_file)

예제 #2

파일: models.py 프로젝트: soniyamishra/Flask-Blog

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    image_file = db.Column(db.String(20),
                           nullable=False,
                           default="default.jpg")
    password = db.Column(db.String(60), nullable=False)
    posts = db.relationship('Post', backref='author', lazy=True)

    def get_reset_token(self, expires_sec=1800):
        s = Serializer(current_app.config['SECRET_KEY'], expires_sec)
        return s.dumps({'user_id': self.id}).decode('utf-8')

    @staticmethod
    def verify_reset_token(token):
        s = Serializer(current_app.config['SECRET_KEY'])
        try:
            user_id = s.loads(token)['user_id']
        except:
            return None
        return User.query.get(user_id)

    def __repr__(self):
        return f"User('{self.username}','{self.email}','{self.image_file}')"

예제 #3

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(30), unique=True, nullable=False)
    content = db.Column(db.Text, nullable=False)
    date_posted = db.Column(db.Date, nullable=False, default=datetime.utcnow)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return f"Post ('{self.title}', '{self.date_posted}', '{self.user_id}')"

예제 #4

파일: models.py 프로젝트: alwwi06/WeatherForeFlask

class Todo(db.Model):
    __tablename__ = 'todo'
    id = db.Column(db.Integer,primary_key=True) # these will be unique
    content = db.Column(db.String(200), nullable=False) # the user cannot leave it empty
    date_created = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return 'Task' + str(self.id)

예제 #5

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    date_posted = db.Column(db.DateTime, nullable=False)
    content = db.Column(db.Text, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=True)

    def __repr__(self):
        return f"Post('{self.title}', '{self.date_posted}')"

예제 #6

파일: models.py 프로젝트: alwwi06/WeatherForeFlask

class User(db.Model,UserMixin):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True,nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    password = db.Column(db.String(60), nullable=False)
    postss = db.relationship('Todo', backref='user',lazy=True)

    def __repr__(self):
        return f"User('{self.username}','{self.email}')"

예제 #7

파일: models.py 프로젝트: lenover-p/QTMA-Flask-Web-App

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    image_file = db.Column(db.String(20),
                           nullable=False,
                           default='default.jpg')
    password = db.Column(db.String(60), nullable=False)
    posts = db.relationship('Post', backref='author', lazy=True)

    def __repr__(self):
        return f"User('{self.username}', '{self.email}', '{self.image_file}')"

예제 #8

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    image_file = db.Column(db.String(20),
                           nullable=False,
                           default="default.jpg")
    password = db.Column(db.String(60), nullable=False)
    administrator = db.Column(db.Integer, nullable=True)
    posts = db.relationship("Post", backref="author", lazy=True)
    forename = db.Column(db.String(50), nullable=True)
    surname = db.Column(db.String(50), nullable=True)

    def get_reset_token(self, expires_sec=1800):
        s = Serializer(current_app.config["SECRET_KEY"], expires_sec)
        return s.dumps({"user_id": self.id}).decode("utf-8")

    @staticmethod
    def verify_reset_token(token):
        s = Serializer(current_app.config["SECRET_KEY"])
        try:
            user_id = s.loads(token)["user_id"]
        except:
            return None
        return User.query.get(user_id)

    def __repr__(self):
        return f"User: {self.forename} {self.surname} ({self.username}, {self.email}, {self.image_file}, {self.id})"

예제 #9

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(30), unique=True, nullable=False)
    email = db.Column(db.String(100), unique=True, nullable=False)
    image = db.Column(db.String(20), nullable=False, default='default.png')
    password = db.Column(db.String(60), nullable=False)
    posts = db.relationship('Post', lazy=True, backref='author')

    def __repr__(self):
        return f"User ('{self.username}', '{self.email}', '{self.image}')"

    def get_reset_token(self, expiry_time=600):
        serializer = Serializer(app.config['SECRET_KEY'], expiry_time)
        return serializer.dumps({'user_id': self.id}).decode('utf-8')

    def verify_token(token):
        serializer = Serializer(app.config['SECRET_KEY'])
        try:
            user_id = serializer.loads(token)['user_id']
        except:
            return None
        return User.query.get(user_id)

예제 #10

파일: auth.py 프로젝트: dynamo63/flask-blog

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    image_file = db.Column(db.String(100), nullable=False, default='default.png')
    password = db.Column(db.String(70), nullable=False)
    created_at = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
    date_of_birth = db.Column(db.Date, nullable=True)

    def __repr__(self):
        return f"Username {self.username}({self.email})"

예제 #11

파일: blog.py 프로젝트: dynamo63/flask-blog

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(120), nullable=False)
    slug = db.Column(db.String(50), unique=True, default=secrets.token_urlsafe)
    content = db.Column(db.Text, nullable=False)
    created_at = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
    author_id = db.Column(db.Integer, db.ForeignKey('user.id'),nullable=False)
    author =  db.relationship('User', backref=db.backref('posts', lazy=True))

    def __repr__(self):
        return f'Post {self.title} written by {self.author}'

예제 #12

파일: models.py 프로젝트: msunilhyd/FlaskBlog

class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    date_posted = db.Column(db.DateTime(timezone=True),
                            nullable=False,
                            default=datetime.now)
    content = db.Column(db.Text, nullable=False)
    post_image_file = db.Column(db.String(30))
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    def __repr__(self):
        return "Post('{}','{}''{}')".format(self.title, self.date_posted,
                                            self.user_id)

예제 #13

class Vote(db.Model):
    user_id = db.Column(db.Integer, primary_key=True)
    post_id = db.Column(db.Integer, nullable=False)