Unknown related component on class with Doctrine inheritance, Symfony 1.4
I have a symfony 1.4 project to show products
in a category
product view. Products can be viewed in different categories so I have a many-to-many relationship between product and category.
I also have different types of products so have used Doctrine inheritance to define them as most of them share a lot of the same properties.
Now the problem I am having is that when trying to add a product to a category I am getting the error:
Unknown record property / related component "CategoriesFeaturedIn" on "MultiProduct"
CategoriesFeaturedIn is the property on the Product that holds which categories it is in as defined in the Doctrine schema.
MultiProduct inherits from Product so should have this property yes?
I will post below my schema and the code i'm using for adding a product to a category. Hopefully someone can help and I can provide any more information as neccessary.
--
Schema: (not the whole file)
Category:
actAs:
Sluggable:
fields: [title]
columns:
id:
type: integer
primary: true
notnull: true
autoincrement: true
title:
type: string(255)
notnull: true
image:
type: string(255)
store_id:
type: integer
notnull: true
sort_order:
type: integer
relations:
Store:
class: Store
local: store_id
onDelete: CASCADE
foreignAlias: Categories
Parents:
class: Category
refClass: CategoryCategory
foreign: parent_category_id
foreignAlias: Subcategories
CategoryFeaturedProduct:
columns:
category_id:
type: integer
primary: true
product_id:
type: integer
primary: true
relations:
Category:
foreignAlias: FeaturedProducts
onDelete: CASCADE
Product:
foreignAlias: CategoriesFeaturedIn
onDelete: CASCADE
Product:
actAs:
Sluggable:
fields: [title]
columns:
id:
type: integer
primary: true
notnull: true
autoincrement: true
title:
type: string(255)
description:
type: string(255)
link:
type: string(255)
image:
type: string(255)
large_image:
type: string(255)
featured_image:
type: string(255)
sku:
type: string(64)
mpid:
type: string(64)
stock:
type: integer
price:
type: decimal
rrp:
type: decimal
was_price:
type: decimal
rating:
type: decimal
sort_order:
type: integer
promotion_id:
type: integer
manufacturer_id:
type: integer
notnull: true
relations:
Promotion:
class: Promotion
local: promotion_id
onDelete: SET NULL
foreignAlias: Products
Manufacturer:
class: Manufacturer
local: manufacturer_id
onDelete: CASCADE
foreignAlias: Products
Categories:
class: Category
refClass: ProductCategory
foreignAlias: Products
CategoriesFeaturedIn:
class: Category
refClass: CategoryFeaturedProduct
foreignAlias: FeaturedProducts
MultiProduct:
inheritance:
extends: Product
type: column_aggregation
keyField: type
keyValue: 开发者_开发知识库 2
Code:
$product = ProductTable::getInstance()->find($prod_id);
$category = CategoryTable::getInstance()->find($cat_id);
$product->addCategoryFeaturedIn($category);
Product Class:
public function addCategoryFeaturedIn($category)
{
$this->CategoriesFeaturedIn[] = $category;
}
I actually managed to resolve this issue although I'm not entirely sure on the answer but I did two things and everything worked.
Firstly I reordered my schema file so it reads like so:
Category:
actAs:
Sluggable:
fields: [title]
columns:
id:
type: integer
primary: true
notnull: true
autoincrement: true
title:
type: string(255)
notnull: true
image:
type: string(255)
store_id:
type: integer
notnull: true
sort_order:
type: integer
relations:
Store:
class: Store
local: store_id
onDelete: CASCADE
foreignAlias: Categories
Parents:
class: Category
refClass: CategoryCategory
foreign: parent_category_id
foreignAlias: Subcategories
Product:
actAs:
Sluggable:
fields: [title]
columns:
id:
type: integer
primary: true
notnull: true
autoincrement: true
title:
type: string(255)
description:
type: string(255)
link:
type: string(255)
image:
type: string(255)
large_image:
type: string(255)
featured_image:
type: string(255)
sku:
type: string(64)
mpid:
type: string(64)
stock:
type: integer
price:
type: decimal
rrp:
type: decimal
was_price:
type: decimal
rating:
type: decimal
sort_order:
type: integer
promotion_id:
type: integer
manufacturer_id:
type: integer
notnull: true
relations:
Promotion:
class: Promotion
local: promotion_id
onDelete: SET NULL
foreignAlias: Products
Manufacturer:
class: Manufacturer
local: manufacturer_id
onDelete: CASCADE
foreignAlias: Products
Categories:
class: Category
refClass: ProductCategory
foreignAlias: Products
CategoriesFeaturedIn:
class: Category
refClass: CategoryFeaturedProduct
foreignAlias: FeaturedProducts
MultiProduct:
inheritance:
extends: Product
type: column_aggregation
keyField: type
keyValue: 2
CategoryFeaturedProduct:
columns:
category_id:
type: integer
primary: true
product_id:
type: integer
primary: true
relations:
Category:
foreignAlias: FeaturedProducts
onDelete: CASCADE
Product:
foreignAlias: CategoriesFeaturedIn
onDelete: CASCADE
I also changed my Product method to read as so:
public function addCategory($category)
{
$this->getCategories()->add($category);
}
I imagine the reordering of the schema file is what actually did the trick and fixed this problem which does suggest that you need to define relationships in the schema after you have defined the actual tables which are related.
The change of the method probably didnt affect this but its worth noting as this is what I believe to be a better way to add to a many-to-many relationship.
精彩评论