This is a subsequent article to Serverless Framework To Test AWS Microservices

In our previous story, we have seen how to use Serverless Test Framework to test AWS microservices and stored execution reports in S3. Till now, if you want to view the execution report you must have to download locally along with assets folder (contains corresponding css and js for mochawesome reports). There is no direct way to visualise multiple execution results at one place.

When I started testing Microsoft SQL Server database in my previous role, there was not much documentation available in general. So I had to spend extra hours to understand and build an end to end test.

Purpose of this article is to share the knowledge on how to write automation tests for MSSQL Server. Instead of writing queries in sql developer or Azure data studio the entire end to end test can be automated using node.js mssql package.

I would use Programmatic Mocha Test approach, setup is available in the previous article.

git clone https://github.com/puneetpunj/programmatic-mocha-framework.git

Just for the purpose of this artcile I will spin up a new database to get connection details and show the actual test, otherwise if you already have SQL Server running, feel free to skip this section and use your own connection details. …

Mocha is a feature-rich JavaScript test framework running on Node.js and in the browser, making asynchronous testing simple and fun. Mocha tests run serially, allowing for flexible and accurate reporting, while mapping uncaught exceptions to the correct test cases. Hosted on GitHub.

Lets start with understanding how to quickly setup mocha framework and execute a sample test. Please ensure node.js is already installed.

Open your terminal and start by installing mocha and chai (assertion library) packages.

mkdir programmatic-mocha-framework && cd programmatic-mocha-framework
npm init -y
npm i mocha chai//setup first testmkdir test
touch test/sample-test.js

Open sample-test.js …

Let’s start this story with cypress.io’s own tagline

The web has evolved.
Finally, testing has too.

I truly believe cypress as a framework is one of the most wonderful thing happened in the Automation Testing space in recent years. It is one of the most growing end to end testing framework adopted by enterprises.

A quick read on how does it work — https://www.cypress.io/how-it-works

Though cypress has provided very good documentation, my idea of this article is to provide the boiler plate setup to get started with a framework rather than native cypress tests.

Covering below topics in this article:

• Video/Screenshots…

Learn to implement voice technology in your test framework

This is a subsequent article to Serverless Test Framework. Please ensure your Serverless Test Framework is up and running and Lambda function executes the automated tests.

First of all lets look at the Detailed Architecture and understand what are we going to build today.

Step1

Let’s first build Lambda function which will be required to act an interface between your Alexa skill and Test Lambda Function (created in previous article)

Login to AWS Console using your credentials. On the top right corner change your region to North Virginia (us-east-1). …

Functional testing of AWS services is slightly challenging compared to normal REST API, web applications, or databases. Let’s see what the major problems are when dealing with AWS services.

Let’s consider a solution running an application using Lambda functions and orchestrated using the step function, storing metadata in DynamoDB and data files in S3.

When building a test-automation framework, if you use Jenkins, CircleCI, GoCD, or any other CI tool to execute tests, then passing and storing user credentials like aws_access_key_id and aws_secret_access_key on the server isn’t a secure way of accessing AWS services — and it has potential security concerns. …

Ever gotten stuck comparing and validating content of big csv files with millions of records?

It is always been a challenge in big data projects I have been part of.

In this article, we will look at the simple nodejs code to compare such big files in seconds.

Start by creating new directory & cd into the new dir

mkdir csv-file-comparisoncd csv-file-comparison

Assuming you already have a nodejs installed on the system. Execute below command to initialise npm project

npm init -y

Install fs package which is required to read files from local drive

npm install fs

Create new file and name it as csvcomparison.js

touch csvcomparison.js

Open csvcomaprison.js …