X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FVersioned.pm;h=0799202d33e778d3def73f2cdd79a96ec3bf4f87;hb=5b60f0c107afa5bfac568b691f663e2430df7618;hp=2744b8a19a5468df68681ed68cc49dcc61e06fb3;hpb=ffdf4f11299b7dc0f9c57521688823f7cd1ed19f;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Schema/Versioned.pm b/lib/DBIx/Class/Schema/Versioned.pm index 2744b8a..0799202 100644 --- a/lib/DBIx/Class/Schema/Versioned.pm +++ b/lib/DBIx/Class/Schema/Versioned.pm @@ -1,4 +1,5 @@ -package DBIx::Class::Version::Table; +package # Hide from PAUSE + DBIx::Class::Version::Table; use base 'DBIx::Class'; use strict; use warnings; @@ -28,7 +29,8 @@ __PACKAGE__->add_columns ); __PACKAGE__->set_primary_key('version'); -package DBIx::Class::Version::TableCompat; +package # Hide from PAUSE + DBIx::Class::Version::TableCompat; use base 'DBIx::Class'; __PACKAGE__->load_components(qw/ Core/); __PACKAGE__->table('SchemaVersions'); @@ -43,14 +45,16 @@ __PACKAGE__->add_columns ); __PACKAGE__->set_primary_key('Version'); -package DBIx::Class::Version; +package # Hide from PAUSE + DBIx::Class::Version; use base 'DBIx::Class::Schema'; use strict; use warnings; __PACKAGE__->register_class('Table', 'DBIx::Class::Version::Table'); -package DBIx::Class::VersionCompat; +package # Hide from PAUSE + DBIx::Class::VersionCompat; use base 'DBIx::Class::Schema'; use strict; use warnings; @@ -125,26 +129,6 @@ __PACKAGE__->mk_classdata('backup_directory'); __PACKAGE__->mk_classdata('do_backup'); __PACKAGE__->mk_classdata('do_diff_on_init'); -=head2 schema_version - -Returns the current schema class' $VERSION; does -not- use $schema->VERSION -since that varies in results depending on if version.pm is installed, and if -so the perl or XS versions. If you want this to change, bug the version.pm -author to make vpp and vxs behave the same. - -=cut - -sub schema_version { - my ($self) = @_; - my $class = ref($self)||$self; - my $version; - { - no strict 'refs'; - $version = ${"${class}::VERSION"}; - } - return $version; -} - =head2 get_db_version Returns the version that your database is currently at. This is determined by the values in the @@ -157,7 +141,7 @@ sub get_db_version my ($self, $rs) = @_; my $vtable = $self->{vschema}->resultset('Table'); - my $version; + my $version = 0; eval { my $stamp = $vtable->get_column('installed')->max; $version = $vtable->search({ installed => $stamp })->first->version; @@ -186,6 +170,8 @@ database type. This method should return the name of the backup file, if appropriate.. +This method is disabled by default. Set $schema->do_backup(1) to enable it. + =cut sub backup @@ -242,8 +228,8 @@ sub _create_db_to_schema_diff { my $filename = $self->ddl_filename( $db, - $self->upgrade_directory, $self->schema_version, + $self->upgrade_directory, 'PRE', ); my $file; @@ -298,8 +284,8 @@ sub upgrade my $upgrade_file = $self->ddl_filename( $self->storage->sqlt_type, - $self->upgrade_directory, $self->schema_version, + $self->upgrade_directory, $db_version, ); @@ -338,7 +324,7 @@ sub _read_sql_file { @data = split(/;/, join('', @data)); close($fh); @data = grep { $_ && $_ !~ /^-- / } @data; - @data = grep { $_ !~ /^(BEGIN TRANACTION|COMMIT)/m } @data; + @data = grep { $_ !~ /^(BEGIN TRANSACTION|COMMIT)/m } @data; return \@data; } @@ -349,22 +335,16 @@ allows you to run your upgrade any way you please, you can call C any number of times to run the actual SQL commands, and in between you can sandwich your data upgrading. For example, first run all the B commands, then migrate your data from old to new tables/formats, then -issue the DROP commands when you are finished. - -Will run the whole file as it is by default. +issue the DROP commands when you are finished. Will run the whole file as it is by default. =cut sub do_upgrade { - my ($self) = @_; + my ($self) = @_; - ## overridable sub, per default just run all the commands. - $self->run_upgrade(qr/create/i); - $self->run_upgrade(qr/alter table .*? add/i); - $self->run_upgrade(qr/alter table .*? (?!drop)/i); - $self->run_upgrade(qr/alter table .*? drop/i); - $self->run_upgrade(qr/drop/i); + # just run all the commands (including inserts) in order + $self->run_upgrade(qr/.*?/); } =head2 run_upgrade @@ -397,16 +377,36 @@ sub run_upgrade return 1; } +=head2 connection + +Overloaded method. This checks the DBIC schema version against the DB version and +warns if they are not the same or if the DB is unversioned. It also provides +compatibility between the old versions table (SchemaVersions) and the new one +(dbix_class_schema_versions). + +To avoid the checks on connect, set the env var DBIC_NO_VERSION_CHECK or alternatively you can set the ignore_version attr in the forth arg like so: + + my $schema = MyApp::Schema->connect( + $dsn, + $user, + $password, + { ignore_version => 1 }, + ); + +=cut + sub connection { my $self = shift; $self->next::method(@_); - $self->_on_connect; + $self->_on_connect($_[3]); return $self; } sub _on_connect { - my ($self) = @_; + my ($self, $args) = @_; + + $args = {} unless $args; $self->{vschema} = DBIx::Class::Version->connect(@{$self->storage->connect_info()}); my $vtable = $self->{vschema}->resultset('Table'); @@ -421,6 +421,8 @@ sub _on_connect } } + # useful when connecting from scripts etc + return if ($args->{ignore_version} || ($ENV{DBIC_NO_VERSION_CHECK} && !exists $args->{ignore_version})); my $pversion = $self->get_db_version(); if($pversion eq $self->schema_version)