MySQL-RunSQL

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

Revision history for Perl extension MySQL::RunSQL.

1.0  Wed Sep 12 10:16:45 2012
	- original version; created by h2xs 1.23 with options
		-AX MySQL::RunSQL
1.1 Fri Sep 14 9:02 2010
	- modified Modern::Perl use statement
1.2 - fixed params validate

META.json  view on Meta::CPAN

      },
      "configure" : {
         "requires" : {
            "ExtUtils::MakeMaker" : "0"
         }
      },
      "runtime" : {
         "requires" : {
            "DBI" : "1.617",
            "Excel::Writer::XLSX" : "0.5",
            "Modern::Perl" : "1.20120521",
            "Params::Validate" : "1.06"
         }
      }
   },
   "release_status" : "stable",
   "version" : "1.2"
}

META.yml  view on Meta::CPAN

  url: http://module-build.sourceforge.net/META-spec-v1.4.html
  version: 1.4
name: MySQL-RunSQL
no_index:
  directory:
    - t
    - inc
requires:
  DBI: 1.617
  Excel::Writer::XLSX: 0.5
  Modern::Perl: 1.20120521
  Params::Validate: 1.06
version: 1.2

Makefile.PL  view on Meta::CPAN

use 5.010000;
use ExtUtils::MakeMaker;
# See lib/ExtUtils/MakeMaker.pm for details of how to influence
# the contents of the Makefile that is written.
WriteMakefile(
    NAME              => 'MySQL::RunSQL',
    VERSION_FROM      => 'lib/MySQL/RunSQL.pm', # finds $VERSION
    PREREQ_PM         => {
                            Modern::Perl => 1.20120521,
                            DBI    =>   1.617,
                            Params::Validate => 1.06,
                            Excel::Writer::XLSX =>  0.50
                        }, # e.g., Module::Name => 1.1
    ($] >= 5.005 ?     ## Add these new keywords supported since 5.005
      (ABSTRACT_FROM  => 'lib/MySQL/RunSQL.pm', # retrieve abstract from module
       AUTHOR         => 'Melissa A. VandenBrink <geeklady@gmail.com>') : (GEEKLADY)),
);

README  view on Meta::CPAN

   perl Makefile.PL
   make
   make test
   make install

DEPENDENCIES

This module requires these other modules and libraries:

Modern::Perl
DBI
DBD::mysql
Params::Validate
Excel::Writer::XLSX

COPYRIGHT AND LICENCE

Copyright (C) 2012 by Melissa A. VandenBrink

This library is free software; you can redistribute it and/or modify

lib/MySQL/RunSQL.pm  view on Meta::CPAN

=head1 NAME

MySQL::RunSQL	- Run SQL queries against a MySQL database and return the
results to STDOUT or XLSX file.

=cut

use v5.10;
use warnings;
use Modern::Perl;
use DBI;
use Params::Validate;
use Excel::Writer::XLSX;
use Env						qw/HOME/;
use vars					qw($VERSION @ISA);

require Exporter;

@ISA = qw/Exporter/;
$VERSION = '1.2';