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
