On 8/24/06, James Masters <[EMAIL PROTECTED]> wrote:
First, you should stop right there and work on that problem. What is this missing module, why is it missing, and can it be fixed? This doesn't sound sane/normal. I've haven't heard about people who cannot use load_classes. And no, "use MG::Schema::Foo" is *not* an adequate substitute.
The Loader currently does force all column names to lower case. Normal DBIx::Class lets you specify them however you like, and honors that specification. The decision to lowercase them all in Schema::Loader just makes the code *much* simpler than dealing with all of the cross-vendor case issues that exist for what Loader is doing. At least for the time being, if you want CamelCase column names in DBIx::Class, you have to do it for yourself.
The error itself is pointing you somewhere. What's on line 325 of S::A::L? (and what version do you have installed from where?).
-- Brandon
Thanks for the advice. I have been re-reading the documentation and have made some progress by using the Loader Debugger.Firstly, let me reply to your 2 points. Of course, I did first try to use ->load_classes. This didn't work - the error said I was missing a module; I can't remember the name of it now but I couldn't find a win32 version of it so gave up
First, you should stop right there and work on that problem. What is this missing module, why is it missing, and can it be fixed? This doesn't sound sane/normal. I've haven't heard about people who cannot use load_classes. And no, "use MG::Schema::Foo" is *not* an adequate substitute.
Anyway, with the debugger, I have learnt that the Loader was working fine. I can see all the tables, columns and PKs being loaded. Also I got the resultsets to work - the problem was that I was specifying CountryCode (which is indeed the correct name of my column) but to get it to work I have to use lower case "countrycode". Someone has told me that this is because MySQL columns are not case-sensitive and all columns are stored in lower case. [ Still, I don't think this is ideal behaviour personally as I like my "cased" column names. Wouldn't a better behaviour be for the methods to accept any case? Not sure if possible as might mess up other database interfaces - just wondering. ]
The Loader currently does force all column names to lower case. Normal DBIx::Class lets you specify them however you like, and honors that specification. The decision to lowercase them all in Schema::Loader just makes the code *much* simpler than dealing with all of the cross-vendor case issues that exist for what Loader is doing. At least for the time being, if you want CamelCase column names in DBIx::Class, you have to do it for yourself.
However, I am left with a problem. The following error:Attempt to free unreferenced scalar: SV 0x1fa7a5c, Perl interpreter: 0x224234 at C:/Perl/site/lib/SQL/Abstract/Limit.pm line 325.occurs every time I attempt to use a resultset. Tinkering has established that it occurs with each of the following lines.my @livecountries = $schema->resultset('Country')->search(live => 'Y');
my $m = $schema->resultset('Country')->next->countryname;
my @allcountries = $schema->resultset('Country')->all;
my $country = $schema->resultset('Country')->find(1)->countryname;
my $r = $schema->resultset('Region')->find(1)->regionname;
my $p = $schema->resultset('Product')->find(1)->description;If I put all 6 lines, it occurs 6 times. It happens if this is the last thing in the script.This only happens when the schema is loaded via Loader - it did not appear when the schema was loaded via my manually created module. The Loader debugger does not give any clues. If anyone can point me in the right direction for further reading/investigation, I'd be very grateful.
The error itself is pointing you somewhere. What's on line 325 of S::A::L? (and what version do you have installed from where?).
-- Brandon
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
