2 #===============================================================================
6 # DESCRIPTION: Administrative functions for DBIx::Class Schemata
11 # AUTHOR: Gordon Irving (), <Gordon.irving@sophos.com>
13 # CREATED: 28/11/09 12:27:15 GMT
15 #===============================================================================
17 package DBIx::Class::Admin;
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;
25 use parent 'Class::C3::Componentised';
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',],
39 'schema=s' => \my $schema_class,
40 'class=s' => \my $resultset_class,
41 'connect=s' => \my $connect,
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,
51 'tlibs' => \my $t_libs,
61 trigger => \&_set_inc,
65 my ($self, $lib) = @_;
66 push @INC, $lib->stringify;
70 has 'schema_class' => (
79 isa => 'DBIx::Class::Schema',
87 $self->ensure_class_loaded($self->schema_class);
88 warn Dumper $self->connect_info();
90 return $self->schema_class->connect($self->connect_info()}, $self->connect_info->[3], { ignore_version => 1} );
93 has 'connect_info' => (
99 sub _build_connect_info {
101 return find_stanza($self->config, $self->config_stanza);
112 try { require 'Config::Any'; } catch { die "Config::Any is required to parse the config file"; };
114 my $cfg = Config::Any->load_files ( {files => [$self->config_file], use_ext =>1, flatten_to_hash=>1});
116 # just grab the config from the config file
117 $cfg = $cfg->{$self->config_file};
126 has 'config_stanza' => (
152 predicate => 'has_preversion',
156 my ($self, $sqlt_type, ) = @_;
157 if ($self->has_preversion) {
158 print "attempting to create diff file for ".$self->preversion."\n";
160 my $schema = $self->schema();
161 # warn "running with params sqlt_type = $sqlt_type, version = " .$schema->schema_version . " sql_dir = " . $self->sql_dir . " preversion = " . ($self->has_preversion ? $self->preversion : "" ). "\n";
162 # create the dir if does not exist
163 $self->sql_dir->mkpath() if ( ! -d $self->sql_dir);
165 $schema->create_ddl_dir( $sqlt_type, (defined $schema->schema_version ? $schema->schema_version : ""), $self->sql_dir->stringify, $self->preversion );
170 my $schema = $self->schema();
171 if (!$schema->get_db_version()) {
172 # schema is unversioned
173 warn "could not determin current schema version, please either install or deploy";
182 my $schema = $self->schema();
183 if (!$schema->get_db_version()) {
184 # schema is unversioned
185 print "Going to install schema version";
186 $schema->install($self->version);
188 warn "schema already has a version not installing, try upgrade instead";
195 my $schema = $self->schema();
196 if (!$schema->get_db_version() ) {
197 # schema is unversioned
200 warn "there already is a database with a version here, try upgrade instead";
205 my ($self, $cfg, $stanza) = @_;
206 my @path = split /::/, $stanza;
207 while (my $path = shift @path) {
208 if (exists $cfg->{$path}) {
209 $cfg = $cfg->{$path};
212 die "could not find $stanza in config, $path did not seem to exist";
218 # FIXME ensure option spec compatability
219 #die('Do not use the where option with the insert op') if ($where);
220 #die('Do not use the attrs option with the insert op') if ($attrs);
222 my ($self, $resultset, $set) = @_;
223 my $obj = $resultset->create( $set );
224 print ''.ref($resultset).' ID: '.join(',',$obj->id())."\n" if (!$self->quiet);
228 my ($self, $resultset, $set, $where) = @_;
229 $resultset = $resultset->search( ($where||{}) );
230 my $count = $resultset->count();
231 print "This action will modify $count ".ref($resultset)." records.\n" if (!$self->quiet);
232 if ( $self->force || $self->confirm() ) {
233 $resultset->update_all( $set );
238 #die('Do not use the set option with the delete op') if ($set);
240 my ($self, $resultset, $where, $attrs) = @_;
242 $resultset = $resultset->search( ($where||{}), ($attrs||()) );
243 my $count = $resultset->count();
244 print "This action will delete $count ".ref($resultset)." records.\n" if (!$self->quiet);
245 if ( $self->force || $self->confirm() ) {
246 $resultset->delete_all();
252 # die('Do not use the set option with the select op') if ($set);
254 my ($self, $resultset, $where, $attrs) = @_;
257 $resultset = $resultset->search( ($where||{}), ($attrs||()) );
260 # TODO, make this more generic, for different data formats
262 my ($self, $resultset) = @_;
265 # ensure_class_loaded 'Data::Tabular::Dumper';
268 # die "Data::Tabular::Dumper is needed for outputing data";
271 # load compatible CSV generators
272 foreach $csv_class (qw(Text::CSV_XS Text::CSV_PP)) {
273 eval { ensure_class_loaded $csv_class};
279 if (not defined $csv_class) {
280 die ('The select op requires either the Text::CSV_XS or the Text::CSV_PP module');
283 my $csv = $csv_class->new({
284 sep_char => ( $self->csv_format eq 'tsv' ? "\t" : ',' ),
287 my @columns = $resultset->result_source->columns();
288 $csv->combine( @columns );
289 print $csv->string()."\n";
290 while (my $row = $resultset->next()) {
292 foreach my $column (@columns) {
293 push( @fields, $row->get_column($column) );
295 $csv->combine( @fields );
296 print $csv->string()."\n";
301 print "Are you sure you want to do this? (type YES to confirm) ";
302 my $response = <STDIN>;
303 return 1 if ($response=~/^YES/);