[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