How to properly deploy a schema using DBIx :: Class?

Question

i'am new for databases and DBIx: class. So please forgive me if this is a complete newbie mistake. I just went for the tutorial and then tried to deploy the schema to my database. According to the tutorial, I broke the modules in several files. After I run createTable.pl "mysqlshow bla" shows me an empty database.

Work with the database is started. Creating a table using the mysql CREATE TABLE statement works.

The script file that should create the table according to the schema .. /createTable.pl

#!/usr/bin/env perl use Modern::Perl; use MyDatabase::Main; my ($database, $user) = ('bla', 'flo'); my $schema = MyDatabase::Main->connect("dbi:mysql:dbname=$database", "$user"); $schema->deploy( { auto_drop_tables => 1 } ); 

Main.pm for loading namespaces. /MyDatabase/Main.pm

 package MyDatabase::Main; use base qw/ DBIx::Class::Schema /; __PACKAGE__->load_namespaces(); 1; 

Schema file for table .. /MyDatabase/Result/Album.pm

 package MyDatabase::Main::Result::Album; use base qw/ DBIx::Class::Core /; __PACKAGE__->load_components(qw/ Ordered /); __PACKAGE__->position_column('rank'); __PACKAGE__->table('album'); __PACKAGE__->add_columns(albumid => { accessor => 'album', data_type => 'integer', size => 16, is_nullable => 0, is_auto_increment => 1, }, artist => { data_type => 'integer', size => 16, is_nullable => 0, }, title => { data_type => 'varchar', size => 256, is_nullable => 0, }, rank => { data_type => 'integer', size => 16, is_nullable => 0, default_value => 0, } ); __PACKAGE__->set_primary_key('albumid'); 1; 

I have already spent several hours searching for help via google, but not much is involved with the deploy () method. Can someone explain to me that my mistake? thank you

Answer 1

You can find documentation for all CPAN Perl modules at metacpan.org (later, full-text indexing) and search.cpan.org.

Read the docs for DBI, you will find the DBI_TRACE environment variable, which when set will print each SQL statement in STDOUT. DBIx :: Class has a similar DBIC_TRACE. The first will help you find out what the deployment method does.

Is a password required to connect to your database?

Answer 2

Well, today I played again with perl and the database, and I found out what the error was.

First of all, I started with DBI_TRACE and DBIC_TRACE, it issued a lot of messages, but could not process anything, for me it seemed nothing gave me a hint of a problem.

Then I searched Google for a while about this problem and other examples of the deployment method. At some point, I noticed that my folder structure is incorrect.

The schema file for the table must be placed in

../MyDatabase/Home/Results/Album.pm

instead of being placed in

../MyDatabase/Result/Album.pm

After moving the schema file to the correct folder, everything works fine.

Shame on me for this mistake :( But thanks for your help