def new_habit(): db.session.modified = True form = New_habit() category_list = Category.list_of_category() form.submit() if form.validate_on_submit(): new_record = Habit(name=form.name.data, category_id=form.category_type.data, date_start=form.start_date.data, priority=form.priority.data, date_end=form.end_date.data) Habit.save_to_db(new_record) new_habit_id = Habit.query.filter_by(name=form.name.data).first().id for single_date in daterange(form.start_date.data, form.end_date.data): dates = Date(date=single_date, habit_id=new_habit_id, category_id=form.category_type.data) Date.save_to_db(dates) flash('Your post has been created!', 'success') return redirect(url_for('home')) return render_template('habit.html', title='New Category', form=form, legend='New Category', category_list=category_list)
def category(): form = New_category() form_delete = Delete_habit() date = Date.find_date_by_habit_id_and_date(_id=12, date='2020-05-11') for i in range(Category.query.count()): print(i) form.submit() if form.validate_on_submit(): print('under POST') new_category = Category(category=form.category.data) Category.save_to_db(new_category) flash('Your post has been created!', 'success') return redirect(url_for('home')) if form_delete.validate_on_submit(): print('under DELETE') print(form_delete.category_type.data, 'category type ') category_to_delete = Category.find_by_id( form_delete.category_type.data) print(category_to_delete, 'asdfasdf') db.session.delete(category_to_delete) db.session.commit() flash('Your DELETE has been created!', 'success') return redirect(url_for('home')) return render_template('category.html', title='New Category', form=form, form_delete=form_delete, legend='New Category')
def update_task(date_id): date = list(filter(lambda t: t['id'] == date_id, schedule)) if len(date) == 0: abort(404) if not request.json: abort(400) if 'date' in request.json and type(request.json['date']) != str: abort(400) if 'description' in request.json and type( request.json['description']) is not str: abort(400) if 'is_done' in request.json and type(request.json['is_done']) is not bool: abort(400) date = Date(request.json.get('date', date[0]['date']), request.json.get('description', date[0]['description']), request.json.get('is_done', date[0]['is_done']), date[0]['id']).as_json() for i, item in enumerate(schedule): if item['id'] == date['id']: schedule.remove(item) schedule.insert(i, date) return jsonify({'date': date})
def get_dates(): # get all the areas dates = Date.get_all() results = [] for date in dates: results.append(date.serialise()) return make_response(jsonify({ 'list' : results })), 200
def test_edit_date(self): utc = arrow.utcnow() date = Date("2019-03-26", "water roses", True).as_json() res = requests.put('http://localhost:5000/schedule/0', json=date) if res.status_code == 200: print("Test 'edit_date()' PASS at " + str(utc)) else: print("Test 'edit_date()' FAIL at " + str(utc))
def create_date(): if not request.json \ or 'date' not in request.json \ or 'description' not in request.json: abort(400) date = Date(request.json['date'], request.json['description']).as_json() schedule.append(date) return jsonify({'date': date}), 201
def test_add_schedule(self): utc = arrow.utcnow() date = Date("2019-03-26", "water some flowers").as_json() res = requests.post('http://localhost:5000/schedule', json=date) if res.status_code == 201: print("Test 'add_games()' PASS at " + str(utc)) else: print("Test 'add_games()' FAIL at " + str(utc))
def report(): form = DateHabitReport() form_delete = Delete_habit() dates = Date.find_habits_by_date('2020-05-11') form.submit() if form.validate_on_submit(): number_of_dates = 1 choosen_date = str(form.selected_date.data) flash('Your post has been created!', 'success') return redirect( url_for('report_with_date', number_of_dates=number_of_dates, choosen_date=choosen_date)) return render_template('report.html', form=form)
def report_with_date(number_of_dates, choosen_date): form = DateHabitReport() form_done = Building_habit() all_date_objects = [ Date.find_habits_by_date(single_list) for single_list in choosen_date.split(',') ] print(all_date_objects) form_done.submit_done_or_not() if form_done.validate_on_submit(): date = Date.query.filter_by(id=form_done.date_id.data).first() date.done = True db.session.commit() flash('Your DELETE has been created!', 'success') return render_template('report.html', form=form, number_of_dates=number_of_dates, choosen_date=choosen_date, all_date_objects=all_date_objects, form_done=form_done) form.submit() if form.validate_on_submit(): number_of_dates = 1 + int(number_of_dates) choosen_dates = choosen_date + ',' + str(form.selected_date.data) print(choosen_dates, 'ciekawe co to za string') flash('Your post has been created!', 'success') return redirect( url_for('report_with_date', number_of_dates=number_of_dates, choosen_date=choosen_dates)) return render_template('report.html', form=form, number_of_dates=number_of_dates, choosen_date=choosen_date, all_date_objects=all_date_objects, form_done=form_done)
from flask import request, make_response, jsonify, abort from app import app from app.models import Date import json schedule = [ Date('2019-03-26', 'water roses').as_json(), Date('2019-03-27', 'water tulips').as_json(), Date('2019-03-28', 'water daisies').as_json() ] @app.route('/') def index(): return jsonify({'page': 'index'}) @app.route('/schedule', methods=['GET']) def get_schedule(): return jsonify({'schedule': schedule}) @app.route('/schedule/<int:date_id>', methods=['GET']) def get_date(date_id): date = list(filter(lambda t: t['id'] == date_id, schedule)) if len(date) == 0: abort(404) return jsonify({'date': date[0]}) @app.errorhandler(404)
dateList = stringCutting.extractDate() for date in dateList: somedayStock = datetime.strptime(date, '%Y-%m-%d').date() output_filename = somedayStock.strftime('listaAkcji-%Y-%m-%d.csv') db.create_all() #Checking if given day is already in our DB exists = db.session.query( Date.day).filter_by(day=somedayStock).scalar() is not None if exists: print('Day ' + date + ' already exists in database ') continue print('Adding day: ' + date) sd = Date(day=somedayStock) db.session.add(sd) db.session.commit() df = pandas.read_csv(basedir + sharesDir + output_filename, na_values='—', dtype={ 'Kurs(PLN)': float, 'Zmiana(%)': float, 'Otwarcie': float, 'Min': float, 'Max': float, 'Obrot(szt)': float, 'Obrot(PLN)': float }) df = df.fillna(0) # all NA/NAN records are filled with '0'