Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use productList method in fMBT

Best Python code snippet using fMBT_python

products.py

Source:products.py

1import logging2from flask import request3from flask_restplus import Resource4from src.api.productsCRUD.business import create_productlist, delete_productlist, \5    update_productlist6from src.api.productsCRUD.serializers import productlist, \7    productlist_item, page_of_productlist, page_of_product_items, productlist_input8from src.api.productsCRUD.business import create_product_item, update_item, delete_item9from src.api.restplus import api10from src.models import ProductList11from src.api.productsCRUD.parsers import pagination_arguments, search_argument12from src.api.restplus import auth_required13from flask import abort, current_app, _app_ctx_stack14log = logging.getLogger(__name__)15ns = api.namespace('productsCRUD', description='Operations related to Products')16@ns.route('/')17class ProductListCollection(Resource):18    @api.expect(pagination_arguments, search_argument, productlist)19    @api.marshal_with(page_of_productlist)20    @auth_required21    def get(self):22        """23        List all the created items list.24        """25        search_args = search_argument.parse_args(request)26        args = pagination_arguments.parse_args(request)27        page = args.get('page', 1)28        per_page = args.get('per_page', 10)29        search_term = search_args.get('q')30        with current_app.app_context():31            user_data = _app_ctx_stack.user_data32        if search_term:33            search_query = ProductList.query.filter_by(created_by=user_data[34                'user_id'], name=search_term)35            if search_query.count():36                productlists = search_query.paginate(page, per_page, error_out=False)37                return productlists, 20038            abort(404, 'productlist not found')39        else:40            productlist_query = ProductList.query.filter_by(created_by=user_data['user_id'])41            productlists = productlist_query.paginate(page, per_page, error_out=False)42            return productlists, 20043    @api.response(201, 'Productlist successfully created.')44    @api.expect(productlist_input, validate=True)45    @auth_required46    def post(self):47        """48        Create a new bucket list.49        """50        data = request.json51        return create_productlist(data), 20152@ns.route('/<int:id>')53@api.param('id', 'Productlist ID')54@api.response(404, 'Productlist Item not found.')55class ProductList(Resource):56    @api.expect(pagination_arguments, productlist)57    @api.marshal_with(page_of_product_items)58    @auth_required59    def get(self, id):60        """61        Get single bucket list.62        """63        args = pagination_arguments.parse_args(request)64        page = args.get('page', 1)65        per_page = args.get('per_page', 10)66        with current_app.app_context():67            user_data = _app_ctx_stack.user_data68            created_by = user_data['user_id']69        try:70            productlist_query = ProductList.query.filter_by(created_by=created_by, id=id)71            if not productlist_query.count():72                abort(404)73            product_items = productlist_query[0].items74            productlist_items_paginated = product_items.paginate(page, per_page, error_out=False)75            productlist_items_paginated.date_modified = productlist_query[0].date_modified76            productlist_items_paginated.created_by = productlist_query[0].created_by77            productlist_items_paginated.id = productlist_query[0].id78            productlist_items_paginated.date_created = productlist_query[0].date_created79            productlist_items_paginated.name = productlist_query[0].name80            return productlist_items_paginated81        except Exception as e:82            abort(404, str(e))83    @api.expect(productlist_input, productlist)84    @api.response(204, 'Productlist item successfully updated.')85    @auth_required86    def put(self, id):87        """88        Update this product list.89        * Specify the ID of the productlist to modify in the request URL path.90        """91        data = request.json92        return update_productlist(id, data), 20093    @api.response(204, 'ProductList item successfully deleted.')94    @auth_required95    def delete(self, id):96        """97        Delete this single bucket list.98        """99        return delete_productlist(id), 204100@ns.route('/<int:id>/item/')101@api.param('id', 'Productlist id')102@api.response(201, 'Productlist item successfully created.')103class ProductItemsCollection(Resource):104    @api.expect(productlist_item, productlist)105    @auth_required106    def post(self, id):107        """108        Create a new item in bucket list.109        """110        return create_product_item(id, request.json), 201111@ns.route('/<int:id>/item/<int:item_id>')112@api.param('item_id', 'Productlist Item ID')113@api.param('id', 'Productlist ID')114@api.response(404, 'Item not found.')115class ProductlistItem(Resource):116    @api.expect(productlist_item, productlist)117    @api.response(200, 'Item successfully updated.')118    @auth_required119    def put(self, id, item_id):120        """121        Update a product list item.122        """123        data = request.json124        return update_item(id, item_id, data), 200125    @api.response(204, 'Item successfully deleted.')126    @auth_required127    def delete(self, id, item_id):128        """129        Delete an item in a product list.130        """...

