DEV Community: BHAVIN VIRANI

Sequelize Migration

BHAVIN VIRANI — Sat, 27 May 2023 09:35:13 +0000

While working with SQL databases and especially when the application is in the production stage. migration helps to change the current state of the database to another state, and vice versa like Github version control.

Let's start with all the useful commands

There are some prerequisites to use migration in the project.

You must have initiated the node project with the npm init command in your project directory.
Install Sequelze npm package

npm i sequelize

In the latest version of sequelize we don't need sequelize-cli package. we can run migration commands by only installing sequelize package.

That is it, you are good to go.

First command after Installing the npm package

npx sequelize init

This will initiate migration setup and create 4 directories in your project structure
1 config
2 migrations
3 models
4 seeders
However we can create this setup for individual directories as well.

npx sequelize init:config        // Create config folder and config.json
npx sequelize init:migrations    // Create Migration folder 
npx sequelize init:seeders       // Create seeders folder             
npx sequelize init:models        // Create a model folder and index.js to handle all the models

Custom configuration

We can change the path of all the folders according to the needs of our project structure.
For that we first need to create ".sequelizerc" file in the root directory of the project and set up our configuration of Sequelize in the newly created file as below given example.

Create migration files and run migrations

After setting up Sequelize in the project we create migration for our database models with given commands.

// This will create the new migration file
npx sequelize migration:generate --name=creat-user        

// Apply all the pending database migrations
npx sequelize db:migrate

// Apply migration of individual file
npx sequelize db:migrate --to 20230527090813-create-user.js

Undo migrations

// undo migration of specific migration file
npx sequelize db:migrate:undo --name <file_name>

Create seeder files and run seeders

// Show the status of current seeder files
npx sequelize db:migrate:status

create a seeder file

// create seeder file
sequelize seed:generate --name=users

Run seeder file

// Run all the seeder files make sure you run only once
npx sequelize db:seed:all

// Run only spesefic seeder file
sequelize db:seed --seed 20230527092604-users.js

For more content check out my `Github 👁`

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

View on GitHub

Begin your opensource journey

BHAVIN VIRANI — Wed, 29 Jun 2022 08:40:34 +0000

This blog post is all about contributing to open source projects to get-up, by making opensource contribution anyone can enhance their developer profile and can make connections with new people around the world who have a similar interest.

So, let's start opensource

There are certain prerequisites to make a contribution to open source projects on github.

(1) You must have git installed in your system. if you don't have git preinstalled, then check out this link,

git installation

(2) You must have a github account to find projects and contribute on github project

That is it, your good to go.

Step - 1

Fork the repository

find any github project/repository in which you want to contribute. Fork any gituhb repository by clicking on Fork opetion at top-right corner of webpage. This'll automatically create a copy of that project in your github account.

Step - 2

Clone the repository to your machine.

Open cloned repository in your github accout which is shown in your repositories tab.
Now, click on code button(Green in color) and copty the url of that repository

After coping url of repository, open any directory in terminal folder where you want to clone(make copy localy) this project and and run command.

// Git Command to clone repo
git clone <repo_url>

// For instance
git clone https://github.com/bhavinvirani/bulletproof-react.git

Step - 3

Make your new branch

Now, open cloned repository in terminal or any code editor and make own branch. and make new git branch.

git checkout -b <new_branch_name>

// Example 
git branch -b improve_view

Branching is used in version control to maintain stability while isolated changes are made to code and prevent from any code conflicts with production branch (Main branch).
The name of the branch and the purpose should be reasonable and detailed. To easy to understand.
here, -b option automatically moves you to newly created Barch '

Step - 4

Do changes and commit those changes

if you don't to how to commit, then check out my this blog
Getting Started with 'Git'

Step - 5

Push branch on github

Now, Push your changes of new branch on github. While being on your newly created branch from terminal

git push origin -u <your_branch_name>

Example 
git push origin -u improve_view

This will create new branch on your forked github repository as well.

Step - 5

Make pull request

After successfully pushing your branch on your github repository you'll find out Compare & pull request option on top of your repository's code section

Then you'll be redirected to pull request page and provide required information to the maintainer of that project and give the appropriate pull request title.
finally submit your pull request by clicking on create pull request button.

As soon as project owner/maintainer merge your changes into the master branch of that project. You will be notify regarding the changes have been merged

For more knowledge checkout my `Github 👁`

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

View on GitHub

Getting Started with 'Git'

BHAVIN VIRANI — Sun, 27 Jun 2021 11:49:29 +0000

In this Blog i'll cover some basic commands of git, using that command you can easily work with git and Github as beginner.

Before starting this this blog I want to mention that Git and Github are not same. many people are understandably confused😕 between this two words at their beginning.

GitHub is a website for hosting projects that use git for version control.

