Abhishek Dubey dubeyji10

API Calls test cases and report

After using response from get users api (https://www.zohoapis.in/crm/v2.1/users)

Following test cases for insertion of record with owner assignment were performed

REQUEST URL

REQUEST TYPE

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

	import streamlit as st
	import pandas as pd

	st.header('Flexible Data Filtering UI')

	data = [
	{
	'name':'name1',
	'nickname':'nickname1',
	'date':2010,

	------------------------------------------------------------------------------------------
	#CLI shortcut keystrokes(linux&MAC)
	Ctrl+L: Clear the screen. This is similar to running the “clear” command.
	Ctrl+C: Interrupt (kill) the current foreground process running in in the terminal. This sends the SIGINT signal to the process
	Ctrl+Z: Suspend the current foreground process running in bash. This sends the SIGTSTP signal to the process. To return the process to the foreground later, use the fg process_name command.
	Ctrl+D: Close the bash shell.This is similar to running the exit command
	Ctrl+L: Clear the screen. This is similar to running the “clear” command.

	Ctrl+S: Stop all output to the screen. This is particularly useful when running commands with a lot of long, verbose output, but you don’t want to stop the command itself with Ctrl+C.
	Ctrl+Q: Resume output to the screen after stopping it with Ctrl+S.

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8" />
	<title>Add React in One Minute</title>
	</head>
	<body>

	<h2>Add React in One Minute</h2>
	<p>This page demonstrates using React with no build tooling.</p>

	import requests

	# https://www.ontestautomation.com/writing-tests-for-restful-apis-in-python-using-requests-part-1-basic-tests/
	print('trying to login a user with wrong credentials')

	userDict = {
	'username':'dubeyji213',
	'password':'wrongpassword',
	}

	import requests

	# https://www.ontestautomation.com/writing-tests-for-restful-apis-in-python-using-requests-part-1-basic-tests/
	print('trying to login a user with no credentials')

	userDict = {
	'username':'',
	'password':'',
	}

	import requests

	# https://www.ontestautomation.com/writing-tests-for-restful-apis-in-python-using-requests-part-1-basic-tests/
	print('trying to login a user with given credentials')

	# test with dubeyji218 , password218 -- they are stored after hashing
	userDict = {
	'username':'dubeyji218',
	'password':'password218',
	}

	import requests


	# https://www.ontestautomation.com/writing-tests-for-restful-apis-in-python-using-requests-part-1-basic-tests/
	print('trying to create a user with invalid password -- length < 5')

	userDict = {
	'username':'dubeyji1',
	'password':'five',
	'role':'admin'

	import requests
	import json

	# https://www.ontestautomation.com/writing-tests-for-restful-apis-in-python-using-requests-part-1-basic-tests/
	print('trying to create a user --')

	#userDict = {
	# 'username':'dubeyji213',
	# 'password':'password213',
	# 'role':'admin'