Columns:
bt_brand_to_category_id
int(11) UN AI PK
bt_brand_id
varchar(20)
bt_category_id
int(11) UN
RelationId
i get the value of bt_brand_to_category_id
/* 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();
}
}
Error during migration run:
TypeError: this.subQuery is not a function
@OneToMany(type => Pic, item => item.page)
@ManyToOne(type => Page, item => item.pics, { onDelete: 'CASCADE' })
@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;
@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
getConnection().getMetadata(Entity);
.createQueryBuilder()
and it's not returning the correct data, but the raw SQL is. Any ideas what I'm missing?