[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / Admin.pm

#
#===============================================================================
#
#         FILE:  Admin.pm
#
#  DESCRIPTION:  Administrative functions for DBIx::Class Schemata
#
#        FILES:  ---
#         BUGS:  ---
#        NOTES:  ---
#       AUTHOR:  Gordon Irving (), <Gordon.irving@sophos.com>
#      VERSION:  1.0
#      CREATED:  28/11/09 12:27:15 GMT
#     REVISION:  ---
#===============================================================================

package DBIx::Class::Admin;

use Moose;
use MooseX::Types;
use MooseX::Types::Moose qw/Int HashRef ArrayRef Str Any/;
use MooseX::Types::Path::Class qw(Dir File);
#use DBIx::Class::Schema;
use Try::Tiny;
use parent 'Class::C3::Componentised';

use Data::Dumper;
=c
		['lib|I:s' => 'Additonal library path to search in'], 
		['schema|s:s' => 'The class of the schema to load', { required => 1 } ],
		['config-stanza|S:s' => 'Where in the config to find the connection_info, supply in form MyApp::Model::DB',],
		['config|C:s' => 'Supply the config file for parsing by Config::Any', { depends => 'config_stanza'} ],
		['connect-info|n:s%' => ' supply the connect info as additonal options ie -I dsn=<dsn> user=<user> password=<pass> '],
		['sql-dir|q:s' => 'The directory where sql diffs will be created'],
		['sql-type|t:s' => 'The RDBMs falvour you wish to use'],
		['version|v:i' => 'Supply a version install'],
		['preversion|p:s' => 'The previous version to diff against',],

    'schema=s'  => \my $schema_class,
    'class=s'   => \my $resultset_class,
    'connect=s' => \my $connect,
    'op=s'      => \my $op,
    'set=s'     => \my $set,
    'where=s'   => \my $where,
    'attrs=s'   => \my $attrs,
    'format=s'  => \my $format,
    'force'     => \my $force,
    'trace'     => \my $trace,
    'quiet'     => \my $quiet,
    'help'      => \my $help,
    'tlibs'      => \my $t_libs,
=cut

=head1 Attributes

=cut
has lib => (
	is		=> 'ro',
	isa		=> Dir,
	coerce	=> 1,
	trigger => \&_set_inc,
);

sub _set_inc {
	my ($self, $lib) = @_;
	push @INC, $lib->stringify;
}


has 'schema_class' => (
	is		=> 'ro',
	isa		=> 'Str',
	coerce	=> 1,
);


has 'schema' => (
	is			=> 'ro',
	isa			=> 'DBIx::Class::Schema',
	lazy_build	=> 1,
);


sub _build_schema {
	my ($self)  = @_;
	$self->ensure_class_loaded($self->schema_class);

	$self->connect_info->[3]->{ignore_version} =1;
	return $self->schema_class->connect(@{$self->connect_info()} ); # ,  $self->connect_info->[3], { ignore_version => 1} );
}

has 'connect_info' => (
	is			=> 'ro',
	isa			=> ArrayRef,
	lazy_build	=> 1,
);

sub _build_connect_info {
	my ($self) = @_;
	return find_stanza($self->config, $self->config_stanza);
}

has config => (
	is			=> 'ro',
	isa			=> HashRef,
	lazy_build	=> 1,
);

sub _build_config {
	my ($self) = @_;
	try { require 'Config::Any'; } catch { die "Config::Any is required to parse the config file"; };

	my $cfg = Config::Any->load_files ( {files => [$self->config_file], use_ext =>1, flatten_to_hash=>1});

	# just grab the config from the config file
	$cfg = $cfg->{$self->config_file};
	return $cfg;
}

has config_file => (
	is			=> 'ro',
	isa			=> File,
);

has 'config_stanza' => (
	is			=> 'ro',
	isa			=> 'Str',
);

has 'sql_dir' => (
	is			=> 'ro',
	isa			=> Dir,
	coerce		=> 1,
);


has 'sql_type' => (
	is			=> 'ro',
	isa			=> 'Str',
);

has version => (
	is			=> 'rw',
	isa			=> 'Str',
);

has preversion => (
	is			=> 'rw',
	isa			=> 'Str',
	predicate	=> 'has_preversion',
);

has force => (
	is			=> 'rw',
	isa			=> 'Bool',
);

has quiet => (
	is			=> 'rw',
	isa			=> 'Bool',
);

has '_confirm' => (
	is		=> 'ro',
	isa		=> 'Bool',
);

sub create {
	my ($self, $sqlt_type, $sqlt_args) = @_;
	if ($self->has_preversion) {
		print "attempting to create diff file for ".$self->preversion."\n";
	}
	my $schema = $self->schema();
	# create the dir if does not exist
	$self->sql_dir->mkpath() if ( ! -d $self->sql_dir);

	$schema->create_ddl_dir( $sqlt_type, (defined $schema->schema_version ? $schema->schema_version : ""), $self->sql_dir->stringify, $self->preversion, $sqlt_args );
}

sub upgrade {
	my ($self) = @_;
	my $schema = $self->schema();
	if (!$schema->get_db_version()) {
		# schema is unversioned
		die "could not determin current schema version, please either install or deploy";
	} else {
		my $ret = $schema->upgrade();
		return $ret;
	}
}

sub install {
	my ($self, $version) = @_;

	my $schema = $self->schema();
	$version ||= $self->version();
	if (!$schema->get_db_version() ) {
		# schema is unversioned
		print "Going to install schema version\n";
		my $ret = $schema->install($version);
		print "retun is $ret\n";
	}
	elsif ($schema->get_db_version() and $self->force ) {
		warn "forcing install may not be a good idea";
		if($self->confirm() ) {
			# FIXME private api
			$self->schema->_set_db_version({ version => $version});
		}
	}
	else {
		die "schema already has a version not installing, try upgrade instead";
	}

}

sub deploy {
	my ($self, $args) = @_;
	my $schema = $self->schema();
	if (!$schema->get_db_version() ) {
		# schema is unversioned
		$schema->deploy( $args, $self->sql_dir)
			or die "could not deploy schema";
	} else {
		die "there already is a database with a version here, try upgrade instead";
	}
}

sub find_stanza {
	my ($self, $cfg, $stanza) = @_;
	my @path = split /::/, $stanza;
	while (my $path = shift @path) {
		if (exists $cfg->{$path}) {
			$cfg = $cfg->{$path};
		}
		else {
			die "could not find $stanza in config, $path did not seem to exist";
		}
	}
	return $cfg;
}

# FIXME ensure option spec compatability
#die('Do not use the where option with the insert op') if ($where);
#die('Do not use the attrs option with the insert op') if ($attrs);
sub insert_data {
	my ($self, $rs, $set) = @_;
	my $resultset = $self->schema->resultset($rs);
	my $obj = $resultset->create( $set );
    print ''.ref($resultset).' ID: '.join(',',$obj->id())."\n" if (!$self->quiet);
}

sub update_data {
	my ($self, $resultset, $set, $where) = @_;
    $resultset = $resultset->search( ($where||{}) );
    my $count = $resultset->count();
    print "This action will modify $count ".ref($resultset)." records.\n" if (!$self->quiet);
    if ( $self->force || $self->confirm() ) {
        $resultset->update_all( $set );
    }
}

# FIXME
#die('Do not use the set option with the delete op') if ($set);
sub delete_data {
	my ($self, $resultset, $where, $attrs) = @_;

    $resultset = $resultset->search( ($where||{}), ($attrs||()) );
    my $count = $resultset->count();
    print "This action will delete $count ".ref($resultset)." records.\n" if (!$self->quiet);
    if ( $self->force || $self->confirm() ) {
        $resultset->delete_all();
    }
}


#FIXME
# die('Do not use the set option with the select op') if ($set);
sub select_data {
	my ($self, $resultset, $where, $attrs) = @_;

	
    $resultset = $resultset->search( ($where||{}), ($attrs||()) );
}

# TODO, make this more generic, for different data formats
sub output_data {
	my ($self, $resultset) = @_;

#	eval {
#		ensure_class_loaded 'Data::Tabular::Dumper';
#	};
#	if($@) {
#		die "Data::Tabular::Dumper is needed for outputing data";
#	}
	my $csv_class;
	# load compatible CSV generators
	foreach $csv_class (qw(Text::CSV_XS Text::CSV_PP)) {
		eval { ensure_class_loaded $csv_class};
		if($@) {
			$csv_class = undef;
			next;
		} 
	}
	if (not defined $csv_class) {
		die ('The select op requires either the Text::CSV_XS or the Text::CSV_PP module');
	}

    my $csv = $csv_class->new({
       sep_char => ( $self->csv_format eq 'tsv' ? "\t" : ',' ),
    });

    my @columns = $resultset->result_source->columns();
    $csv->combine( @columns );
    print $csv->string()."\n";
    while (my $row = $resultset->next()) {
        my @fields;
        foreach my $column (@columns) {
            push( @fields, $row->get_column($column) );
        }
        $csv->combine( @fields );
        print $csv->string()."\n";
    }
}

sub confirm {
    my ($self) = @_;
	print "Are you sure you want to do this? (type YES to confirm) \n";
	# mainly here for testing
	return 1 if ($self->_confirm());
	my $response = <STDIN>;
    return 1 if ($response=~/^YES/);
    return;
}

1;
Commit	Line	Data
9f3849c3	1	#
	2	#===============================================================================
	3	#
	4	# FILE: Admin.pm
	5	#
	6	# DESCRIPTION: Administrative functions for DBIx::Class Schemata
	7	#
	8	# FILES: ---
	9	# BUGS: ---
	10	# NOTES: ---
	11	# AUTHOR: Gordon Irving (), <Gordon.irving@sophos.com>
	12	# VERSION: 1.0
	13	# CREATED: 28/11/09 12:27:15 GMT
	14	# REVISION: ---
	15	#===============================================================================
	16
	17	package DBIx::Class::Admin;
	18
	19	use Moose;
	20	use MooseX::Types;
	21	use MooseX::Types::Moose qw/Int HashRef ArrayRef Str Any/;
	22	use MooseX::Types::Path::Class qw(Dir File);
	23	#use DBIx::Class::Schema;
	24	use Try::Tiny;
	25	use parent 'Class::C3::Componentised';
	26
	27	use Data::Dumper;
	28	=c
	29	['lib\|I:s' => 'Additonal library path to search in'],
	30	['schema\|s:s' => 'The class of the schema to load', { required => 1 } ],
	31	['config-stanza\|S:s' => 'Where in the config to find the connection_info, supply in form MyApp::Model::DB',],
	32	['config\|C:s' => 'Supply the config file for parsing by Config::Any', { depends => 'config_stanza'} ],
	33	['connect-info\|n:s%' => ' supply the connect info as additonal options ie -I dsn=<dsn> user=<user> password=<pass> '],
	34	['sql-dir\|q:s' => 'The directory where sql diffs will be created'],
	35	['sql-type\|t:s' => 'The RDBMs falvour you wish to use'],
	36	['version\|v:i' => 'Supply a version install'],
	37	['preversion\|p:s' => 'The previous version to diff against',],
	38
	39	'schema=s' => \my $schema_class,
	40	'class=s' => \my $resultset_class,
	41	'connect=s' => \my $connect,
	42	'op=s' => \my $op,
	43	'set=s' => \my $set,
	44	'where=s' => \my $where,
	45	'attrs=s' => \my $attrs,
	46	'format=s' => \my $format,
	47	'force' => \my $force,
	48	'trace' => \my $trace,
	49	'quiet' => \my $quiet,
	50	'help' => \my $help,
	51	'tlibs' => \my $t_libs,
	52	=cut
	53
	54	=head1 Attributes
	55
	56	=cut
	57	has lib => (
	58	is => 'ro',
	59	isa => Dir,
	60	coerce => 1,
	61	trigger => \&_set_inc,
	62	);
	63
	64	sub _set_inc {
65	my ($self, $lib) = @_;
66	push @INC, $lib->stringify;
67	}
68
69
70	has 'schema_class' => (
71	is => 'ro',
72	isa => 'Str',
73	coerce => 1,
74	);
75
76
77	has 'schema' => (
78	is => 'ro',
79	isa => 'DBIx::Class::Schema',
80	lazy_build => 1,
81	);
82
83
84
85	sub _build_schema {
86	my ($self) = @_;
87	$self->ensure_class_loaded($self->schema_class);
9f3849c3	88
2ded40e7	89	$self->connect_info->[3]->{ignore_version} =1;
2ded40e7	90	return $self->schema_class->connect(@{$self->connect_info()} ); # , $self->connect_info->[3], { ignore_version => 1} );
9f3849c3	91	}
	92
	93	has 'connect_info' => (
	94	is => 'ro',
	95	isa => ArrayRef,
	96	lazy_build => 1,
	97	);
	98
	99	sub _build_connect_info {
	100	my ($self) = @_;
	101	return find_stanza($self->config, $self->config_stanza);
	102	}
	103
	104	has config => (
	105	is => 'ro',
	106	isa => HashRef,
	107	lazy_build => 1,
	108	);
	109
	110	sub _build_config {
	111	my ($self) = @_;
	112	try { require 'Config::Any'; } catch { die "Config::Any is required to parse the config file"; };
	113
	114	my $cfg = Config::Any->load_files ( {files => [$self->config_file], use_ext =>1, flatten_to_hash=>1});
	115
	116	# just grab the config from the config file
	117	$cfg = $cfg->{$self->config_file};
	118	return $cfg;
	119	}
	120
	121	has config_file => (
	122	is => 'ro',
	123	isa => File,
	124	);
	125
	126	has 'config_stanza' => (
	127	is => 'ro',
	128	isa => 'Str',
	129	);
	130
	131	has 'sql_dir' => (
	132	is => 'ro',
	133	isa => Dir,
	134	coerce => 1,
	135	);
	136
	137
	138
	139	has 'sql_type' => (
	140	is => 'ro',
	141	isa => 'Str',
	142	);
	143
	144	has version => (
912e2d5a	145	is => 'rw',
9f3849c3	146	isa => 'Str',
	147	);
	148
	149	has preversion => (
	150	is => 'rw',
	151	isa => 'Str',
	152	predicate => 'has_preversion',
	153	);
	154
912e2d5a	155	has force => (
	156	is => 'rw',
	157	isa => 'Bool',
	158	);
	159
64c012f4	160	has quiet => (
	161	is => 'rw',
	162	isa => 'Bool',
	163	);
	164
912e2d5a	165	has '_confirm' => (
	166	is => 'ro',
	167	isa => 'Bool',
	168	);
	169
9f3849c3	170	sub create {
2ded40e7	171	my ($self, $sqlt_type, $sqlt_args) = @_;
9f3849c3	172	if ($self->has_preversion) {
	173	print "attempting to create diff file for ".$self->preversion."\n";
	174	}
	175	my $schema = $self->schema();
9f3849c3	176	# create the dir if does not exist
	177	$self->sql_dir->mkpath() if ( ! -d $self->sql_dir);
	178
2ded40e7	179	$schema->create_ddl_dir( $sqlt_type, (defined $schema->schema_version ? $schema->schema_version : ""), $self->sql_dir->stringify, $self->preversion, $sqlt_args );
9f3849c3	180	}
	181
	182	sub upgrade {
	183	my ($self) = @_;
	184	my $schema = $self->schema();
	185	if (!$schema->get_db_version()) {
	186	# schema is unversioned
912e2d5a	187	die "could not determin current schema version, please either install or deploy";
9f3849c3	188	} else {
64c012f4	189	my $ret = $schema->upgrade();
64c012f4	190	return $ret;
9f3849c3	191	}
	192	}
	193
	194	sub install {
912e2d5a	195	my ($self, $version) = @_;
9f3849c3	196
9f3849c3	197	my $schema = $self->schema();
912e2d5a	198	$version \|\|= $self->version();
912e2d5a	199	if (!$schema->get_db_version() ) {
9f3849c3	200	# schema is unversioned
912e2d5a	201	print "Going to install schema version\n";
	202	my $ret = $schema->install($version);
	203	print "retun is $ret\n";
	204	}
	205	elsif ($schema->get_db_version() and $self->force ) {
	206	warn "forcing install may not be a good idea";
	207	if($self->confirm() ) {
	208	# FIXME private api
912e2d5a	209	$self->schema->_set_db_version({ version => $version});
	210	}
	211	}
	212	else {
	213	die "schema already has a version not installing, try upgrade instead";
9f3849c3	214	}
	215
	216	}
	217
	218	sub deploy {
2ded40e7	219	my ($self, $args) = @_;
9f3849c3	220	my $schema = $self->schema();
	221	if (!$schema->get_db_version() ) {
	222	# schema is unversioned
2ded40e7	223	$schema->deploy( $args, $self->sql_dir)
2ded40e7	224	or die "could not deploy schema";
9f3849c3	225	} else {
912e2d5a	226	die "there already is a database with a version here, try upgrade instead";
9f3849c3	227	}
	228	}
	229
	230	sub find_stanza {
	231	my ($self, $cfg, $stanza) = @_;
	232	my @path = split /::/, $stanza;
	233	while (my $path = shift @path) {
	234	if (exists $cfg->{$path}) {
	235	$cfg = $cfg->{$path};
	236	}
	237	else {
	238	die "could not find $stanza in config, $path did not seem to exist";
	239	}
	240	}
	241	return $cfg;
	242	}
	243
	244	# FIXME ensure option spec compatability
	245	#die('Do not use the where option with the insert op') if ($where);
	246	#die('Do not use the attrs option with the insert op') if ($attrs);
	247	sub insert_data {
64c012f4	248	my ($self, $rs, $set) = @_;
64c012f4	249	my $resultset = $self->schema->resultset($rs);
9f3849c3	250	my $obj = $resultset->create( $set );
	251	print ''.ref($resultset).' ID: '.join(',',$obj->id())."\n" if (!$self->quiet);
	252	}
	253
	254	sub update_data {
	255	my ($self, $resultset, $set, $where) = @_;
	256	$resultset = $resultset->search( ($where\|\|{}) );
	257	my $count = $resultset->count();
	258	print "This action will modify $count ".ref($resultset)." records.\n" if (!$self->quiet);
	259	if ( $self->force \|\| $self->confirm() ) {
	260	$resultset->update_all( $set );
	261	}
	262	}
	263
	264	# FIXME
	265	#die('Do not use the set option with the delete op') if ($set);
	266	sub delete_data {
	267	my ($self, $resultset, $where, $attrs) = @_;
	268
	269	$resultset = $resultset->search( ($where\|\|{}), ($attrs\|\|()) );
	270	my $count = $resultset->count();
	271	print "This action will delete $count ".ref($resultset)." records.\n" if (!$self->quiet);
	272	if ( $self->force \|\| $self->confirm() ) {
	273	$resultset->delete_all();
	274	}
	275	}
	276
	277
	278	#FIXME
	279	# die('Do not use the set option with the select op') if ($set);
	280	sub select_data {
	281	my ($self, $resultset, $where, $attrs) = @_;
	282
	283
	284	$resultset = $resultset->search( ($where\|\|{}), ($attrs\|\|()) );
	285	}
	286
	287	# TODO, make this more generic, for different data formats
	288	sub output_data {
	289	my ($self, $resultset) = @_;
	290
	291	# eval {
	292	# ensure_class_loaded 'Data::Tabular::Dumper';
	293	# };
	294	# if($@) {
	295	# die "Data::Tabular::Dumper is needed for outputing data";
	296	# }
	297	my $csv_class;
	298	# load compatible CSV generators
	299	foreach $csv_class (qw(Text::CSV_XS Text::CSV_PP)) {
	300	eval { ensure_class_loaded $csv_class};
	301	if($@) {
	302	$csv_class = undef;
	303	next;
	304	}
	305	}
	306	if (not defined $csv_class) {
	307	die ('The select op requires either the Text::CSV_XS or the Text::CSV_PP module');
	308	}
	309
	310	my $csv = $csv_class->new({
	311	sep_char => ( $self->csv_format eq 'tsv' ? "\t" : ',' ),
	312	});
	313
314	my @columns = $resultset->result_source->columns();
315	$csv->combine( @columns );
316	print $csv->string()."\n";
317	while (my $row = $resultset->next()) {
318	my @fields;
319	foreach my $column (@columns) {
320	push( @fields, $row->get_column($column) );
321	}
322	$csv->combine( @fields );
323	print $csv->string()."\n";
324	}
325	}
326
327	sub confirm {
912e2d5a	328	my ($self) = @_;
64c012f4	329	print "Are you sure you want to do this? (type YES to confirm) \n";
912e2d5a	330	# mainly here for testing
	331	return 1 if ($self->_confirm());
	332	my $response = <STDIN>;
9f3849c3	333	return 1 if ($response=~/^YES/);
	334	return;
	335	}
	336
	337	1;