def setUp(self):
self.browser = webdriver.Firefox()
category = Category(name="salary", type="income")
category.save()
account = Account(name="savings")
account.save()
income = Income(category=category, account=account, notes="October 2015 salary", amount=100000, date=datetime.datetime.now())
income.save()
def setUp(self):
self.browser = webdriver.Firefox()
self.browser.implicitly_wait(3)
category = Category(name="others", type="expense")
category.save()
account = Account(name="savings")
account.save()
expense = Expense(category=category, account=account, notes="gift", amount=1000, date=datetime.datetime.now())
expense.save()
def create():
form = CreateForm()
if form.validate_on_submit():
try:
category = Category(name=form.name.data, filter_=form.filter_.data)
database.session.add(category)
database.session.commit()
flash("The category has been created.")
except IntegrityError:
database.session.rollback()
flash(
"The category has not been created due to concurrent modification.",
"error",
)
return redirect(url_for("category.list"))
elif request.method == "GET":
if current_user.filter_ is not None:
form.filter_.data = current_user.filter_
return render_template(
"category/create.html.jinja",
title="Create Category",
form=form,
cancel_url=url_for("category.list"),
)
def insert_category():
request_payload = json.loads(request.form['data'])
category = Category(category_name=request_payload['category_name'])
db.session.add(category)
db.session.commit()
response = jsonify('OK')
response.headers.add('Access-Control-Allow-Origin', '*')
return response
def save_category(event_request, category_id):
category = Category()
category.id = event_request.username + str(category_id)
category.category_id = category_id
category.username = User.objects.get(pk=event_request.username)
category.save()
def add_post():
"""Add a category to the database with POST.
Login required.
"""
category = Category(name=request.form.get('name'),
picture=request.form.get('picture'),
description=request.form.get('description'))
c.add(category)
c.commit()
flash("The category \"%s\" was successfully added." % category.name)
return redirect(url_for('categories.get_byid',
cat_id=category.id))
def main(location):
clear_all()
html_parser = HTMLParser()
# parse a file
if not location:
path = os.path.dirname(os.path.realpath(__file__))
wp = wxr_parser.parse(os.path.join(path, 'wp.xml'))
else:
wp = wxr_parser.parse(location)
tags = wp['tags']
for _, kv in tags.iteritems():
Tag(name=kv['title'], slug=kv['slug']).save()
cates = wp['categories']
for _, kv in cates.iteritems():
Category(name=kv['title']).save()
posts = wp['posts']
for post in posts:
markdown, content = convert_content(post['content'])
creator = post['creator']
user = User.objects.filter(name=creator).first()
if not user:
role = Role.objects.filter(name="READER").first()
if not role:
role = Role.objects.create(name="READER",
permission=Permission.READ)
password = ''.join([
random.choice(string.ascii_uppercase + string.ascii_lowercase +
string.digits) for i in xrange(16)
])
user = User.objects.create(name=creator,
email='*****@*****.**',
role=[role],
password=password)
Post(title=html_parser.unescape(post['title']),
slug=post['slug'],
content=content,
markdown=markdown,
page=False,
author=user,
status=convert_status(post['status'].upper()),
published_at=post['pub_date'],
created_at=post['pub_date']).save()
def register_post():
name = request.form.get('name')
new_category = Category(category_name=name, user_id=current_user.id)
# バリデーション
if not name:
flash('カテゴリ名を入力してください')
return redirect(url_for('categories.register'))
for category in current_user.categories:
if category.category_name == name:
flash('そのカテゴリは既に追加されています')
return redirect(url_for('categories.register'))
# insert
try:
db.session.add(new_category)
db.session.commit()
except Exception:
db.session.fallback()
finally:
db.session.close()
return redirect(url_for('categories.index'))
def run():
"""
Add test data to db.
"""
app = prepare_app()
app.app_context().push()
for category_dict in categories:
category = Category(**category_dict)
db.session.add(category)
db.session.commit()
for meal_dict in meals:
meal = Meal(**meal_dict)
db.session.add(meal)
db.session.commit()
user = User(name='admin', email='*****@*****.**', password='******')
db.session.add(user)
db.session.commit()
def test_new_post_with_category(self):
c = Category(name='Python')
c.put()
p = Post(title="Primo Post", category=c)
p.put()
return self.assertEqual(p.category.name, 'Python')
def save_products(self):
"""Save products and categories in Database."""
api_class = Api()
products_and_categories_from_api = api_class.download_products()
if products_and_categories_from_api is not None:
print(" ✅ Les produits ont été téléchargé avec succès depuis l'API")
else:
print(" ❌ -> Les produits n'ont pas pu être téléchargés depuis l'API")
for product in products_and_categories_from_api:
name = product.get("product_name_fr")[:150].strip().lower().capitalize()
brands = product.get("brands")[:150].strip().lower().capitalize()
grade = product.get("nutriscore_grade")[0].upper()
barcode = product.get("code")[:13].strip()
url = product.get("url")
picture = product.get("image_url")
small_picture = product.get("image_small_url")
categories = [
name.strip().lower().capitalize()
for name in product["categories"].split(",")
]
selected_nutriments = [
"energy_100g",
"sugars_100g",
"fat_100g",
"salt_100g",
]
nutriments_dict = {}
for nutriment in selected_nutriments:
nutriment_value = product.get("nutriments").get(nutriment)
if isinstance(nutriment_value, float) is True:
value = nutriment_value
else:
value = 0
nutriments_dict[nutriment] = value
product_instance = Product(
name=name,
brand=brands,
barcode=barcode,
score=grade,
url=url,
image_url=picture,
small_image_url=small_picture,
kcal_100g=nutriments_dict.get("energy_100g"),
sugar_100g=nutriments_dict.get("sugars_100g"),
salt_100g=nutriments_dict.get("salt_100g"),
fat_100g=nutriments_dict.get("fat_100g"),
)
try:
product_instance.save()
saved_categories = []
for category in categories:
category_instance = Category(name=category)
if category not in saved_categories:
saved_categories.append(category)
try:
category_instance.save()
except IntegrityError:
category_instance = Category.objects.get(name=category)
# Link products to categories
product_instance.categories.add(category_instance)
product_instance.save()
except IntegrityError:
continue
print("😎 -> LA BASE DE DONNÉES EST COMPLÉTÉE ! <- 😎")
import os
import unittest
import json
from flask_sqlalchemy import SQLAlchemy
from application import create_app, db
from application.models import Locality, Category, Housing
app = create_app()
with app.app_context():
# create all tables
db.drop_all()
db.create_all()
locality = Locality("London")
category = Category("Guest house")
db.session.add(locality)
db.session.add(category)
db.session.commit()
housing = Housing("name searchval", "description", 1, 1)
housing_for_delete = Housing("name for delete", "description", 1, 1)
db.session.add(housing)
db.session.add(housing_for_delete)
db.session.commit()
housing_id = housing.id
housing_for_delete_id = housing_for_delete.id
auth_header_viewer = {
'Authorization':
"Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6Ik5EaERSVEV5TXprMlJFWkZRakUxTURZNVJVVXpRVUV3TlVNeE5UWXpOelk0TlRRNE56bEVOdyJ9.eyJpc3MiOiJodHRwczovL3NreWRldi5hdXRoMC5jb20vIiwic3ViIjoiYXV0aDB8NWU2YzViN2EwODQ1NzEwYzkyMjA1OTg3IiwiYXVkIjoiZnNuZC1jYXBzdG9uZSIsImlhdCI6MTU4NDE2Mzc2OSwiZXhwIjoxNTg0MjUwMTY5LCJhenAiOiJKRjFpUFdFbjNXRWdXT201SVhEUmJ4TUtKZUJPdzM4NCIsInNjb3BlIjoiIiwicGVybWlzc2lvbnMiOlsicmVhZDpob3VzaW5nIl19.JlaNCWH3iWIBe2dmgVmuQqerOy8OogvJzSs4Fm3AfhsuOQ-KaN8NJMIYTCxjyyDxZ-11kuS5mq8jmmei8olaLY-6FAiBfGUL7fsBpTPF6mguAnryUYelJD5fnMtEU-NZYTwMGrt14k9MgiHD_TSAZH7LuBzOO6b8n0fhICVfYpSQp7WmtO-QcPVb52L9UhAkmCLoH3stDHBhDwpcENKRj-HWn00KP6348mQUTgXpfyFgGmboxsePdCdGKckXqWEJuWrw9n7PnelD4CQzq0VZsx_E5pffTU-H_P3CJcAp9fAsdoBh1ZGoS4R80CO0bXd8b5IoytIbFEQbZ48B4fXQRg"
}
auth_header_manager = {
