I can't say I know anything of Catalyst or FormFu, but I do know about
web applications and database integrations. What exactly do you mean by
"a web database"? Usually people are trying to create some sort of
content delivery system on the web, which utilizes a database for data
storage. That is, the object in question is not specifically a database
- it is the application that delivers information that is really being
created.
Perhaps if you could give an example of the result you are getting
versus the result you expect, it would be more clear exactly what you're
asking. Perhaps it is doing what its supposed to but that is not what
you expect.
In my experience constraints are database side things more than
DBIx::Class things, but you're using the Schema Loader, which is yet
another specific I don't have personal experience with. I know thats
supposed to bridge the gap in some way.
David
Ascii King wrote:
I am a rookie programmer trying to set up a web database. I am having
trouble understanding how to get the add_unique_constraint working. I
am using Catalyst and FormFu and I cannot get the method working as i
expect. I added the following line to my Schema file:
# Created by DBIx::Class::Schema::Loader v0.04004 @ 2009-05-14 10:18:31
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5sD0bi0DMi9SwUz0z7Jt7A
__PACKAGE__->add_unique_constraint(username => [ qw/username/ ]);
But, it does not seem to affect my code at all. I would like each
username to be unique in the system and prevent dupklicates from being
entered. i am using both an SQLite3 database and a separate instance
on a MS SQL Server.
The only change I have made to my code is this one line, though I
tried several different examples I found on the web.
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive:
http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
