Krishan Dev Personal Blog

 index.js: const express = require ( 'express' ); const app = express (); const mongoose = require ( 'mongoose' ); const connectDB = async () => {     mongoose . connect ( 'mongodb://localhost:27017/e-Comm' );     const productSchema = new mongoose . Schema ({});     const products = mongoose . model ( 'products' , productSchema )     const data = await products . find ();     console . warn ( data ); } connectDB (); app . listen ( 5000 );

 index.js: const express = require ( 'express' ); const con = require ( './config12' ) const app = express (); app . use ( express . json ()); app . get ( "/" , ( req , resp ) => {     con . query ( "select * from user" , ( err , result ) => {         if ( err ){             resp . send ( "error" )         } else {             resp . send ( result )         }     }) }); app . post ( '/' , ( req , resp ) => {       const data = req . body ;     con . query ( 'Insert into users3 SET?' , data ,( error , result , fields ) => {         if ( error ) error ;         resp . send ( result )     }) }); app . put ( '/:id' , ( req , resp ) => {     const data =[ req . body . name , req . body . password , req . params . id ];     con . query ( "Update users SET name=?, password=? where id =? " , data , ( err , result , fields ) => {     if ( err ) throw error ;     resp . send ( result )    }) }

 config.js const mysql = require ( 'mysql' ) const con = mysql . createConnection ({     host : 'localhost' ,     user : 'root' ,     password : '' ,     database : 'test' }); con . connect (( err ) => {     if ( err ){         console . warn ( "error in connection" );     } }) module . exports = con ; index.js const express = require ( 'express' ); const con = require ( './config12' ) const app = express (); app . get ( "/" , ( req , resp ) => {     con . query ( "select * from user" , ( err , result ) => {         if ( err ){             resp . send ( "error" )         } else {             resp . send ( result )         }     }) }); app . listen ( 5000 )

 index.js: const mysql = require ( "mysql" ); const con = mysql . createConnection ({     host : 'localhost' ,     user : 'root' ,     password : '' ,     database : 'test' }); con . connect (( err ) => {     if ( err ){         console . warn ( "error" )     }     else {         console . warn ( "connected" )     } }); con . query ( "select * from user" , ( err , result ) => { console . warn ( result ) })

 config.js -  const mongoose = require ( 'mongoose' ) mongoose . connect ( 'mongodb://localhost:27017/e-Comm' ) Product.js: const mongoose = require ( 'mongoose' ); const productSchema = new mongoose . Schema ({     name : String ,     price : Number ,     brand : String ,     category : String });   module . exports = mongoose . model ( 'products' , productSchema ); index.js: const express = require ( 'express' ); require ( './config' ); const product = require ( './product' ); const app = express (); app . use ( express . json ()); app . post ( '/create' , async ( req , resp ) => {     let data = new product ( req . body );     let result = await data . save ();     console . log ( result )     resp . send ( result ); }); app . get ( '/list' , async ( req , resp ) => {     let data = await product . find ();     resp . send ( data ); }); app . delete ( '/delete/:_id' , async ( req , r

 index.js -  const mongoose = require ( 'mongoose' ); const saveInDB = async () => {     await mongoose . connect ( 'mongodb://localhost:27017/e-Comm' );     const ProductSchema = new mongoose . Schema ({         name : String ,         brand : String ,         price : Number ,         category : String     });     const ProductsModel = mongoose . model ( 'products' , ProductSchema );     let data = new ProductsModel ({ name : 'm9' , brand : 'LG' , price : 150 , category : 'mobile' });     let result = await data . save ();     console . log ( result ); } const updateInDB = async () => {     await mongoose . connect ( 'mongodb://localhost:27017/e-Comm' );     const ProductSchema = new mongoose . Schema ({         name : String ,         brand : String ,         price : Number ,         category : String     });     const Product = mongoose . model ( 'products' , ProductSchema

Api.js: const express = require ( 'express' ); const dbConnect = require ( './mongodb' ); const mongodb = require ( 'mongodb' ) const app = express (); app . use ( express . json ()); app . get ( '/' , async ( req , resp ) => {     let data = await dbConnect ();     data = await data . find (). toArray ();     console . log ( data )     resp . send ({ data }) }); app . post ( '/' , async ( req , resp ) => {     let data = await dbConnect ();     let result = await data . insert ( req . body )         resp . send ( result ) }); app . put ( '/' , async ( req , resp ) => {     let data = await dbConnect ();     let result = await data . updateOne (         { name : req . body . name },         { $set : req . body }     )     console . log ( req . body )     resp . send ({ result : "Updated" }) }); app . delete ( '/:id' , async ( req , resp ) => {     console . log ( req . params . id )     const