Symfony/Doctrine foreingkey at uniqueBy fileds, in sluggable behavior

Question

I have the schema:

State:
  actAs:
    I18n:
      fields: [state]
      actAs:
        Sluggable:
          unique: true
          uniqueBy: [lang, state]
          fields: [state]
          canUpdate: true
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    country_id:
      type: string(2)
    state:
      type: string(255)
      notnull: true

And I want a unique slug by lang/state, whith this schema works fine, but, now I want a unique slug by lang/state/country_id. So, I add country_id to uniqueBy fields, but that don't work because the sluggable model is on translation table and country_id not.

Is there any idea how can i solved that?

Thanks a lot!

Besnik Besnik · Accepted Answer · 2012-07-08T15:58:47

What about declaring your own slug builder?

State:
  actAs:
    I18n:
      fields: [state]
      actAs:
        Sluggable:
          unique: true
          uniqueBy: [lang, state]
          fields: [state]
          builder: [MyTools, slugify]
          canUpdate: true

Symfony/Doctrine foreingkey at uniqueBy fileds, in sluggable behavior

1 Answers