What is `git` ?

Git is a version control system (VCS) that makes easier to track changes to files(code). For example, when you edit a file, git can help you to determine exactly what changed in your file, who changed that file, and why change that.
Git is a command line tool. it is very useful when we are working on team project or multiple people working on same project

What is `github` ?

GitHub is a Git repository hosting service, but it adds many of its own features. GitHub provides a Web-based graphical interface. It also provides access control and several collaboration features
Git also helps us to store our code safe and secure🔐 and many people use git and github daily to track their daily work. It makes them different from others.

Installation

To use git we'll need to download and install git on our system by using git. There are both options are available in market. command-line interface(CLI) and graphical user interface(GUI) as Github desktop but I recommend CLI for beginners.
After installation to check if git was installed properly or not execute the command:

git --version

First step after Installing Git

The first thing you should do when you install Git is to set your user-name and email address. This is important because every Git commit uses this information
you can set your user-name and email using this commands and also change them at any time

git config --global user.name "<User-Name>"
git config --global user.email <Email>

Create local git repository

We'll require git repository to use functionalities of git by using given command.

git init

This'll create hidden .git folder in current directory. this is the "repository"(or repo) where git stores all of its internal tracking data. Any changes you make to any files within the original folder will now be possible to track.
The original directory is now referred as working directory.

Staging

The staging area (aka index) is a container where git collects all changes which will be part of the next commit.

use below showen comannd to add individual files into staging area git add <File1 path> <File2 path>...

