mysqlexec

This class runs mysql functions from the command line.
Run the Business

Run the Business

runthebusiness

11,184 downloads

8,808 latest version

1.6 quality score

Version information

  • 1.3.0 (latest)
  • 1.0.2
  • 1.0.1
  • 1.0.0
released Jul 3rd 2019

Start using this module

Documentation

runthebusiness/mysqlexec — version 1.3.0 Jul 3rd 2019

mysqlexec

This class runs mysql functions from the command line.

This module does not manage the installation and configuration of mysql but is instead focused on invoking mysql commands from the command line.

Here are some key features:

1) The ability to run commands on a remote database instead of just on the local machine (The initial reason why we wrote the module) 2) The ability to run any sql command through puppet 3) The ability to set up unless conditions that can be written as command line execution or a mysql query 4) Handling for the zoneinfo file 5) Built in handling of: users / user privileges, schemas and populating table data loaded from flat files

Examples:

mysqlexec{"mysqlexecexample": host=>, username=>, password=>, mysqlcommand=>, mysqlunless=><an mysql query that returns true or false, if true the command will not run>, }

mysqlexec::db{"mysqldbexecexample": host=>, username=>, password=>, dbname=, ensure=, }

mysqlexec::loaddata{"mysqlloaddataexecexample": host=>, username=>, password=>, table=>, filepath=, columns=>[], checkdata=><will bypass the other unless functions and use the built in checkdata functionality of the module, this uses the mysqlunless functionality to see if there is already data in the table>, replace=>, }

mysqlexec::user{"mysqluserexecexample": host=>, username=>, password=>, dbuser=>, dbpassword=>, privileges => [], dbname =>, ensure=> }

This module has been tested in debian squeeze, if you use it in another flavor and it works fine as is or if you have improvements to the params class to allow it to work in your flavor please let us know.

Authors

Will Ferrer, Ethan Brooks

Contributing Authors

Mark Cartwright, Andreyev Dias de Melo

Licensees

2012 developed under license for Switchsoft LLC http://www.switchsoft.com a "Direct response telephony company" as part of it's "VOIP Call distribution, ROI analysis platform, call recording, and IVR for inbound and outbound sales" and Run the Business Systems LLC a "Technology development investment group" as part of it's "PHP, Javascript rapid application development framework and MySQL analysis tools"

License

Licensed under the terms of the Open Source LGPL 3.0 license.

Contact

will.ferrer@runthebusiness.net

Support

Please send tickets and issues to our contact email address or at: https://github.com/runthebusiness/puppet-mysqlexec/issues

Project Url

https://github.com/runthebusiness/puppet-mysqlexec