class Todo(db.Model):
__tablename__ = "todo"
id = db.Column('id', db.Integer, primary_key=True)
category_id = db.Column('category_id', db.Integer,
db.ForeignKey('category.id'))
priority_id = db.Column('priority_id', db.Integer,
db.ForeignKey('priority.id'))
description = db.Column('description', db.Unicode)
creation_date = db.Column('creation_date', db.Date)
is_done = db.Column('is_done', db.Boolean)
priority = db.relationship('Priority', foreign_keys=priority_id)
category = db.relationship('Category', foreign_keys=category_id)
class Task(db.Model):
__tablename__ = 'task'
id = db.Column('id', db.Integer, primary_key = True)
description = db.Column('description',db.String(140))
category = db.Column('category', db.String(50), db.ForeignKey(Category.name))
priority = db.Column('priority', db.String(50), db.ForeignKey(Priority.name))
priority_r = db.relationship('Priority', foreign_keys=priority)
category_r = db.relationship('Category', foreign_keys=category)
def __init__(self, desc,cat, pri):
self.description = desc
self.category = cat
self.priority = pri
# db.create_all()
class Todo(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(50))
description = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f'Todo("{self.title}")'
class Task(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(30), nullable=False)
description = db.Column(db.String(120), nullable=False)
deadline = 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 f'<Task({self.title}{self.deadline})>'
class Task(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(50), nullable=False)
content = db.Column(db.Text, nullable=False)
done = db.Column(db.Boolean, default=False)
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 f"(Task ('{self.title}', '{self.created}' )"
class ToDoList(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,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"List('{self.title}', '{self.date_posted}')"
class TodoList(db.Model):
__tablename__ = 'todo_lists'
id: int = db.Column(db.Integer, primary_key=True, autoincrement=True)
name: str = db.Column(db.String(100), nullable=False)
user_id: int = db.Column(db.Integer, db.ForeignKey('users.id'))
user: User = db.relationship('User')
created_at: datetime = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
updated_at: datetime = db.Column(db.DateTime, nullable=False, default=datetime.utcnow, onupdate=datetime.utcnow)
def __repr__(self):
return 'List({}, name: {}, owner: {}, created: {}, updated: {})'.format(self.id, self.name, self.user_id,
self.created_at, self.updated_at)
class Task(db.Model):
__tablename__ = 'tasks'
id: int = db.Column(db.Integer, primary_key=True, autoincrement=True)
list_id: int = db.Column(db.Integer, db.ForeignKey('todo_lists.id'))
list: TodoList = db.relationship('TodoList', backref='tasks')
desc: str = db.Column(db.String(500), nullable=False)
status: int = db.Column(db.Integer, default=0, nullable=False)
created_at: datetime = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
updated_at: datetime = db.Column(db.DateTime, nullable=False, default=datetime.utcnow, onupdate=datetime.utcnow)
def __repr__(self):
return 'Task({}, list: {}, desc: {}, created: {}, updated: {})'.format(self.id, self.list_id, self.desc,
self.created_at, self.updated_at)