TutorialOnNodeJs

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

TutorialOnNodeJs

★ 11 Open GitHub ↗

No description available.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# TutorialOnNodeJs

STEP 1 :

Please create database  in mysql with the 2 of these tables :

CREATE TABLE `productcategory` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryName` varchar(100) NOT NULL,
  `Details` varchar(400) DEFAULT NULL,
  `IsValid` tinyint(1) NOT NULL,
  `CreatedDate` datetime NOT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `idx_productcategory_CreatedDate` (`CreatedDate`) COMMENT 'Added Index on the createdate'
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

CREATE TABLE `product` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ProductCategory_FK` int(11) DEFAULT NULL,
  `ProductCost` float NOT NULL,
  `Name` varchar(200) NOT NULL,
  `Description` longtext,
  `CreatedDt` datetime NOT NULL,
  `IsActive` tinyint(1) NOT NULL,
  `UpdatedDt` datetime DEFAULT NULL,
  `ProductPrice` float NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `FKC_Product_to_ProductCategory_idx` (`Id`,`ProductCategory_FK`),
  KEY `FKC_Product_to_ProductCategory` (`ProductCategory_FK`),
  CONSTRAINT `FKC_Product_to_ProductCategory` FOREIGN KEY (`ProductCategory_FK`) REFERENCES `productcategory` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

STEP 2:

Please find the code Inside the Server/Dao/mysqlConnectionString.js; include your mysql connecting string information such as host name, user, password, database etc

connection  :{
        
        dev : {
            host: 'localhost',
            user: 'root',
            password : 'yourdevpassword',
            database : 'yourdevdatabase'
        }

qa : {
             host: 'localhost',
            user: 'root',
            password : 'yourtestpassword',
            database : 'yourdatabase'
        }
        ,prod : {
            host: 'urProductonHost',
            user: 'userId',
            password : 'password',
            database : 'databaseName'
        }
    
    }

TutorialOnNodeJs

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README