class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String(255), nullable=False) completed = db.Column(db.Boolean, default=False, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) def __init__(self, user_id: str, description: str) -> None: self.user_id = user_id self.description = description @classmethod def get(cls, id: int) -> object: return cls.query.filter_by(id=id).first() @classmethod def add(cls, user_id: str, description: str) -> None: todo = cls(user_id, description) db.session.add(todo) db.session.commit() @classmethod def delete(cls, id: int) -> None: todo = cls.get(id) db.session.delete(todo) db.session.commit() @classmethod def toggle_completion(cls, id: int) -> None: todo = cls.get(id) todo.completed = not todo.completed db.session.commit() @classmethod def paginate(cls, user_id: int, page: int) -> Pagination: """ Uses SQLAlchemy's builtin pagination tools to return paginated queries :param user_id: specifies the user who's tasks are to be gotten :param page: target page number :return: flask_sqlalchemy.Pagination object for use in views """ return cls.query.filter_by(user_id=user_id).paginate( page=page, per_page=app.config.get('PAGE_ITEM_LIMIT', 5), error_out=False) def to_dict(self) -> dict: return { 'id': self.id, 'description': self.description, 'completed': self.completed, 'user_id': self.user_id } def json(self) -> str: return jsonify(self.to_dict()) def __repr__(self) -> str: return '<Todo %r>' % self.description
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String(300)) completed = db.Column(db.Boolean) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) user = db.relationship('User', backref=db.backref('todos', lazy='dynamic')) def __init__(self, description, user): self.description = description self.user = user @db.validates('description') def validate_description(self, key, description): if not description: raise ValueError('Description cannot be empty') return description def as_dict(self): return {c.name: getattr(self, c.name) for c in self.__table__.columns} def __repr__(self): return '<Todo %r>' % self.description
class Todos(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255),nullable=False) is_completed = db.Column(db.Boolean, unique=False, default=False) def __repr__(self): return '<Todos %r>' % (self.description)
class Todo(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) description = db.Column(db.String(255)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) completed = db.Column(db.Boolean, default=False) def __repr__(self): return '<Todo #{}>'.format(self.id)
class todos(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255)) completed = db.Column(db.Boolean) def __repr__(self): return '<todo {}>'.format(self.description)
class Todo(db.Model): __tablename__ = 'todos' id = Column(Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = Column(String(256), nullable=False) is_completed = Column(Integer, default=0) created_dt = Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) def __repr__(self): return '<Todo %r>' % (self.description)
class Todos(db.Model): __tablename__ = "todos" id = db.Column('id', db.Integer, unique=True, nullable=False, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255)) completed = db.Column(db.Boolean, default=False) def as_dict(self): return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class Todos(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255), nullable=False) status = db.Column(db.String(255), nullable=False) def __repr__(self): return { 'id': self.id, 'user_id': self.user_id, 'description': self.description, 'status': self.status }
class Todo(db.Model): id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String(140)) completed = db.Column(db.Boolean, default=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __init__(self, description, user_id, completed=False): self.description = description self.completed = completed self.user_id = user_id def __repr__(self): return '<Todo desc={},completed={}>'.format(self.description, self.completed)
class Todos(db.Model): __tablename__ = 'todos' id = db.Column('todo_id', db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey(Users.id), nullable=False) description = db.Column(db.String(255), nullable=False) done = db.Column(db.Boolean) def serialize(self): return { 'id': self.id, 'users': self.user_id, 'description': self.description, 'done': self.done }
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String) completed = db.Column(db.Boolean) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) def to_dict(self): return dict(id=self.id, user_id=self.user_id, description=self.description, completed=self.completed) def __repr__(self): return '<Todo {}>'.format(self.description)
class Todo(db.Model): __tablename__ = "todos" id = db.Column(db.Integer, primary_key=True) description = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) completed = db.Column(db.Boolean, default=False) def __repr__(self): return f"Todo('{self.description}')" @validates('description') def validate_description(self, key, value): assert not value.isspace(), 'Description can not be only white space.' assert value != "", 'Description can not be empty.' return value
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255), nullable=False) completed = db.Column(db.Boolean, default=0) def __init__(self, user_id, description, completed): self.user_id = user_id self.description = description self.completed = completed def __repr__(self): return '<Todo: id=%r, completed=%r>' % (self.description, self.completed)
class Todos(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255)) completed = db.Column(db.Boolean, default=False) def __repr__(self): return '<Todos {}>'.format(self.id) def to_dict(self): return { 'id': self.id, 'user_id': self.user_id, 'description': self.description, 'completed': self.completed }
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) users = db.relationship('Users', backref='users') description = db.Column(db.String(255)) completed = db.Column(db.Boolean) def to_dict(self): return { 'id': self.id, 'user_id': self.user_id, 'description': self.description, 'completed': self.completed }
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String(255)) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) completed = db.Column(db.Boolean, default=False) def __repr__(self): return "To-Do <User.id {}>: {}".format(self.user_id, self.description) def to_json(self): return json.dumps({ 'id': self.id, 'user_id': self.user_id, 'description': self.description })
class Todo(db.Model): """Todo model.""" __tablename__ = "todos" id = db.Column(db.Integer, primary_key=True) user = db.Column('user_id', db.ForeignKey(User.id)) description = db.Column(db.String(255), nullable=False) completed = db.Column(db.Boolean, default=False) def __repr__(self): """__repr__ for Todo.""" return '<User %r>' % self.user def __init__(self, user, description): """__init__ for Todo model.""" self.user = user self.description = description
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255), nullable=False) complete = db.Column(db.Integer, nullable=False) def __repr__(self): return '<User %r Todo %r>' % self.user_id, self.description def get_dict(self): return { 'id': self.id, 'description': self.description, 'user_id': self.user_id, 'complete': bool(self.complete) }
class Todo(db.Model): __tablename__ = 'todos' users = db.relationship(User) id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) description = db.Column(db.String(255), nullable=False) is_completed = db.Column(db.BOOLEAN(), default=False) def __init__(self, description, user_id): self.description = description self.user_id = user_id def __repr__(self): return "Description: {description}".format( description=self.description) def to_dict(self): return {'id': self.id, 'description': self.description}
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) description = db.Column(db.String(255), unique=True) done = db.Column(db.Boolean, default=False) def __init__(self, user_id=None, description=None): self.user_id = user_id self.description = description self.done = False def __repr__(self): return '<Todo(user: {}) {}>'.format(self.user_id, self.description) @property def jsonified(self): return jsonify(id=self.id, done=self.done, description=self.description)
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) description = db.Column(db.String(255)) user_id = db.Column(db.Integer, db.ForeignKey('users.id')) completed = db.Column(db.Integer, default=0) def __repr__(self): return '<Todo {}>'.format(self.description) def mark_completed(self): self.completed = 1 def mark_uncompleted(self): self.completed = 0 def make_dict(self): return { "id" : self.id, "description" : self.description, "user_id" : self.user_id, "completed" : self.completed }
class Todos(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey(Users.id), nullable=False) description = db.Column(db.String(255), nullable=True) status = db.Column(db.String(255), nullable=False, default='TODO')