What is the correct way of structuring mySQL code in a nodejs projects?

user_11005092 0
Viewed 113

I have been working on a project lately and using node as my back-end but instead of Mongodb I am using MySQL as my DBMS as I will need it in my project but I am having trouble organizing MySQL queries and can't find a good solution that helps me structure my code and files right. And another issue is that I don't know when to close my connection or if leaving it is a good practice or not.

NOTE: I already use express generator for generating my file architecture my only problem is where to place the MySQL related code and what are the best practices for a clean code.

express node.js relational-database mysql sql
1 Answers

You can create a model folder and add all your 'tables'.js there. You can also create a DB.js file, so you can use Mysql from Nodejs and also manipulate it from the prompt:

Model Exemple

I.e of DB connection: DB Connection

You can create tables on the way below. ID's, creating date and updated date are created automatically by Nodejs, so you don't need to worry about.

how to create a table

You also will need to download mySQL (npm install MySQL --save) and to interact with MySQL (selects, deletes,...)

Another way is create a repository.js and add SQL queries there, but is not really useful since you are using nodejs and it provides you these queries.

user_157947650
Related