class Todo(db.Model): id = db.Column(db.Integer, primary_key=True) task = db.Column(db.Text(), nullable=False) owner = db.Column(db.String(225)) status = db.Column(db.String(100)) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __init__(self, data): self.id = data.get('id') self.task = data.get('task') self.owner = data.get('owner') self.user_id = data.get('user') self.status = data.get('status') def save(self): db.session.add(self) db.session.commit() return self.id @classmethod def get_task(cls, task_id): return cls.query.get(task_id) @property def serialize(self): return { "id": self.id, "task": self.task, "owner": self.owner, "status": self.status, "creator": self.user_id }
class Tasks(db.Model): Id = db.Column(db.Integer, primary_key=True) taskName = db.Column(db.String(100), nullable=False, unique=True) status = db.Column(db.Boolean, default=False) tid = db.Column(db.Integer, db.ForeignKey('lists.Id', ondelete='CASCADE'), nullable=False)
class Tasksum(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) description = db.Column(db.Text(20000), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) task_id = db.Column(db.Integer, db.ForeignKey("tasks.id"), nullable=False) def __repr__(self): return f"Task('{self.title}','{self.description}')"
class Activities(db.Model): __tablename__ = 'activities' id = db.Column(db.Integer, primary_key=True) activity = db.Column(db.String(50), nullable=False) completed = db.Column(db.Boolean, default=False) todo_id = db.Column(db.Integer, db.ForeignKey('todo.id')) def __repr__(self): return f"Activities('{self.activities}')"
class Tag(db.Model, BaseModel): __tablename__ = 'blog_tags' id = db.Column(db.Integer, primary_key=True) post_id = db.Column(db.Integer, db.ForeignKey('blog_posts.id')) name = db.Column(db.String(128), unique=True) posts = relationship("Post", back_populates="tags") def __repr__(self): return self.name
class TaskList(db.Model): id = db.Column(db.Integer, primary_key=True) task_name = db.Column(db.String(140)) task_status = db.Column(db.Integer, default=0) date_created = db.Column(db.DateTime, index=True, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<{}>'.format(self.task_name)
class Mission(db.Model): id = db.Column(db.Integer, primary_key=True) content = db.Column(db.Text, nullable=False) done = db.Column(db.Boolean, nullable=False, default=False) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<Mission {}>'.format(self.content)
class Todo(db.Model): id = db.Column(db.Integer, primary_key=True) post_time = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) todo_item = db.Column(db.Text, nullable=False) completed = db.Column(db.Boolean, nullable=False, default=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"{self.todo_item}"
class Post(db.Model, BaseModel): __tablename__ = 'blog_posts' id = db.Column(db.Integer, primary_key=True) channel = db.Column(db.ForeignKey(Channel.name)) name = db.Column(db.String(128), unique=True, index=True) content = db.Column(db.Text) publish_time = db.Column(db.DateTime, default=datetime.utcnow) update_time = db.Column(db.DateTime, default=datetime.utcnow) tags = relationship("Tag", back_populates="posts") is_published = db.Column(db.Boolean, default=False)
class UserTodo(db.Model): id = db.Column(db.Integer, primary_key = True) todo_item = db.Column(db.String) item_due_date = db.Column(db.String(10)) todo_item_note = db.Column(db.String(300)) create_date = db.Column(db.DateTime) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<UserTodo %r>' % (self.todo_item)
class Todo(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(50), nullable=False) content = db.Column(db.String(200), nullable=False) completed = db.Column(db.Integer, default=0) created_date = db.Column(db.DateTime, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return '<Task %r>' % self.title
class Todo(db.Model): # cree une table Todo avec different attribue ci-dessus id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(length=30), nullable=False) category = db.Column( db.String(length=30), nullable=False, ) share = db.Column(db.Boolean(), nullable=False, default=False) owner = db.Column(db.Integer(), db.ForeignKey('user.id')) date_added = db.Column(db.DateTime, default=datetime.datetime.utcnow)
class Task(db.Model): __tablename__ = 'tasks' id = db.Column(db.Integer, primary_key=True) description = db.Column(db.Text, nullable=False) completed_on = db.Column(db.DateTime) created_by = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) creator = db.relationship('User', backref='tasks')
class Todo(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) subject = db.Column(db.String(100), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column( db.Integer, db.ForeignKey("user.id", ondelete="CASCADE"), nullable=False ) task = db.relationship("Tasks", backref="todo", lazy=True, passive_deletes=True) def __repr__(self): return f"Todo('{self.id}' '{self.title}','{self.subject}','{self.date}','{self.content}','{self.user_id}')"
class Tasks(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) todo_id = db.Column( db.Integer, db.ForeignKey("todo.id", ondelete="CASCADE"), nullable=False ) tasksum = db.relationship( "Tasksum", backref="todo", lazy=True, passive_deletes=True ) def __repr__(self): return f"Task('{self.title}','{self.date}','{self.todo_id}')"
class Lists(db.Model): Id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200), nullable=False) tasks = db.relationship('Tasks', backref='listName', lazy=True, cascade="all") uid = db.Column(db.Integer, db.ForeignKey('users.Id', ondelete="CASCADE"), nullable=False) def __repr__(self): return f'{self.name}: User: {self.username.username}'
class Tasks(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) adddate = db.Column(db.DateTime, nullable=False, default=datetime.datetime.utcnow) duedate = db.Column(db.DateTime) label = db.Column(db.String(100), nullable=False) priority = db.Column(db.String(100), nullable=False) status = db.Column(db.String(100), nullable=False) user_id = db.Column( db.Integer, db.ForeignKey("user.id", ondelete="CASCADE"), nullable=False ) def __repr__(self): return f"Todo('{self.id}' '{self.title}','{self.adddate}','{self.duedate}','{self.user_id}','{self.label}','{self.priority}','{self.status}')"
class UserInfo(db.Model): __tablename__ = 'userinfo' id = db.Column(db.Integer, primary_key=True) user = db.Column(db.ForeignKey('users.id')) sex = db.Column(db.Boolean, nullable=True) first_name = db.Column(db.String(128), nullable=True) last_name = db.Column(db.String(128), nullable=True) phone_number = db.Column(db.String(11), nullable=True) picture = db.Column(db.String(256), nullable=True) birthday = db.Column(db.DateTime, default=datetime.datetime.utcnow) updated_at = db.Column(db.DateTime, default=datetime.datetime.utcnow) def __repr__(self): return '<UserInfo: %d, %r>' % (self.id, self.owner)
class Subtask(db.Model): Subid = db.Column(db.Integer, primary_key=True, autoincrement=True) SubTitle = db.Column(db.String(100), nullable=False) SubDueDate = db.Column(db.Date, nullable=False, default=datetime.utcnow) SubDescription = db.Column(db.String(100), nullable=False) UnderTitle = db.Column(db.Integer, db.ForeignKey('task.TitleId'), nullable=False) SubStatus = db.Column(db.Boolean, default=True) def __repr__(self): return "Subtask('{}','{}', '{}','{}','{}','{}')".format( self.Subid, self.SubTitle, self.SubDueDate, self.SubDescription, self.SubStatus, self.UnderTitle)
class Bookmark(db.Model): id = db.Column(db.Integer, primary_key=True) url = db.Column(db.Text, nullable=False) date = db.Column(db.DateTime, default=datetime.utcnow) description = db.Column(db.String(300)) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) #the many side get the foreign key @staticmethod def newest(): return Bookmark.query.order_by(desc(Bookmark.date)) def __str__(self): return f'<Bookmark {self.description}:{self.url}'
class TodoCard(db.Model): __tablename__ = 'todo_card' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60), index=True) active = db.Column(db.Boolean, default=True, index=True) status = db.Column(db.String(60), index=True, default='draft') todo = db.relationship('Todo', backref='todo_card', lazy='dynamic') user_id = db.Column(db.Integer, db.ForeignKey('todo_user.id')) @property def items(self): return Todo.query.filter(Todo.todo_card_id == self.id).order_by( Todo.d_create).all()
class Note(db.Model): __tablename__ = "note" id = db.Column(db.Integer, primary_key=True) text = db.Column(db.Text, nullable=False) done = db.Column(db.Boolean, default=False, nullable=False) deleted = db.Column(db.DateTime, nullable=True) created = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __init__(self, text, user_id, done=0): self.text = text self.done = done self.user_id = user_id def __repr__(self): return f"Note('{self.id}', {self.text}','{self.created}', '{self.user_id}')"
class User(ProjectUserMixin, CharacterMixin, db.Model): __tablename__ = 'todo_user' id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(50), unique=True, nullable=False) password = db.Column(db.String(250)) first_name = db.Column(db.String(250)) last_name = db.Column(db.String(250)) active = db.Column(db.Boolean, default=True) d_create = db.Column(db.DateTime(timezone=True)) todo_card = db.relationship('TodoCard', backref='user', lazy='dynamic') todo = db.relationship('Todo', backref='user', lazy='dynamic') character_id = db.Column(db.Integer, db.ForeignKey('todo_character.id')) def __str__(self): return f'<User {self.id} {self.email}>' or '---'
class Todo(db.Model): __tablename__ = 'todos' id = db.Column(db.Integer, primary_key=True) titulo = db.Column(db.String(20)) descripcion = db.Column(db.Text, nullable=True) fecha = db.Column(db.DateTime) listo = db.Column(db.Boolean, default=False) usuario_id = db.Column(db.Integer, db.ForeignKey('usuarios.id')) def __init__(self, titulo=None, descripcion=None, fecha=None, listo=None): self.titulo = titulo self.descripcion = descripcion self.listo = listo if fecha is None: fecha = datetime.utcnow() self.fecha = fecha def __repr__(self): return '<Todo %r>' % self.titulo