1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
package DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult;
$DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult::VERSION = '0.002233';
# ABSTRACT: The typical way to store versions in the database
use strict;
use warnings;
use parent 'DBIx::Class::Core';
my $table = 'dbix_class_deploymenthandler_versions';
__PACKAGE__->table($table);
__PACKAGE__->add_columns (
id => {
data_type => 'int',
is_auto_increment => 1,
},
version => {
data_type => 'varchar',
# size needs to be at least
# 40 to support SHA1 versions
size => '50'
},
ddl => {
data_type => 'text',
is_nullable => 1,
},
upgrade_sql => {
data_type => 'text',
is_nullable => 1,
},
);
__PACKAGE__->set_primary_key('id');
__PACKAGE__->add_unique_constraint(['version']);
__PACKAGE__->resultset_class('DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResultSet');
sub sqlt_deploy_hook {
my ( $self, $sqlt_table ) = @_;
my $tname = $sqlt_table->name;
return if $tname eq $table;
# give indices unique names for sub-classes on different tables
foreach my $c ( $sqlt_table->get_constraints ) {
( my $cname = $c->name ) =~ s/\Q$table\E/$tname/;
$c->name($cname);
}
}
1;
# vim: ts=2 sw=2 expandtab
__END__
=pod
=head1 NAME
DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult - The typical way to store versions in the database
=head1 AUTHOR
Arthur Axel "fREW" Schmidt <frioux+cpan@gmail.com>
=head1 COPYRIGHT AND LICENSE
This software is copyright (c) 2019 by Arthur Axel "fREW" Schmidt.
This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.
=cut
|
