def manifest(self,queryId):
with celery.app.app_context():
from project.models import YoutubeQuery, Task
query = YoutubeQuery.query.filter_by(id=queryId).first()
#create the ORM Task Model for the database
current_task = Task(self.request.id,"ManifestFetcher")
query.tasks.append(current_task)
db.session.commit()
fetcher = YouTubeMPDFetcher("https://www.youtube.com/get_video_info",queryId,1,1,self)
result = fetcher.work()
current_task.result = json.dumps(result)
current_task.state = result['state']
db.session.commit()
return result
def meta(self,queryId,parameters):
with celery.app.app_context():
from project.models import YoutubeQuery, Task
query = YoutubeQuery.query.filter_by(id=queryId).first()
#create the ORM Task Model for the database
current_task = Task(self.request.id,"MetaFetcher")
query.tasks.append(current_task)
db.session.commit()
parameter = {}
parameter['queryId'] = queryId
queryRaw = json.loads(query.queryRaw)
parameter['key'] = queryRaw['key']
fetcher = YouTubeMetaFetcher("https://www.googleapis.com/youtube/v3/videos",parameter,int(parameters['HTTPClients']),int(parameters['ClientConnectionPool']),self)
result = fetcher.work()
current_task.result = json.dumps(result)
current_task.state = result['state']
db.session.commit()
return result
def fetch(self,queryId,parameters):
with celery.app.app_context():
from project.models import YoutubeQuery, Task
query = YoutubeQuery.query.filter_by(id=queryId).first()
#create the ORM Task Model for the database
current_task = Task(self.request.id,"IDFetcher")
query.tasks.append(current_task)
db.session.commit()
parameter = {}
parameter['queryId'] = queryId
parameter['queryRaw'] = query.queryRaw
logger.info("Start fetching ids for query id :"+str(parameter['queryId'])+" with parameter: "+parameter['queryRaw'])
fetcher = YouTubeIDFetcher("https://www.googleapis.com/youtube/v3/search",parameter,int(parameters['HTTPClients']),int(parameters['ClientConnectionPool']),self)
result = fetcher.work()
current_task.result = json.dumps(result)
current_task.state = result['state']
db.session.commit()
return result
def downloadVideos(self,queryId,options):
with celery.app.app_context():
from project.models import YoutubeQuery, Task
query = YoutubeQuery.query.filter_by(id=queryId).first()
#create the ORM Task Model for the database
current_task = Task(self.request.id,"VideoFetcher")
query.tasks.append(current_task)
db.session.commit()
option = {}
option['queryId'] = queryId
option['resolution'] = options['resolution']
option['sound'] = options['sound'] if 'sound' in options else False
option['method'] = options['method'] if 'method' in options else 'all'
option['amount'] = options['amount'] if option['method']=='random' else 0
fetcher = YouTubeVideoFetcher('https://www.youtube.com/get_video_info',option, 1, 1, self)
result = fetcher.work()
current_task.result = json.dumps(result)
current_task.state = result['state']
db.session.commit()
return result
def new_task():
import datetime
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data,
form.due_date.data, form.priority.data,
datetime.datetime.utcnow(), '1',
session['user_id'])
db.session.add(new_task)
db.session.commit()
flash('New entry was successfully posted. Thanks.')
return redirect(url_for('tasks.tasks'))
else:
return render_template('tasks.html', form=form, error=error)
def test_string_reprsentation_of_the_task_object(self): from datetime import date db.session.add( Task( "Run around in circles", date(2015, 1, 22), 10, date(2015, 2, 23), 1, 1 ) ) db.session.commit() tasks = db.session.query(Task).all() for task in tasks: self.assertEquals(task.name, 'Run around in circles')
def post(self):
args = self.post_parser.parse_args()
new_task = Task(name=args['name'],
due_date=datetime.strptime(args['due_date'],
'%m/%d/%Y').date(),
priority=args['priority'],
posted_date=datetime.utcnow(),
status='1',
user_id=g.user.id)
db.session.add(new_task)
db.session.commit()
result = {
"status": "Entry was successfully posted",
"task added": args['name']
}
code = 201
return result, code
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == "POST":
if form.validate_on_submit():
new_task = Task(form.name.data,
form.due_date.data, form.priority.data,
datetime.datetime.utcnow(), "1",
session["user_id"])
db.session.add(new_task)
db.session.commit()
flash("New entry was successfully added. Thanks.")
return redirect(url_for("tasks.tasks"))
return render_template("tasks.html",
form=form,
error=error,
open_tasks=open_tasks(),
closed_tasks=closed_tasks())
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
task_to_add = Task(form.name.data,
form.due_date.data, form.priority.data,
datetime.utcnow(), '1', session['user_id'])
db.session.add(task_to_add)
db.session.commit()
flash('New entry was successfully posted.')
return redirect(url_for('tasks.tasks'))
return render_template(url_for('tasks.tasks'),
form=form,
error=error,
open_tasks=open_tasks(),
closed_tasks=closed_tasks())
def new_task():
error = None
form = AddTaskForm(request.form)
if request.method == 'POST':
if form.validate_on_submit():
new_task = Task(form.name.data,
form.due_date.data, form.priority.data,
datetime.datetime.utcnow(), '1',
session['user_id'])
db.session.add(new_task)
db.session.commit()
flash('New task created!', 'success')
return redirect(url_for('tasks.tasks'))
return render_template('tasks.html',
form=form,
error=error,
open_tasks=open_tasks(),
closed_tasks=closed_tasks())
def add_task():
form = AddTaskForm(request.form)
if form.validate_on_submit():
new_task = Task(name=form.name.data,
due_date=form.due_date.data,
priority=form.priority.data,
posted_date=datetime.datetime.utcnow(),
status='1',
user_id=session['user_id'])
db.session.add(new_task)
db.session.commit()
flash("New task has been succesfully added")
else:
# we pass form errors to session dict
# to display them on a page with different route
session['name_errors'] = form.name.errors
session['due_date_errors'] = form.due_date.errors
return redirect(url_for('tasks.tasks'))
def post(self):
args = parser.parse_args()
new_task = Task(
args['name'],
datetime.datetime.strptime(args['due_date'], '%m/%d/%Y'),
args['priority'],
datetime.datetime.utcnow(),
'1',
'1',
)
db.session.add(new_task)
db.session.commit()
result = TaskDao(task_id=new_task.task_id,
name=new_task.name,
due_date=new_task.due_date,
priority=new_task.priority,
posted_date=new_task.posted_date,
status=new_task.status,
user_id=new_task.user_id)
return result, 201
def post(self):
args = parser.parse_args()
print(args['name'])
print(args['priority'])
print(args['due_date'])
new_task = Task(
args['name'],
args['due_date'],
args['priority'],
datetime.datetime.utcnow(),
1,
1)
db.session.add(new_task)
db.session.commit()
name = args['name']
data = {
'msg': f'Your task \'{name}\' has been posted as task 2.'
}
return jsonify(data)
from project import db, bcrypt
from project.models import Task, User
from datetime import date
# create a database and the db table
db.create_all()
# insert data (if not done)
db.session.add(
User(
'admin', '*****@*****.**', bcrypt.generate_password_hash('admin'), 'admin'
)
)
db.session.add(
Task("Finish this tutorial",
date(2018, 9, 22), 10, date(2018, 9, 22), 1, 1)
)
db.session.add(
Task("Finish Real Python",
date(2018, 1, 3), 10, date(2018, 1, 3), 1, 1)
)
# commit the changes
db.session.commit()
from project import db, bcrypt
from project.models import Task, User
from datetime import date
###with sqlite3.connect(DATABASE_PATH) as conn:
# c = conn.cursor()
# c.execute("""CREATE TABLE tasks(task_id INTEGER PRIMARY KEY AUTOINCREMENT,
# name TEXT NOT NULL, due_date TEXT NOT NULL, priority INTERGER NOT NULL, status INTERGER NOT NULL)""")
# c.execute("""INSERT INTO tasks (name, due_date, priority, status)
# Values("Finish this tutorial","03/25/2015",10,1)""")
# c.execute("""INSERT INTO tasks (name,due_date,priority,status)
# Values("do some thing awsome","05/24/2016",10,1)""")
db.create_all()
db.session.add(
User("admin", "*****@*****.**", bcrypt.generate_password_hash("admin"),
"admin"))
db.session.add(
Task("Finish this tutorial", date(2015, 3, 13), 1, date(2015, 2, 13), 1,
1))
db.session.add(Task("move", date(2016, 6, 14), 1, date(2016, 6, 13), 1, 1))
db.session.commit()
# db_create.py
from project import db
from project.models import Task, User
from datetime import date
# create db and table
db.create_all()
# insert data
db.session.add(User("admin", "*****@*****.**", "admin", "admin"))
db.session.add(
Task("Finish this tutorial", date(2018, 1, 26), 10, date(2018, 1, 26), 1,
1))
db.session.add(
Task("Finish this course", date(2018, 1, 31), 10, date(2018, 1, 31), 1, 1))
# commit changes
db.session.commit()
#project/db_create.py
from datetime import date
from project import db
from project.models import Task, User
#create the db and db table
db.create_all()
#insert data
# db.session.add(Task("Finish the tutorial", date(2015,12,27), 10, 1))
# db.session.add(Task("Finish Real Python", date(2015,12,28), 10, 1))
db.session.add(User("admin", "*****@*****.**", "admin"))
db.session.add(
Task("FINISH THIS ALREADY! DAMN!", date(2015, 3, 13), 10,
date(2015, 2, 13), 1, 1))
db.session.commit()
# import sqlite3
# from _config import DATABASE_PATH
# with sqlite3.connect(DATABASE_PATH) as connection:
# #get a cursor object used to execute SQL commands
# c = connection.cursor()
# # create the table
# c.execute(""" CREATE TABLE tasks(task_id INTEGER PRIMARY KEY
# AUTOINCREMENT,
# name TEXT NOT NULL, due_date TEXT NOT NULL, priority
# -*- coding: utf-8 -*-
"""
Created on Wed Apr 06 08:05:40 2016
@author: appertjt
"""
#db_create.py
from project import db
from project.models import Task, User
from datetime import date
#create the database and the db table
db.create_all()
#insert data
db.session.add(User("admin", "*****@*****.**", "admin", "admin"))
db.session.add(
Task("finish this tutorial", date(2016, 5, 16), 10, date(2016, 2, 13), 1,
1))
db.session.add(
Task("Finish Real Python", date(2016, 8, 10), 10, date(2017, 3, 15), 1, 1))
# commit the changes
db.session.commit
# db_create.py
from project import db
from project.models import Task, User
from datetime import date
db.create_all()
db.session.add(User("admin", "*****@*****.**", "admin", "admin"))
db.session.add(
Task("Finish this tutorial", date(2016, 10, 3), 10, date(2020, 10, 10), 1,
1))
db.session.add(
Task("Finish Real Python", date(2016, 10, 3), 10, date(2021, 10, 10), 1,
1))
db.session.commit()
# db_create.py
from project import db, bcrypt
from project.models import Task, User
from datetime import date
# Create db
db.create_all()
# admin user
password = bcrypt.generate_password_hash('admin')
db.session.add(User("admin", "*****@*****.**", password, "admin"))
# Some example data
list_of_tasks = [('Finish this tutorial', date(2016, 5,
17), 10, date(2016, 5,
10), 1, 1),
('Finish RP course', date(2016, 6, 30), 8, date(2016, 5,
10), 1, 1)]
# Insert Data
for t in list_of_tasks:
db.session.add(Task(*t))
db.session.commit()
def test_task_repr(self):
new_task = Task("test task", "22/22/2022", "1",
datetime.datetime.utcnow(), "1", "1")
self.assertIn("name test task", repr(new_task))
def compleTask(id):
task = Task()
task.compleTask(id)
return redirect(url_for('task'))
def delTask(id):
task = Task()
task.delTask(id)
return redirect(url_for('task'))
from datetime import date
from project import db
from project.models import Task, User
# create the database and the db table
db.create_all()
# insert data
db.session.add(User("admin", "*****@*****.**", "admin", "admin"))
db.session.add(
Task("Finish this tutorial", date(2016, 10, 13), 10, date(2016, 10, 9), 1,
1))
db.session.add(
Task("Finish Real Python", date(2016, 11, 13), 10, date(2016, 10, 9), 1,
1))
# commit the changes
db.session.commit()
#project/sqlite3.py
from datetime import date
from project import db
from project.models import Task, User
#create the database and the db table
db.create_all()
db.session.add(
Task("1.Finish this tutorial", date(2015, 3, 13), 10, date(2015, 3, 16), 1,
"admin"))
db.session.add(
Task("2.Finish all tutorial", date(2016, 3, 13), 10, date(2016, 7, 13), 1,
"admin"))
db.session.add(User("admin", "*****@*****.**", "admin", "user"))
db.session.add(User("sysadmin", "*****@*****.**", "sysadmin",
"admin"))
db.session.commit()
# db_create.py
from project import db
from project.models import Task, User
from datetime import date
# create the database and the db table
db.create_all()
# insert data
db.session.add(User("admin", "*****@*****.**", "admin", "admin"))
db.session.add(
Task("Finish this tutorial", date(2015, 3, 13), 10, date(2015, 2, 13), 1,
1))
db.session.add(
Task("Finish Real Python", date(2015, 3, 13), 10, date(2015, 2, 13), 1, 1))
# commit the changes
db.session.commit()
def test_Task_default_representation(self):
new_task = Task('running around', '05/05/2016', '1', '05/05/2016', '1', '1')
self.assertEqual(new_task.__repr__(), '<name running around>')
