On Sun, Jul 31, 2011 at 12:18 PM, gor...@gorste.plus.com wrote:
To better help you, please indicate:
- Operating System of the Catalyst App
Ubuntu 8.04.4 LTS
- RDBMS version and host OS
Ubuntu 8.04.4 LTS using MySql 5.0.51a-3ubuntu5.8-log
(same box as my catalyst application)
The Perl in 8.04 is probably quite old.
- DBD (DBI Driver)
DBIx::Class 0.08195
DBIx::Class::Schema::Loader 0.07010
DBIx::Class::Schema::Loader::DBI::mysql 0.07010
DBIx::Class::Schema::Loader::DBI::SQLite 0.07010
I get the same if I use sqllite or mysql so I think there is an issue with
DBIx::Class.
DBIx::Class works on top of the plain-old DBI/DBD scheme. So when I
asked for the DBD I meant the actual DBI driver, examples:
DBD::SQLite
DBD::mysql
DBD:;Pg
Try static models like the following examples:
When working with SQLite you must generate your model clases with the
path to the DB file like so:
script/[app]_create.pl model [model name] DBIC::Schema
[app]::Schema::[model name] create=static
dbi:SQLite:dbname=data/catmodels.db
Assuming data/ exists from the root of the application
When working with MySQL try something like this:
script/[app]_create.pl model [model name] DBIC::Schema
[app]::Schema::[model name] create=static dbi:mysql:[dbname] [user]
[pass]
If you are connecting to more than one DB just use different model
names for each ;-)
If the static model generation was successful you should be able to
look inside the Schema Result classes and verify that you can actually
see the relations defined in each class with every field, type and
relationships (has_many, belongs_to etc.).
If you are unable to generate the static DBIC model try a small
program with plain-old DBI and see if you can actually connect to the
DB and have the correct privileges to extract the schema.
perldoc DBI
Cheers,
--
Alejandro Imass
Gordon
On Fri, Jul 29, 2011 at 12:14 PM, gor...@gorste.plus.com wrote:
Alejandro
I am using the create fuction catalyst provides, I find that is the
best
way of creating the model. Does it need 'source_name' in the classes
that it creates.
Hi Gordon,
To better help you, please indicate:
- Operating System of the Catalyst App
- RDBMS version and host OS
- DBD (DBI Driver)
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive:
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/