DEFINITION I have connected my cube js backend to mongodb. I am storing documents inside my mongo db database in a following way. THIS IS HOW MY DOCUMENT LOOKS LIKE IN MONGO DB So now let us assume that I have 10 documents in my mongodb collection in which 5 documents belong to user: “abc” and 5 d…
Tag: sql
How to create chartjs chart with data from database C#
I am trying to create a chart.js graph in my .Net Core Web app, with data from the database. I am using ajax to call a method that will pull the data from the database, but I’m unsure how to group the data to display in the graph. At the moment I have a database that looks like so: I
SQL UPDATE event not working correctly with discord.js via message event
I’ve been trying over the past days to get an SQL UPDATE event to work correctly with discord.js using the mysql npm package. All the login details and table, column names are correct. This is meant to update the integer every time a message is sent in the Discord text channel. I have tried multiple typ…
How to Insert bulk Array of data in mssql table using nodejs
I am using node-mssql, LInk : https://www.npmjs.com/package/mssql i want to insert bulk array of data in mssql database i am getting array of array records eg: [[row1],[row2],[row3]] i want to insert these records in mssql database Error : The label ‘@’ has already been declared. Label names must …
Looping an SQL statement on razor
Attempted to create a ‘cart’ which holds selected items by the user but upon form completion, all the data from the ‘cart’ is inserted into one row Example: How do I separate the data into a row each? Intended Result: How it works: The user will click a button that will generate the fo…
sequelize compare date with date-timestamp
my simple use case is I pass a date and try to compare that with the default createdAt column. and my date is a string like this date = ‘2018-12-12’ The problem here is sequlize not compare only the date. But it does add time 00:00:00 to my date and then compare. So the query sequlize generate is …
node-mssql Transaction insert – Returning the inserted id..?
I’m using node-mssql 3.2.0 and I need to INSERT INTO a table and return the id of the inserted record. I can successfully use sql.Transaction() to insert data, but the only parameters given to callbacks (request.query() and transaction.commit()) are: So recordset is undefined for INSERT, UPDATE and DELE…
How do I properly insert multiple rows into PG with node-postgres?
A single row can be inserted like this: This approach automatically comments out any special characters. How do i insert multiple rows at once? I need to implement this: I can just use js string operators to compile such rows manually, but then i need to add special characters escape somehow. Answer Following…
Sequelize – How to search multiple columns?
I have a database of articles with several columns and would like to be able to search both title and description. Currently, I have: How can I also search the description as well? I’ve read through the sequelize documentation, even in the Complex filtering / OR / NOT queries section, but the examples o…
Remove constraints in sequelize migration
I’m adding a unique constraint in a migration via the migrations.changeColumn function. Adding the constraint works, but since you need to provide a “backwards migration“, removing it the same way does not. It doesn’t give any errors when migrating backwards, but again applying the forward migrati…