Skip to content

Tag: sql

Getting A Month’s Worth of Data With KnexJS

I’m trying to get a month’s worth of data using KnexJS, I only have the year and month in the form 20xx-mm. Here’s my Knex query .. The issue is, I’m starting at a specific date and going through to the 31’st day, some months have 30 days, some 28 and 29. How do I go about to creating a

How to do an If await by the async function response

I’m trying to create a function that checks if a table already exists in the database and if it doesn’t, create one But the problem is the If doesn’t await for checkTableExist() Console Log Answer In checkTableExist you are checking your DB Query results using a callback function. In there, when you return, you are not actually returning to the

how do path at the final url like this “~” [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 10 months ago. Improve this question what is code “~” from the end of this url ?, and what mean ? Answer Need more exemples in yout context, but in

How to add dynamic Where queries in objection.js?

I have a table which has a global search bar that needs to trigger search for all fields like firstName, lastName, email and role. Also have a dynamic filter which can have single or multiple filter like “firstName” or/And “lastName” Obviously they need to be paginated. For pagination i can use Model.query().page(1, 10) But how to supply search or filter.