首页 > 解决方案 > 从数据库获取数据时如何纠正 404 错误?

问题描述

我想使用 Redis-Caching 从 SQL 服务器获取数据,但是当我发送请求 (GET http://localhost:4000/product/Data ) => 我看到这个错误:

                GET /product/Data 404 7.390 ms - 33
                GET /product/Data - - ms - -

,我该如何解决呢?

服务器.js:

   const redis = require("redis");
   const redisUrl='redis://127.0.0.1:6379'; 
   // create Redis client on Redis port
   const client = redis.createClient(redisUrl);
   //  create express application instance

   const Data=async(req,res,next)=>{
   cache,getData
   }
   //Make request to DataBase for Data 
async function getData(req,res,next){
            try{
            console.log('Fetching Data From SQL server...')
            const Pull_Products=await 
            SingletonSqlHandler.instance.sendQuery('SELECT * from 
            dbo.getAllProducts()')        
            // return Pull_Products;
            return res.status(200).send.json(Pull_Products)
            }
            catch(error){
            console.error(error);
            res.status(500).json({error:error})
            }
           }
          // Cache midleware
          async function cache(req,res,next){
               console.log('Fetching Data From Cache...')
               const Pull_Products=await 
               SingletonSqlHandler.instance.sendQuery('SELECT * from 
               dbo.getAllProducts()')        
               client.get(Pull_Products,(error,cachedData)=>{
               if(error) throw error
               if(cachedData!=null){
                    res.send(setResponse(Pull_Products,cachedData));
                }
              else {
                     next();
               }
              })
           }
          module.exports={
           Data:Data
          }

productRoute.js:

      const router = require('express').Router();
      const Redis=require('../redis-cache/server')
      router.get('/Data', Redis.Data);
      module.exports = router;

标签: node.js

解决方案


推荐阅读