Skip to content

Tag: javascript

strapi with mysql running simple raw sql

Need to run this query in my test and unable to find the right syntax. This is no postgresql and mysql does not like hyphens in table names. Please suggest. Answer Simply don’t use not allowed characters, it makes the life much more easy. The backticks around the String, where implemented, so that theuser dind’t need to escapee single and

Get List of Users for a Specific Local Time

In my database, I have a list of users with the user ids and their UTC offset in minutes. It’s in a PostgreSQL database which I access through sequelize in my node application. For example: I want to create a query that, when run, gets me a list of users that have passed 12pm noon their local time. For example,

Converting a SQL query to SEQUELIZE

I am trying to wrap my head around creating this sequelize query. I have been able to create 2 separate queries where the ‘order by filter’ works and ‘aliases’ work, but not combined. This is what i currenty have in sequelize Answer You just need to use fn twice: in order and in attributes options: Also you can combine findAll

many to many relationship knex js

I am trying to fetch data from the database in this way: I want all the templates and those templates have an array of categories in it so the methode I am currently using currently I am doing this but the object doesn’t seem to alter. Answer You are not waiting for the promises to resolve. You should do: instead

Need help by populating a PrimeReact Tree

I’m trying to populate a PrimeReact Tree with data from sqlite3 database, but it doesnt work. Here is my SQL-Query: I get following JSON-Code: This is OK but i figured out, that the children are not rendered, because there are quotes around the square brackets at the children path – how can i fix this? Answer If initial is your

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 last month. Improve this question what is code “~” from the end of this url ?, and what mean ? Answer Need more exemples in yout context, but in general

How to keep table name when inner joining related tables

I am new to SQL and wonder how to select nested tables. I have two tables like this: sensors sensor_id model_no location_id int varchar int locations location_id name location radius int varchar point int They are linked with foreign key. Currently, I select using to get the data from both like this: I wonder if there is any way I


i a new user and a new in React world. I need help to solve this situation about a Select with values from mysql DB. I receive the values, but the select goes in infinite loop. The error is surely in this file cause server.js works without problem!! Really thanks for the help, and sorry if it could be a