that are filled by the mysql server
const connection = await db()
await connection
.getRepository(Visit)
.createQueryBuilder('vis')
.select('vis.visitId')
.addSelect('ord.orderId')
.innerJoin(Orders, 'ord', 'vis.visitId = ord.visitId')
.where('vis.locationId = :id', { id })
.getMany()
.then(res => (success = res))
.catch(({ code, message }) => (error = { code, message }))
await connection
.getRepository(Visit)
.createQueryBuilder('vis')
.select('vis.visitId')
.addSelect('ord.orderId')
.innerJoin(Orders, 'ord', 'vis.visitId = ord.visitId')
.where('vis.locationId = :id', { id })
.getMany()
.then(res => (success = res))
.catch(({ code, message }) => (error = { code, message }))
why would orderId not show up in the results?
Columns:
bt_brand_to_category_id
int(11) UN AI PK
bt_brand_id
varchar(20)
bt_category_id
int(11) UN
My current direction is to just declare "one to many" from categories to this table, and from brands to this table,
But when i want to use features like
But when i want to use features like
RelationId i get the value of bt_brand_to_category_id
@alexeightsix Hey Alexander, yes that's indeed possible. You can see a good example on https://github.com/w3tecch/express-typescript-boilerplate/ of both, using faker under the hood for factories
This repo boilerplate was what made me stick with TS/TypeORM. Hope it helps . They ended up creating a npm package for typeorm seeding: https://github.com/w3tecch/typeorm-seeding
/* tslint:disable:completed-docs no-any */
import { MigrationInterface, QueryRunner } from 'typeorm';
import { User } from '../../modules/core/entities/user.model';
export class AddSampleUsers1557597276952 implements MigrationInterface {
public async up(queryRunner: QueryRunner): Promise<any> {
await queryRunner
.manager
.createQueryBuilder()
.insert()
.into(User)
.values([
{ name: 'John Doe', email: 'john@doe.com', username: 'john.doe', password: '12345' },
{ name: 'Agata Doe', email: 'agata@doe.com', username: 'agata.doe', password: '12345' },
])
.execute();
}
public async down(queryRunner: QueryRunner): Promise<any> {
await queryRunner
.manager
.createQueryBuilder()
.delete()
.from(User)
.where('email = :email', { email: 'john@doe.com' })
.orWhere('email = :email', { email: 'agata@doe.com' })
.execute();
}
}
The error when I run the migration:
Error during migration run:
TypeError: this.subQuery is not a function
node_modules/typeorm/query-builder/QueryBuilder.js:361:57
eg. page.entity.ts:
pic.entity.ts:
@OneToMany(type => Pic, item => item.page)pic.entity.ts:
@ManyToOne(type => Page, item => item.pics, { onDelete: 'CASCADE' })
obviously these entities have to import each other to make that happen the usual way. Webpack says no-no. Any ideas?
will lose the benefit of any cascaded saves but who uses them anyway... :)
Toni, check out this, you can use typeorm with graphql+modules 👌🏻 https://link.medium.com/oxU6b8Is8W
say i have a user, and i want to get that user, their posts, but the posts should contain only the titles
@ssdk86
Hello, guys.
in php doctrine ORM we have opportunity to set order by default in model instance like this
@ORM\OrderBy({"date" = "DESC"})
for example so we set order to addresses items as order : [[ 'date', 'DESC' ]]
/**
* @var \KR\Model\PeopleAddresses[]
*
* @ORM\OneToMany(targetEntity="\PeopleAddresses", mappedBy="people")
* @ORM\OrderBy({"date" = "DESC"})
* @ORM\JoinColumn(name="id", referencedColumnName="people_id")
*/
protected $addresses;and is there a way to do that in typeorm?
@Field(type => OrdersModel, { nullable : true })
***@OrderBy('date', 'DESC')***
@HasMany(() => OrdersModel)
ordersItem: OrdersModel;i try like this, but it is not work
@Field(type => OrdersModel, {
nullable : true,
defaultValue: [{
key: "date",
order: "ASC"
}]
})
@HasMany(() => OrdersModel)
ordersItem: OrdersModel;
Hey All, i am looking for a way to get all relations for a specific entity. Could use some help.
https://stackoverflow.com/questions/56888170/get-relations-for-a-specific-entity
https://stackoverflow.com/questions/56888170/get-relations-for-a-specific-entity
@reggi I looked into the github code. Found something like:
hasRelation<T>(target: ObjectType<T>|string, relation: string|string[]): boolean {
const entityMetadata = this.connection.getMetadata(target);
const relations = relation instanceof Array ? relation : [relation];
return relations.every(relation => {
return !!entityMetadata.findRelationWithPropertyPath(relation);
});
}may this help you? :o
I got the response instantly :o
getConnection().getMetadata(Entity);
weird
I'll look into this thanks @Lyth0
Question: I am trying to query on deep relations, can this be done? https://stackoverflow.com/questions/56993963/query-by-deep-properties-on-relations
Trying to do this the legitimate way using
typeorm/typeorm#4423
.createQueryBuilder() and it's not returning the correct data, but the raw SQL is. Any ideas what I'm missing?typeorm/typeorm#4423