Posts

Showing posts from March, 2022

How To Create A Pipeline Using Jenkins and GitLab

Image
[ UPDATE : There is an error on loading of images in every post. I am working to resolve this as soon as possible. Screenshots were mere snap of windows so you can still follow the steps written in text and do the work!]  Hello, in this post I will show how to create a CI pipeline using Jenkins, SonarQube and GitLab. Before proceeding, make sure you have basic knowledge of commands in Git and Git Bash. If you have any doubt or query please comment it below so that others having same question can benefit from it.  Some common URL for following applications: - Jenkins : localhost:8080 - SonarQube ( version sonarqube-9.2.4.50792 ): localhost:9000  How to open SonarQube on your local machine: 1. Go into the folder where your SonarQube installation is located. From here go to: \bin\windows-x86-64. 2. In address bar above in the file explorer, clear out the rest of the text and type cmd so that it opens a Command Prompt terminal in that directory. 3. In the Command Prompt, ty...

How To Get Data From MySQL Table to EJS page using NodeJS

Image
[ UPDATE : There is an error on loading of images in every post. I am working to resolve this as soon as possible. Screenshots were mere snap of windows so you can still follow the steps written in text and do the work!]  Welcome to another tech post. In this post, I will be showing you how to get data from the MySQL table which is made using SequelizeJS into our view which is an EJS file in NodeJS. If you want to learn how to create a table using SequelizeJS, then refer to my other post:  How To Create MySQL Table with SequelizeJS (sumitkp.in) Before starting to read further, make sure you have prior knowledge of NPM packages, NodeJS, SequelizeJS, EJS, JSON and ExpressJs. Something about the EJS: EJS stands for Embedded JavaScript. EJS is a simple templating language that lets us generate HTML markup with plain JavaScript. It offers fast development time. It has a simple syntax and speedy execution. It is easy to debug EJS errors. EJS has a large community of active users and...

How To Create MySQL Table with SequelizeJS

Image
Hello, in this post I will be showing how you can create an SQL table using JavaScript without the knowledge of MySQL. Sequelize is a promise-based  Node.js   ORM tool  for  Postgres ,  MySQL ,  MariaDB ,  SQLite ,  Microsoft SQL Server ,  Amazon Redshift  and  Snowflake’s Data Cloud . It features solid transaction support, relations, eager and lazy loading, read replication and more.