Insert into select using typeom
I try to execute an “INSERT INTO SELECT” using typeorm in a nestjs project.
I’ve correctly sett the subscriber part, but when I want to execute my function, I have an error
typeorm
Return softDeleted relation rows
I have a table called “bsService” where I save my created services, that services have some relations like, categories, activities and others. I’m trying to get services where categories was softDeleted, example: service 1 relates to category 1, then I softDeleted category 1, now this service don’t return on findAll even if add ‘withDeleted: true’ on the query.
filter table based on join but select all joins without taking filter into account
I have the following query generated with the Typeorm querybuilder
Nest.js TypeORM connect to local database (on docker container)
I have local MySQL database created in docker container from following docker-compose.yml
TypeORM/MySQL: Cannot delete or update a parent row: a foreign key constraint fails
I have an entity relationship between comments and posts _many-to-one_. I’m using typeorm and typegraphql
Search from keys in foreign table – mysql
I am using nestjs and typeorm (Mysql). I have two tables users and categories, and in category table i have a foreign key linked to userid. What i want to do is search firstName from user table while querying the category table.
How to query id not in condition with another table typeorm
Here is the query
TypeORM MariaDB Primary Key as UUID
Having a really strange issue with TypeORM and MariaDB. I have two entities with UUIDs as the primary key. The Companies entity is working fine as it scaffolds the schema as CHAR but the users table is being instantiated as an auto increment INT.
Complex relations TypeORM / MySQL
I’m using TypeORM with MySQL, I have two Entity, User and Project:
How to save 2 entities that are related Typeorm?
I have a NestJS project that has an entity called Users. In this entity there are login related information about a user. I also have another entity called Profile, that will hold the user’s name, pictures etc…