International Research Journal of Engineering and Technology (IRJET)
e-ISSN: 2395-0056
Volume: 09 Issue: 07 | July 2022
p-ISSN: 2395-0072
www.irjet.net
Development of email notification system based on user criteria Sai Charan Vikranth Paluri1, Sowmya Nag K2 1Student,
RV College of Engineering, Karnataka India Professor, RV College of Engineering, Karnataka India ---------------------------------------------------------------------***--------------------------------------------------------------------triggered, these Logic App connectors will carry out the Abstract - One of the most important feature of any 2Assistant
series of operations specified in the workflow. A workflow in an Azure Logic App is a series of steps-define processes or activities. When input is delivered through the managed connectors, the actions will carry out the business processes. Each workflow will begin when the trigger is fired.
customer centric application is notification. Email notification lets users to get notified about any crucial updates via email without having the need of user being logged into the application. Criteria based notification enables users to set certain criteria upon which the notification can be sent via email. Through the analysis, design and implementation of the email notification system for small size user groups for getting notified about the data source change that updates the dashboards, this paper studies how to collect the criteria and notify data without affecting the business system, and proposes a scheme of using a data pipeline to check for the change in data to notify the users. It also compares two methods of implementing the email notification service. The first method utilizes Java based web framework known as Spring boot which is used in building REST APIs and Sendgrid which is a cloud-based SMTP provider. The second method utilizes Azure logic app which is an Azure service to create automated workflows. The end users receive email notification upon a change in the data source indicating the source of data.
Spring Boot is an open source Java-based framework used to create a micro service. It is used to build stand-alone and production ready spring applications. Important layers of a spring boot application are:
Key Words: Azure, Spring boot, SQL; 1. INTRODUCTION An email notification is a message that is sent to the subscribers to let them know about updates or changes to a website, data or service, such as new features, update to the dashboards, products, or planned website maintenance. It's best to prepare the users of the application in case they need to change their routine in order to accommodate changes to a website or service operation. The potential negative impact of changes will be reduced by sharing news about updates.
Impact Factor value: 7.529
The data access object interface contains methods that interact with the database directly. This method further calls the method from the service layer where the core business logic lies.
The service layer contains the core business logic to handle the implementation service. This layer utilizes third party services and functions to implement the service for business use.
Jacoco is an open source tool which is used to perform code coverage. Code coverage gives the percentage of code covered by running all the test cases and going through the entire code. It also provides a visual representation of the code which is not covered.
3. METHODOLOGY The methodology to build the email notification shown in the Fig. 1 system has some assumptions. The first one being to notify users only about the data source change. The important steps include building data pipeline, Azure function and finally the email service. Microsoft SQL server is used as the database and it’s compatible with Azure
Azure Logic Apps is a cloud service. When using Logic Apps, a variety of APIs that are accessible as Connectors are easily consumed by the workflow. When the trigger is
|
The controller layer which handles all the API requests incoming. Upon hitting the end point, the controller class contains a method of data access object interface.
Unit testing of the code is performed using Junit, which is a unit testing framework for Java. It provides an annotation with test so that a method can be written to perform the test if the method is serving the purpose. The service layer method is tested by comparing the response code after calling the service layer method with sample data.
Azure functions are a serverless idea in cloud native architecture that enables code deployment and execution without the requirement for server infrastructure, a web server, or any configuration. Functions in Azure can be scaled. When there is more demand for execution, the service is automatically given more resources, and when there is less demand, all excess resources and application instances are automatically terminated.
© 2022, IRJET
|
ISO 9001:2008 Certified Journal
|
Page 2393