I see the following error:
> ./test.pl MyApp::Schema::Result::._RptCase does not look like a package name at /usr/local/lib/perl5/site_perl/Module/Find.pm line 208. Compilation failed in require at ./test.pl line 10. BEGIN failed--compilation aborted at ./test.pl line 10. >
Running:
The script looks like this:
#!/usr/local/bin/perl
use v5.10;
use strict;
use warnings;
use Data::Dumper;
no warnings 'experimental';
use lib 'lib';
use MyApp::Schema;
use DBIx::Class;
# Include the login info
our $dbhost;
our $dbuser;
our $dbpass;
require 'private.pl';
# Setup the DB Connections
my $source = "dbi:mysql:database=dvt_teamtrack_reporting;host=localhost";
my $schema = MyApp::Schema->connect($source, 'root');
# We only care about the EM projects right now
my $em_rs = $schema->resultset('RptProject')->search({ ts_ladder => { -like => '%Emerging Markets%'} });
# Grab the project IDs
my @project_ids = $em_rs->get_column('ts_id')->all;
Line 10 is the 'use MyApp::Schema;' line.
I generated the Schema for DBIx::Class by using dbicdump and connected to the local mysql as root with no password by running:
> dbicdump -o dump_directory=./lib -o components='["InflateColumn::DateTime"]' MyApp::Schema dbi:mysql:dvt_reporting root
This error seems to go away if I
rm -fr liband re-run the dbicdump command. But only if I actually rm and rerun dbicdump. Just rerunning dbicdump over the top is not enough.