Verifies the response body values match the expected value. The function first loads the response JSON. It then iterates through the response val

Initializing the connection

Initialize the database connection

Initializing parameters for request

Initializing parameters for request

Initializing parameters for request

Initializes a database connection tunnel via SSH. Creates an SSH tunnel to a remote server, binds to the remote PostgresSQL port,

Initializing the connection Args: dbname: name Postgres database; host: URL for connecting to the Postgres

Adds random products to a user's favorites list. Registers a new user, gets all products via API, selects random products, adds them to

Asserts that the id review in the response body Args: key: specific key in the response body response: The response object from t

Asserts that the product rating in the response body matches the expected product rating. Args: response: The response object from the AP

Asserts that the message in the response body matches the expected message. Args: response: The response object from the API call.

Verify if the reviews are sorted by createdAt in ascending order. Args: response: The response object from the API call.

Verify if the reviews are sorted by createdAt in descending order. Args: response: The response object from the API call.

Verify size of reviews per page. Args: response: The response object from the API call. reviews_size_per_page: The expected siz

Asserts that the user's name in the response body matches the expected user's name. Args: response: The response object from the API call

Close the database connection

Close the cursor, database connection, and SSH tunnel

Creating and authorizing a user via API

Creating and authorizing a user Args: postgres: connection to Postgres DataBase

Creating random user(s) Args: quantity: number of random users

Create random user(s) Args: quantity: number of random users

Creating a user (not authorized) Args: postgres: connection to Postgres DataBase

Fixture to create a user, add a product to their cart. Creates a user, gets their ID and token, adds a product to their shopping cart,

Deletes a user from the database based on user ID Args: user_id: user ID

Delete a user from the database based on user ID Args: user_id: user ID

Extracts item ID and product quantity from each item in the given JSON response. Args: response: The JSON response containing item detail

Generate a numeric password. Parameters: - length: int, the length of the password to generate. Returns: - A string representing the

Retrieve data from a specified table by filtering on a specified field

Gets item ids from a JSON response. Args: num_items_to_delete: the quantity of items for delete response: The JSON response to extra

Get sorted products by size and paginate Args: field: field for sorting; ascend: ascending sort order, True - ascend

Retrieve a specified number of random active products

Getting a random user Args: quantity: number of random users

Get random users Args: quantity: number of random users

Getting info about user's avatar via API Args: expected_status_code: Expected HTTP code from Response token: JWT

Load content from a file located in the specified directory. Args: directory (str): The directory where the file is located.

Posts a user's avatar image to the API Args: token: JWT token for authorization of the request image_path: Path to the

Connect to Postgres DataBase through ssh

Connect to Postgres DataBase

Search for a user by email in the database and return the count of users with that email. Args: email: user's email Retu

Generate data for registration and user registration