Hi,
> Are you sure that your structure is right?
> Mine is (based on the Tutorial) App/lib/AppDB/Modell/Table.pm
I have named the AppDB like the application because the database is named
that way. The file App.pm just contains
__PACKAGE__->config(
schema_class => 'App::Schema',
connect_info => [
'dbi:mysql:xxx',
'xxx',
'xxx',
],
);
Anyway, all tables are dynamically loaded so I assume that configuration
is correct for the moment.
> In the table class I can create custom functions to alter or get the
> resultsets.
Where do you put queries that join multiple tables? I think such queries
do not fit well into a Table.pm but in AppDB.pm.
> With DBIC you can do almost everything, e.g. multi table joins, creating
> aliases with user defined functions and procedures.
May be you can do anything with DBIC -- at the cost of having to learn it
instead of just and easy placing an SQL statement into the code. Maybe
DBIC would be more fun if I would have found better documentation. That is
why I need to access a dbh.
Regards, Stephan
_______________________________________________
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/
