Is there any way we can use operator or regex as we normally do with the whereIn() clause. I want to use something like this $query->whereIN(name,'like','%te
I am trying to get average rating of an associated Model "Rating" of Model "User" using sequelize. sequelize.sync({logging: false}).then(()=>{ return Mode
I am building a webapp in which users place orders with nested information. I am after some advice on best practice so I can do some more research. The idea is
I have a question about Orm or RAW sql Can you tell me which one I should choose if I want to create a large-scale project? And why?
I have a use case where I have to retrieve a users record from the database via his date of birth. The thing is that we have stored the date of birth of the use
Am new in Node Js, In my Node Js project am using sequelize ORM with MySql database. This is my query i want to write select query by month. This is my query
I'm still new to .NET Core. I have this character that I want to store in SQLite using an entity. But by default, Character, CharacterData and CharacterLine are
I have 3 type of users salesman => has many buyers buyer => has many agents agent has none child so I want to list all the buyers associate with that sale
I'm trying to validate a SQLAlchemy model before it is inserted or updated, e.g class MyModel(db.Model): foo = db.Column(db.String(255)) bar = db.Colum
At the moment I'm not a guru on TypeORM and have made a few mistakes with my migrations - with our non-production database now in a state where I'd like it, is
I'm trying to model a simple (at least I thought so) relationship like in a recipe (I'm using flask-sqlalchemy): I have a Recipe, that has input materials and o
I'm new in Doctrine ORM, and I need help with building QueryBuilder command. I have a SQL command and I need covert to QueryBuilder. $qb = $this->entityManag
Creating a spring mvc project with database using java configuration . The application gives error for tables operation like create, drop, alter operation for
I have a Room (v2.4.0-beta01) database, and whilst it works fine, during the build it gives a field vs getter mismatch warning on a few fields, included below.
In the Hibernate 6.0 Roadmap (https://github.com/hibernate/hibernate-orm/wiki/Roadmap6.0) SQM is mentioned as upcoming. What is SQM? In this roadmap the follo
I'm trying to use the ARRAY datatype for Sequelize (Node.js SQL ORM) with PostgreSQL. However I'm not exactly sure how to utilize it. I know how to set it on th
In adonis.js i am trying to add a unique constraint to email field just like we do it in sequelize,prismajs or any other orm.Is it posible to add in adonis.
I would like to know if there is a feature of TypeORM that supports raw sql queries for Insert Update Delete Select etc..
I am having a pyramid application which uses sqlalchemy and alembic for databases and migrations. I need to remove default specifier from my model class and add
I want to make query in Laravel Eloquent like here its raw MySQL query SELECT * from exampleTbl where id in(1,2,3,4) I have tried this in Laravel Eloquent