Hi I am running the most up todate version of the following
> On Sun, Jul 31, 2011 at 12:18 PM, <[email protected]> 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, <[email protected]> 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: [email protected] >>> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst >>> Searchable archive: >>> http://www.mail-archive.com/[email protected]/ >>> Dev site: http://dev.catalyst.perl.org/ >>> >> >> >> >> _______________________________________________ >> List: [email protected] >> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst >> Searchable archive: >> http://www.mail-archive.com/[email protected]/ >> Dev site: http://dev.catalyst.perl.org/ >> > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
