import json
from tools import req
from tools import dbconnect
request = req.REQ()
mysql_conn = dbconnect.DBConnect()
def test_post_product():
#Create a global variable for product_id
global product_id
global data
data = {
"name":
"NewProduct2",
"type":
"simple",
"regular_price":
"21.99",
"description":
"Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.",
"short_description":
"Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.",
}
result = request.post('products', data)
return_code = result[0]
resp_body = result[1]
from tools import req
from tools import dbconnect
# creating our object to be used to make API call and db connections
rq = req.REQ()
qry = dbconnect.DBConnect()
def test_create_a_product():
"""
Function to make 'products' API call to create a product.
Some value for payload are hardcoded, the call made and then the data in the response verified.
"""
print "Running 'create product' endpoint test ...."
# set global variables to be used in different functions
global product_id
global title
global price
# create payload for the call
print 'Building the payload for the call'
title = 'TEST1 TITLE'
price = '9.99'
input_data = {
'product': {
'title': title,
'type': 'simple',
'regular_price': price
class Helper():
"""
This is a class for function to be shared between test cases.
Common tasks or tools go here.
"""
qry = dbconnect.DBConnect()
def __init__(self):
pass
def generate_random_info(self):
"""
This generates random strings. The strings generated are for email, username, first name and last name.
:return: info - dictionary containing the randomly generted info
"""
info = {}
print("Generating random stings for email and user_namee")
stamp = datetime.now().strftime("%Y%m%d%H%M%S")
info['email'] = "api_user_" + stamp + "@gmail.com"
info['user_name'] = "backend." + stamp
print("Generating random strings for first_name and last_nam")
all_letters = string.lowercase
info['first_name'] = "".join(random.sample(all_letters, 8))
info['last_name'] = "".join(random.sample(all_letters, 8))
print("The generated email: {}".format(info['email']))
print("The generated user name: {}".format(info['user_name']))
print("The generated first name: {}".format(info['first_name']))
print("The generated last name: {}".format(info['last_name']))
return info
def get_customer_info_from_db_provided_customer_id(self, cust_id):
"""
Method to get customer info.
:param cust_id:
:return:
"""
customer_db_info = {}
# get the customer id and some info from the 'ak_users' table
sql = "SELECT user_login, user_nicename, user_email, display_name FROM ak_users Where ID = {}".format(
cust_id)
cust = self.qry.select('akstore', sql)
print cust
customer_db_info['user_login'] = cust[0][0]
customer_db_info['user_nicename'] = cust[0][1]
customer_db_info['user_email'] = cust[0][2]
customer_db_info['username'] = cust[0][3]
# get the customers metadata from the 'aK_usermeta' table
sql = "SELECT meta_key, meta_value FROM akstore.ak_usermeta WHERE user_id = {};".format(
cust_id)
cust_meta = self.qry.select('akstore', sql)
# lets add all the user meta data tot he customer_db_info dictionary
for row in cust_meta:
customer_db_info[row[0]] = row[1]
return customer_db_info