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'