Plugins for MySQL Workbench

For Drupal 7

To install these plugins, download the .py files to your computer and install them by launching MySQL Workbench and click on

Scripting->Install Plugin/Module

Install each file, then restart MySQL Workbench.

drupal_grt.py

This plugin makes it easier when testing/writing queries during drupal module development. After installing the plugin, it adds two menu options (In the SQL Editor View):

Plugins->Utilities->Strip curly braces from table names
Plugins->Utilities->Copy as Drupal query to clipboard

The first command removes the curly braces from around table names. eg. SELECT * FROM {users}; => SELECT * FROM users;

The second command does the opposite and copies the result to the clipboard: SELECT * FROM users; => SELECT * FROM {users};

Known limitations:

• Does not handle table prefixes - it's maybe possible to auto-detect this from the existing tables names
• Curly braces may be stripped if they occur in a string value. This is a rare occurance.

drupal_schema_grt.py

This plugin dumps tables to a drupal schema. See (https://drupal.org/node/693138) for original discussion.

After you install this plugin, to use it: "Create New Model" follow through on sensible defaults. Then in the MySQL Model view you will find the menu option:

Tools->Catalog->Generate Drupal Schema

This will copy your hook_schema() definition to your clipboard which you can then copy into your .install file.