CSV to SQL import using Node, Express and React

Krishankant Ray — Sun, 19 Apr 2020 13:44:14 +0000

CSV to SQL import

What is this app all about ?

This app allows users to import a .csv file and save it in MySQL. The .csv file needs to be in a specified format, something like this .
Once the data is saved we can see and delete the table data on the front-end.

Whats there on back-end and front-end ?

Back-End :
- NodeJS
- ExpressJS
- MySQL
Front-End :
- ReactJS

Here is the SQL table structure :

Field	Type
id	int(11)
level_col	varchar(255)
cvss	varchar(255)
title	varchar(255)
vulnerability	varchar(255)
solution	varchar(255)
reference_col	varchar(255)

Where is it deployed ?

Client side app ( React app ) is deployed on Netlify
Server side app ( Node app ) is deployed on Heroku
MySQL database is deployed on Remote Mysql

How to run it locally ?

To run it locally we need to clone two git repositories, one for the server and other for the client ( front-end).

To clone the client repo :

git clone https://github.com/krishankantray/csv-to-sql-import-client.git

To clone the server repo :

git clone https://github.com/krishankantray/csv-to-sql-import-server.git

The above git setup is for online server auto deployment on Heroku and Netlify .
We need to make some changes in it to run it locally.

First we setup the server locally :

Open the directory : csv-to-sql-import-server , in any vscode or any other editor. - If you have a local MySql db then do replace the details in the app>>config>>db.config.js

If you don't have a local MySql db then leave it as it is.

Now, open terminal ( in the directory : csv-to-sql-import-server ):

npm install

npm start

It should print in terminal :

Server is running on port 9000.

( Make sure there is nothing previously running on port 9000, if there is then change the >port from line 25 of server.js )

To test if all APIs are working, open postman and use following APIs

GET call for obtaining all the records, url should be : http://localhost:9000/customers/ .

GET call for single records by id, for eg : http://localhost:9000/customers/963

POST call for bulk create records : http://localhost:9000/bulkcreate This call needs a body to be passed

POST call for single create records http://localhost:9000/customers This call needs a body to be passed

DELETE call for all records deletion

http://localhost:9000/customers
DELETE call for records deletion

http://localhost:9000/customers/963
PUT call to update a single record

http://localhost:9000/customers/963

Now, we will configure the local front-end ( React app ) :

We only need to make some changes in App.js within src directory.
Just change the line 35 , 69 and 97, i.e we need to change the URL of all the fetch calls from Apps.js.

For Example :

35 : Before https://csv-to-sql-import.herokuapp.com/bulkcreate
35 : After http:localhost:9000/bulkcreate

Similarly for line 69 and 97 , just replace this part of URL -
https://csv-to-sql-import.herokuapp.com
with
http:localhost:9000

and rest of the part of url remains same.

Keeping continuity in Competitve Programming

Krishankant Ray — Sat, 21 Dec 2019 09:30:57 +0000

Most of people start competitive programming in college mostly to end up landing into a good job. Probably because hiring process of almost all companies are mostly same i.e. they ask problems similar to the one in CP.

Like everyone, I also started CP in college during end of my second year ( my graduation was of 4 years ). I got to know about codechef from my college notice board ( some of my seniors posted an article about CP on the notice board).
I was a bit curious about codechef, so, in the evening when I came back to hostel room, I started searching about codechef and similar platforms. I ended up reading several articles on quora and eventually landed up on HackerRank.
I was not a very hard core problem solver and I used to solve very fewer questions initially. But slowly as I kept on learning new algorithms and c++ in more depth.
So, by the time placements season came andcompanies started visiting our colleges, I had solved around 200+ problems on HackerRank and 90+ problems on codechef. I was able to clear almost all the service based companies like Infosys, Wipro and Cognizant. But could not clear Directi exam ( Directi is the company behind codechef ). I ended up joining a job as an Application Support Engineer( I don't know why they named it engineer, although there is nothing to engineer in a support role ), in a US based comapany which makes event management softwares.
Also, I was able to clear Amazon's coding round but didn't appear for the interview, probably because of lack of confidence and motivation. Once you start doing a job you won't be that much motivated to prepare for an interview. It might happen due to lack of time and hectic life. But still some people manage to overcome these things, but I am not one of them.
And while doing a job its extremely difficult to maintain motivation to do CP even on weekends. It just doesn't feels like those college days when solving a problem used to give fun and happeness.

I wrote this article because I thought there must many people like me, who would be thinking that only they are not able to do CP while in a job, then probably I should tell them that it's not true, there are many.

Thanks for reading till end.

DEV Community: Krishankant Ray