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>')