We have a table with around 10k rows, with the following scheme: item_id: TEXT (Primary Key) xml_1: XML xml_2: XML country: TEXT Running the following query takes around 9 to 10 seconds: SELECT * FROM info_table WHERE item_id IN ('item1','item2','...'…
exports.signup = async (req, res) => { const { username, password, name } = req.body; // TODO: Validate if username exists await knex("users").insert({ username, password, name }); const user = await knex("users").where({ username }).first(); // const users = await knex("users").where({username});…
I have a web application built on Node.js and I use Knex as my db tool. It has all worked perfectly for months, but now, one of the columns in my db is not updating correctly. I have the columns…
Currently moving a web application over to using Knex to help with issues to do with SQL injection. Knex has helped us to stop the issue of running different and new queries however we have a point of concern. Currently…
Looked at some of the other posts asking about the error 'column "column_name" referenced in foreign key constraint does not exist' but none of the answers/situations seem to match exactly: Currently have two migration files: 20210123122225_createReservationsTable.js exports.up = function (knex)…
I'm setting up my integration testing rig. I'm using the beforeEach and afterEach hooks to wrap every single test in a transaction that rollsback so that the tests don't affect each other. A simplified example might be this: const {…
I'm using postgres and I try to make my request with array_agg in knex, but I have the error: "message": "Expected 1 bindings, saw 0" Does anyone know where this error may come from? And how can I fix it?…
I am new to knex.js for mysql queries, I have following three queries which take a long time to resolve. is there a better way to do the following await db.transaction((trx) => { let queries = existingProductsArr.map((tuple) => { const…
I have Dockerfile that works with API and MySQL database and it should do migrations: FROM node WORKDIR /api COPY . . RUN npm install EXPOSE 3001 VOLUME [ "/api/node_modules" ] CMD [ "npm", "start" ] Also, there is a…
I have an app using knex for migration. Earlier someone made an unique index on one column using knex.raw like this: const createProgrammeTable = knex => knex.raw(` CREATE TABLE programme ( id serial PRIMARY KEY, date date NOT NULL, published…