def registration_form():
"""Allow users to register, only their email and pw is required. """
if request.method == 'GET':
return render_template("/users/register.html")
else:
user_email = request.form.get("email")
pw = request.form.get("pw")
fname = request.form.get("fname")
lname = request.form.get("lname")
zipcode = request.form.get("zipcode")
picture = request.form.get("picture")
linkedin = request.form.get("linkedin")
role = request.form.get("role")
new_user = User(email=user_email,
pw=pw,
fname=fname,
lname=lname,
zipcode=zipcode,
linkedin=linkedin,
role=role,
picture=picture)
db.session.add(new_user)
db.session.commit()
# session['user_id'] = request.form['user_id']
session['user_id'] = new_user.user_id
# add preset todo items for user
user_id = session['user_id']
# datetime for todo date
now = datetime.now()
anp = "Add First Project"
anc = "Add First Crewmember"
phref = "/projects"
chref = "/crew"
add_new_project = Todo(user_id=new_user.user_id,
task_name=anp,
task_date=now,
task_completion=False,
task_link=phref)
add_new_crewmember = Todo(user_id=new_user.user_id,
task_name=anc,
task_date=now,
task_completion=False,
task_link=chref)
db.session.add(add_new_project)
db.session.commit()
db.session.add(add_new_crewmember)
db.session.commit()
return redirect('/dashboard')
def example_data():
Entry.query.delete()
Todo.query.delete()
User.query.delete()
#users
brighticorn = User(
name='Brighticorn',
user_id=1,
email='*****@*****.**',
password=
'******',
zipcode='94566')
pairprogrammer = User(
name='PairProgrammer',
user_id=2,
email='*****@*****.**',
password=
'******',
zipcode='94588')
#entries
be1 = Entry(user_id=1,
date='2018-10-3',
title='Entry Title',
text='Entry body text',
quote='Some random quote for the day',
weather='Sunny')
be2 = Entry(user_id=1,
date='2018-10-4',
title='Another Title',
text='Some text to go in entry body',
quote='another quote',
weather='Cloudy')
pe1 = Entry(user_id=2,
date='2018-10-3',
title='Testing same date',
text='Enrty body for testing same date',
quote='some quote',
weather='Snowy')
pe2 = Entry(user_id=2,
date='2018-10-16',
title='Test Title',
text='Some text for an entry body',
quote='daily quote',
weather='Sunny')
#todo
bt1 = Todo(user_id=1, todo_id=1, todo='wash dishes')
bt2 = Todo(user_id=1, todo_id=2, todo='laundry')
pt1 = Todo(user_id=2, todo_id=3, todo='sweep/mop')
db.session.add_all(
[brighticorn, pairprogrammer, be1, be2, pe1, pe2, bt1, bt2, pt1])
db.session.commit()
def find_todo(username):
to_list = []
sql = 'select * from todo where username="******"'.format(username)
cur = db.cursor()
cur.execute(sql)
data = cur.fetchall()
for item in data:
if item is None:
continue
to_list.append(Todo(*item))
return to_list
if data is None:
return data
return Todo(*data)
async def fetch_all_todos():
todos = []
cursor = collection.find({})
async for doc in cursor:
todos.append(Todo(**doc))
return todos
def get_all_todos() -> List[Todo]:
c.execute('select * from todos')
results = c.fetchall()
todos = []
for result in results:
todos.append(Todo(*result))
return todos
def add(self, sender, liste, msg):
if liste == "all":
return "On ne peut pas nommer une liste 'all'"
todo = Todo(liste, msg, sender, time.time())
self.bot.session.add(todo)
self.bot.session.commit()
return "TODO ajouté"
def setUp(self):
""" Creates a random todo we add manually to the database """
todo_list = string_gen(8)
todo_msg = string_gen(50)
self.todo = Todo(todo_list, todo_msg, "sender", time.time())
self.bot.session.add(self.todo)
self.bot.session.commit()
def add_todo(text, complete):
"""ToDo item"""
todo = Todo(text=text, complete=False)
db.session.add(todo)
db.session.commit()
return todo
def testGet(self):
todo1 = {'title': 'test1', 'order': 1, 'completed': False}
key = Todo(**todo1).put()
todo1['id'] = key.id()
request = webapp2.Request.blank('/api/todos')
response = request.get_response(main.app)
self.assertEqual([todo1], json.loads(response.body))
def update_todo():
"""Add todo item to database"""
todo = request.form.get("todo")
finduser = User.query.filter_by(email=session["email"]).first()
new_todo = Todo(user_id=finduser.user_id, todo=todo)
db.session.add(new_todo)
db.session.commit()
return todo
def create_todo(current_user):
data = request.get_json()
new_todo = Todo(text=data['text'], complete=False, user_id=current_user.id)
db.session.add(new_todo)
db.session.commit()
return jsonify({'message': 'Todo created!'})
def load_todo():
"""Load todo list into database."""
autotask = ["Add First Project", "Add First Crewmember"]
task_date = datetime.now()
for i in autotask:
new_todo = Todo(task_name=i, task_date=task_date)
db.session.add(new_todo)
db.session.commit()
def post(self, edit_id):
done = self.request.get("done")
task = Todo().get_by_id(int(edit_id))
task.task = self.request.get("task")
if done == "1":
task.done = True
else:
task.done = False
task.put()
params = {"task": task}
return self.render_template("edit.html", params)
def post_todo():
myform = form.CreateTodoForm(request.form)
if not myform.validate():
abort(400, myform.errors)
name = request.form['name']
if service.get_by_name(name) is None:
created_date = datetime.datetime.now()
newtodo = Todo(None, name, False, created_date, None)
service.add(newtodo)
return jsonify(newtodo.json()), 201
return "Post failed because todo name already exists", 400
def index():
if request.method == "POST":
task_content = request.form['content']
new_task = Todo(content=task_content)
db.add(new_task)
db.commit()
return redirect("/")
else:
tasks = db.query(Todo).all()
return render_template("index.html", tasks=tasks)
def load_todos():
"""Load todos from todo.item into database."""
print("Todos")
for row in open("seed_data/todo.item"):
row = row.rstrip()
todo_id, user_id, todo = row.split("|")
todo = Todo(todo_id = todo_id,
user_id = user_id,
todo = todo)
db.session.add(todo)
db.session.commit()
def setUp(self):
""" Creates 3 random todo we add manually to the database """
self.todos = []
todos = {
string_gen(8): string_gen(50),
string_gen(8): string_gen(50),
string_gen(8): string_gen(50)
}
for list_name, todo in todos.iteritems():
todo = Todo(list_name, todo, "sender", time.time())
self.bot.session.add(todo)
self.bot.session.commit()
self.todos.append(todo)
def print_template(self):
user = users.get_current_user()
if user:
is_user = True
user_url = users.create_logout_url('/')
else:
is_user = False
user_url = users.create_login_url('/')
tasks = Todo().query().fetch()
params = {
"tasks": tasks,
"user": user,
"is_user": is_user,
"user_url": user_url
}
return self.render_template("hello.html", params)
def createTodo(self, payload):
auth = sec.context.get_auth()
newTodo = Todo(
title=payload.get("title"),
description=payload.get("description"),
createdBy=auth.user_id
)
try:
newTodo.save()
except ValidationError as error:
errorMessage = {
"msg": str(error)
}
return json.dumps(errorMessage)
return newTodo.to_json()
def new():
if request.method == 'POST':
category = Category.query.filter_by(
id=request.form['category']).first()
#priority = Priority.query.filter_by(id=request.form['priority']).first()
#todo = Todo(category=category, priority=priority, description=request.form['description'])
todo = Todo(category=category, description=request.form['description'])
db.session.add(todo)
db.session.commit()
return redirect(url_for('list_all'))
else:
return render_template(
'new-task.html',
page='new-task',
categories=Category.query.all(),
#priorities=Priority.query.all()
)
def slack_todos():
res = request.form['text'].split(' ')
cmd, *args = res
ret_msg = ''
if cmd == 'create':
todo_name = args[0]
todo = Todo()
todo.title = todo_name
db.session.add(todo)
db.session.commit()
ret_msg = 'todo created'
elif cmd == 'list':
pass
return ret_msg
def add_todo_item(parent_username, item_title, item_urgency):
new_item = Todo(parent_username=parent_username,
item_title=item_title,
item_urgency=item_urgency)
session1.add(new_item)
session1.commit()
return True
except Exception, e:
db.rollback() # ERROR RETURN FALSE
print e
return False
def delete_todo(id):
sql_todo_list = 'delete from todo where id="{}"'.format(id)
cur = db.cursor()
try:
cur.execute(sql_todo_list) # 执行sql语句
db.commit()
return True
except Exception, e:
print e
db.rollback() # ERROR RETURN FALSE
return False
if __name__ == '__main__':
# for i in find('luxi'):
# print i.title, i.id, i.finish
#
# t = Todo('4', 'fishing',1, 'luxi')
# print update(t)
c = Todo(2, 'watching', 1, 'luxi')
print update_todo(c)
# print delete('luxi')
def add(task: str, category: str):
typer.echo(f"adding {task}, {category}")
todo = Todo(task, category)
insert_todo(todo)
show()
from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from model import Todo, Base, User from DAL import dal dal.connect() session = dal.Session() # Insert a User in the User table new_user = User(name='sksun') session.add(new_user) session.commit() # Insert an Todo in the Todo table new_todo = Todo(text='Another todo by sksun from sql-alchemy', isdone=False, user=user) session.add(new_todo) session.commit()
def post(self):
task = self.request.get("task")
todo = Todo()
todo.task = task
todo.put()
return self.print_template()
def get(self, delete_id):
task = Todo().get_by_id(int(delete_id))
params = {"task": task.task}
return self.render_template("delete.html", params)
def post(self):
j = json.loads(self.request.body)
key = Todo(**j).put()
self.response.out.write(json.dumps({'id': key.id()}))
def post(self, delete_id):
task = Todo().get_by_id(int(delete_id))
task.key.delete()
return self.redirect_to("home")
def get(self, edit_id):
task = Todo().get_by_id(int(edit_id))
params = {"task": task}
return self.render_template("edit.html", params)
