I'm building a website using react js as front end with node as back end and mongo db as database. I put some dummy data in the database like this and im using express and mongoose.created the database in atlas.…
I often reach a crossroad in my code when it comes to passing methods vs generic objects vs specialised objects. Let me explain. I am using the mediator pattern. I have DAO's which have generic methods based on a specific…
I have a problem here which i believe it has 2 solutions. Here is my first implementation with function overloading: type PostgresConnectionOptions = { dialect: "postgres"; config: pg.PoolConfig; }; type MysqlConnectionOptions = { dialect: "mysql"; config: mysql.PoolOptions; }; type SQLiteConnectionOptions…
in the following query i want to search on both name and agreementNumber but in OR mode, if name or agreementNumber matches then find but it is not working like this async findAll(filter: DataFilterDto): Promise<ApiResponseDto> { const take = filter.count…
I read a Certificate Signing Request in X.509 format. I have tried to parse it with the class X509Certificate from NodeJS 'crypto' library. The input format is a string -----BEGIN CERTIFICATE REQUEST----- MII.... -----END CERTIFICATE REQUEST----- I want to get…
I have a React + Express app that is fetching the data normally when on localhost. On public domain, React app loads, but it throws this error on my fetch requests "Failed to load resource: net::ERR_CONNECTION_REFUSED". Also I don't know…
I trying to set up a Node.js backend for an Angular app I am creating. I got the server set up, and am now trying to call a function from a different class that will hit a third-party API. My…
In Mongoose, you can write a statement like the following, to return documents with restricted fields, and only 10 of them. This returns the same 10 documents every time, which is expected. products = await Product.find({ category: category, }) .select("title…
I'm querying Vertica using node-vertica npm packge (Node server), I noticed that every time the ROUND expression is 0/null, I'm getting the error - ERROR: Schema "pg_catalog" does not exist. EDIT: For example: SELECT name, email, ROUND(SUM(grade)/nullifzero(count(grade))) as avrage ---->…
I am trying to implement redis into my nodejs and expressjs API REST, but for some reason I am getting the error The client is closed. I´ve installed redis for windows I´ve ran redis-server in the cmd. I´ve tested the…