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 = {