gmq

grunt-mysql-query

Execute mysql query with grunt

Showing:

Popularity

Downloads/wk

2

GitHub Stars

1

Maintenance

Last Commit

5yrs ago

Contributors

2

Package

Dependencies

1

License

Type Definitions

Tree-Shakeable

No?

Categories

Readme

Grunt (MYSQL) Database cleaning

npm version

IMPORTANT NOTE: the authors of this Plugin assume no responsibility for any actions which result from the usage of this script. You use it entirely at your own risk. It is strongly recommended that you test the script in a non-critical environment prior to rolling out for production use. Always manually backup your local and remote databases before using the script for the first time. No support can be provided for critical situations.

Getting Started

This plugin requires Grunt >=0.4.1

If you haven't used Grunt before, be sure to check out the Getting Started guide, as it explains how to create a Gruntfile as well as install and use Grunt plugins. Once you're familiar with that process, you may install this plugin with this command:

npm install grunt-mysql-query --save-dev

Once the plugin has been installed, it may be enabled inside your Gruntfile with this line of JavaScript:

grunt.loadNpmTasks('grunt-mysql-query');

Documentation

Overview

In your project's Gruntfile, add a section named mysql_query to the data object passed into grunt.initConfig().

grunt.initConfig({
  mysql_query: {
    dev1: {
        host: "",
        user: "",
        pass: "",
        database: "",
        query: "SELECT 1"
    },
    dev2: {
        host: "",
        user: "",
        pass: "",
        database: "",
        queries: ["SELECT 1", "SELECT 2"]
    },
    prod1: {
        host: "",
        user: "",
        pass: "",
        database: "",
        silent: true, <- do not show logs
        queries: [{"file": "file.sql"}, "SELECT 2"]
    },
    prod2: {
        host: "",
        user: "",
        pass: "",
        database: "",
        queries: [{"file": "file.sql"}, {"inline": "SELECT 2"}]
    },
    // etc
  }
});

grunt.loadNpmTasks('grunt-mysql-query');

grunt.registerTask('default', ['mysql_query:dev1']);

Used by

caravel.design

Rate & Review

Great Documentation0
Easy to Use0
Performant0
Highly Customizable0
Bleeding Edge0
Responsive Maintainers0
Poor Documentation0
Hard to Use0
Slow0
Buggy0
Abandoned0
Unwelcoming Community0
100
No reviews found
Be the first to rate

Alternatives

No alternatives found

Tutorials

No tutorials found
Add a tutorial