git add README.md app/*.txt

we also stage all changes together

git add -A
OR
git add .

status

git staus

Above command is very useful. It gives overall status of working git directory
The git status command displays the state of the working directory and the staging area. It lets you see which changes have been staged, which haven't, and which files aren't being tracked by Git.

Commit

The "commit" command is used to save your changes to the local repository. we also need commit message it is important to help other people understand what was changed and why you changed it.

git commit -m " <Commit message> "

push

The git push command is used to upload local repository content to a remote repository.

But there is one problem. we can't push directly our local repository to remote repo. in Order to do that first we need create repository on githuib and configure that remote repository with local repository. let's see how
git remote add <remote_name> <remote_repo_url>

git remote add origin https://github.com/bhavinvirani/my_repo.git

after creatig a repository on the GitHub, You will find the link on that repository itself

Now, we can push our data on remote repository using this command

git push <remote_name> <remote_branch_name>

git push -u origin master

If you are pushinga local branch for the first time on a remote, the "-u" option is helpful. It makes sure that a tracking connection between the local and your remote branch.

git push

After having set tracking connection, you can perform future pushes without providing additional options - since the tracking connection provides default values for the push command.

Here i Show whole flow of git commands

git init
// make same changes in working directory
git add -A
git commit -m "made some changes in working directory"
git remote add origin https://github.com/bhavinvirani/my_repo.git
git push origin master

Conclusion

In this blog we learned basic command of git and how to push our local repository to remote repository, It is good to use git and github daily to track our code or data.

Stay tuned for some advanced git commands and topics like branches and operations with remote repository which I cover in next article of this series

checkout my `Github 👁`

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

View on GitHub

All you need to know about Mongoose

BHAVIN VIRANI — Tue, 15 Jun 2021 10:29:12 +0000

MnongoDB provides it's native driver to work with our project at server side but it may be large amount of code or repetition in code but it's not the case with mongooses. In this article I am going to tell you how to get started with mongoose
Mongoose is a Node.js package that gives you an interface to play with mongo database. It is very light weight npm package to use in our application. Mongoose has all sets of methods that help you to connect and access data stored in Mongo database.
Mongoose is an Object Data Modeling (ODM) library for MongoDB and Node.js. Mongoose.js provides an abstraction layer on top of MongoDB that eliminates the need to use named collections in native MongoDB driver. Mongoose makes MongoDB easier to work with MongoDB. Mongoose allow developers to enforce a specific schema of desired object at the application layer.

What Mongoose Do ?

provides schema validation
It manages relationships between data
make MongoDB easy to use

Content of this blog

1. Installing and Requiring Mongoose
2. Connecting To MongoDB database
3. Defining Schema
4. Creating Model
5. Creating and Saving Instance
6. Reading from DB
7. Updating
8. Deleting

(1). Installing andRequiring Mongoose

install Mongoose npm package in your project directory as dependency using below shown command in terminal.

npm install mongoose --save

Require mongoose in your application using this syntax

(2). Connecting To MongoDB database

Syntex
mongoose.connect(<Database URI>);
Using connection URI of database we cane connect to database.
here test is Database name
You can get connection Instance by const db = mongoose.connect;
db object is used to listen the events attached to it.

We can use any function method. so don't get confused😕 by seeing it.

(3). Defining Schema

schema is a way to describe *structure of documents * in database.

Schema accepts only the following Datatype.

String
Number
Date
Boolean
Buffer
ObjectId
Mixed
Array In above example some Schema validator are used.

(4). Creating Model

Mongoose model provides an interface to the database for creating, querying, updating, deleting etc...
Model is one type of definition of database collection using collection name and schema name.
Collection Name must be in singular form

(5). Creating and Saving Instance

We can save object in database using save() method on model.

(6). Reading from DB

We can reed data from database using find() on model and also find document by it's id using findById()

(7). Updating

(8). Deleting

For more knowledge checkout my `Github 👁`

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

View on GitHub

2D Vector in C++

BHAVIN VIRANI — Fri, 11 Jun 2021 08:59:46 +0000

We can define 2D Vector as Vector of Vector followed by N number of rows where each of the row is individual a vector. in other words 2D vector is almost similar to a array of vectors but the difference is only in the dynamic properties.

Syntex

vector <vector<data_type>> vector_name;

vector <vector<int>> vct

Initializition

Here vec is the vector of vectors. where outer vector vec represent row as 2D matrix and every sub vectors represent column elements of particular row vector.

N = Number of rows
M - Number of columns Here 2D vector contains N number sub vectors(row) and every sub vector has M number of elements vale of 0

// output of previous initialization 
{ 
  0 0 0 0 
  0 0 0 0
  0 0 0 0 
}

Iteration on 2D vector

vect.begin() – It returns an iterator to the first vector in a 2-D vector.
vect.end() – It returns an iterator to the end of the 2-D vector.
vect.size()– It returns number of elements in vector
v.push_back – Add vector to the empty 2-D vector
v.pop_back() – Remove the last vector from a 2-D vector

Vector in C++

BHAVIN VIRANI — Thu, 10 Jun 2021 16:27:36 +0000

Vectors in C++ are sequence containers representing arrays that can change their size during runtime. They use contiguous storage locations for their elements.

1D Vectors

Syntax

vector<data_type> variable_name
vector<int> vect;

Initializition of vector

Iteration on vector

1

  vector<int> vect(n, 10);

    for (int x : vect)
        cout << x << " ";

2

vector<int> vect(n, 10);
// Traversing the vector using
// values directly
// no need to define datatype of vector
    for (auto& it : vect) {

        // Print the values
        cout << it << ' ';
    }

Insert Elements into vector

Access Elements of vector

deleting vector elements

Other functions

Why Vector ?

Size of arrays are fixed whereas the vectors are resizable i.e they can grow and shrink as vectors are allocated on heap memory. Arrays have to be deallocated explicitly if defined dynamically whereas vectors are automatically de-allocated from heap memory.
Reserve space can be given for vector, whereas for arrays you cannot give reserved space.
A vector is a class whereas an array is a datatype.
Vectors can store any type of objects, whereas an array can store only homogeneous values.

DEV Community: BHAVIN VIRANI

Sequelize Migration

Let's start with all the useful commands

First command after Installing the npm package

Custom configuration

Create migration files and run migrations

Create seeder files and run seeders

For more content check out my Github 👁

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

Begin your opensource journey

So, let's start opensource

(1) You must have git installed in your system. if you don't have git preinstalled, then check out this link,

(2) You must have a github account to find projects and contribute on github project

Step - 1

Fork the repository

Step - 2

Clone the repository to your machine.

Step - 3

Make your new branch

Step - 4

Do changes and commit those changes

Step - 5

Push branch on github

Step - 5

Make pull request

For more knowledge checkout my Github 👁

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

Getting Started with 'Git'

GitHub is a website for hosting projects that use git for version control.

What is git ?

What is github ?

Installation

First step after Installing Git

Create local git repository

Staging

status

Commit

push

Here i Show whole flow of git commands

Conclusion

checkout my Github 👁

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

All you need to know about Mongoose

What Mongoose Do ?

Content of this blog

(1). Installing andRequiring Mongoose

(2). Connecting To MongoDB database

(3). Defining Schema

Schema accepts only the following Datatype.

(4). Creating Model

(5). Creating and Saving Instance

(6). Reading from DB

(7). Updating

(8). Deleting

For more knowledge checkout my Github 👁

bhavinvirani / bhavinvirani

Hi, I'm Bhavin. 👋

2D Vector in C++

Syntex

Initializition

Iteration on 2D vector

Vector in C++

1D Vectors

Syntax

Initializition of vector

Iteration on vector

1

2

Insert Elements into vector

Access Elements of vector

deleting vector elements

Other functions

Why Vector ?

For more content check out my `Github 👁`

For more knowledge checkout my `Github 👁`

What is `git` ?

What is `github` ?

checkout my `Github 👁`

For more knowledge checkout my `Github 👁`