product_list.py

Source:product_list.py

1# coding: utf-82from __future__ import absolute_import3from datetime import date, datetime  # noqa: F4014from typing import List, Dict  # noqa: F4015from swagger_server.models.base_model_ import Model6from swagger_server.models.product import Product  # noqa: F401,E5017from swagger_server import util8class ProductList(Model):9    """NOTE: This class is auto generated by the swagger code generator program.10    Do not edit the class manually.11    """12    def __init__(self, total: int=None, products: List[Product]=None):  # noqa: E50113        """ProductList - a model defined in Swagger14        :param total: The total of this ProductList.  # noqa: E50115        :type total: int16        :param products: The products of this ProductList.  # noqa: E50117        :type products: List[Product]18        """19        self.swagger_types = {20            'total': int,21            'products': List[Product]22        }23        self.attribute_map = {24            'total': 'total',25            'products': 'products'26        }27        self._total = total28        self._products = products29    @classmethod30    def from_dict(cls, dikt) -> 'ProductList':31        """Returns the dict as a model32        :param dikt: A dict.33        :type: dict34        :return: The ProductList of this ProductList.  # noqa: E50135        :rtype: ProductList36        """37        return util.deserialize_model(dikt, cls)38    @property39    def total(self) -> int:40        """Gets the total of this ProductList.41        :return: The total of this ProductList.42        :rtype: int43        """44        return self._total45    @total.setter46    def total(self, total: int):47        """Sets the total of this ProductList.48        :param total: The total of this ProductList.49        :type total: int50        """51        self._total = total52    @property53    def products(self) -> List[Product]:54        """Gets the products of this ProductList.55        :return: The products of this ProductList.56        :rtype: List[Product]57        """58        return self._products59    @products.setter60    def products(self, products: List[Product]):61        """Sets the products of this ProductList.62        :param products: The products of this ProductList.63        :type products: List[Product]64        """...

main.py

Source:main.py

1import sqlite32class ProductsDB:3    def __init__(self, file):4        self.conn = sqlite3.connect(file)5        self.cursor = self.conn.cursor()6    7    def insert_product(self, name, price):8        consult = 'INSERT INTO productlist (name, price) VALUES(?, ?)'9        self.cursor.execute(consult, (name, price))10        self.conn.commit()11    12    def edit_product(self, name, price, id):13        consult = 'UPDATE productlist SET name=?, price=? WHERE id=?'14        self.cursor.execute(consult, (name, price, id))15        self.conn.commit()16    def delete_product(self, id):17        consult = 'DELETE FROM productlist WHERE id=?'18        self.cursor.execute(consult, (id,))19        self.conn.commit()20    21    def show_products(self):22        self.cursor.execute('SELECT * FROM productlist')23        for line in self.cursor.fetchall():24            print(line)25    def search_products(self, value):26        consult = 'SELECT * FROM productlist WHERE name LIKE ? '27        self.cursor.execute(consult, (f'%{value}%',))28        for line in self.cursor.fetchall():29            print(line)30    def close(self):31        self.conn.close()32        self.cursor.close()33if __name__ == '__main__':34    productlist = ProductsDB('productlist.db')35   # productlist.insert('Name', 0.00)36   # productlist.edit_product('Name', 0.00, 0)37   # productlist.delete_product(0)38   # productlist.show_products()...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.