[Dbix-class] DBIx::Class::Schema::Loader limitations

Daniel McBrearty danielmcbrearty at gmail.com
Thu Jun 29 21:50:03 CEST 2006


thanks.

so presumably if you have constraints that are a bit more complex than
unique/PK, you code these somehow into your model classes, and never
really touch the sql itself?

(we currently have stuff like :

CREATE TABLE languages(
  id SERIAL PRIMARY KEY,
  language_code TEXT UNIQUE,
  is_original BOOLEAN NOT NULL DEFAULT FALSE
);

-- there can only be ONE base language
CREATE UNIQUE index languages_only_one_true_base_idx
ON languages (is_original)
WHERE is_original;

in db.sql - I guess I'd have to overload the accessor or something with DBIx?
)




-- 
Daniel McBrearty
email : danielmcbrearty at gmail.com
www.engoi.com : the multi - language vocab trainer
BTW : 0873928131



More information about the Dbix-class mailing list