view _test/Test/SQL/Diff.pm @ 415:3d24b10dd0d5 ref20150831

working on IMPL::Config::Container
author cin
date Tue, 20 Oct 2015 07:32:55 +0300
parents 8d36073411b1
children
line wrap: on
line source

package Test::SQL::Diff;
use strict;
use warnings;

use IMPL::declare {
    require => {
        MySQLProcessor => 'IMPL::SQL::Schema::MySQL::Processor',
        SQLSchema => 'IMPL::SQL::Schema',
        SQLDiff => 'IMPL::SQL::Schema::Diff'
    },
    base => [
        'IMPL::Test::Unit' => '@_'
    ]    
};

use IMPL::Test qw(test failed assert);
use IMPL::SQL::Types qw(Integer Varchar Text);
use Data::Dumper;


test diff => sub {
    my $schemaSrc = SQLSchema->new(name => 'simple', version => 1 );
    
    my $schemaDst = SQLSchema->new(name => 'simple', version => 2 );
    
    my $users = $schemaDst->AddTable({
        name => 'User',
        columns => [
            { name => 'id', type => Integer, tag => {auto_increment => 1} },
            { name => 'login', type => Varchar(255) },
            { name => 'description', type => Text, isNullable => 1 }
        ]
    });
    
    $users->SetPrimaryKey('id');
    $users->AddConstraint( unique => { name => 'unique_login', columns => ['login'] } );
    
    my $profile = $schemaDst->AddTable({
        name => 'Profile',
        columns => [
            { name => 'id', type => Integer, tag => {auto_increment => 1} },
            { name => 'uid', type => Integer },
            { name => 'data', type => Text }
        ]
    });
    
    $profile->SetPrimaryKey('id');
    $profile->LinkTo($users, 'uid');
    
    my $diff = SQLDiff->Diff($schemaSrc,$schemaDst);
    
    my $processor = MySQLProcessor->new($schemaSrc);
    $processor->ProcessBatch($diff);
    
    $schemaSrc->Dispose;
    $schemaDst->Dispose;
    
};


1;