Objective
In this presentation, you will get an introduction to MySQL Workbench and How to enable Python in the MySQL workbench GRT Shell.
Description
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
we will discuss how to enable Python in the MySQL Workbench GRT Shell. explains how to run a simple Python script using Workbench.
The Workbench Scripting Shell provides a means for entering and executing scripts. Through the use of the scripting shell, MySQL Workbench can support new behavior and data sources using code written in Lua and Python. The shell can also be used to explore the current Workbench GRT (Generic RunTime) facilities.
The scripting shell is not only useful for expanding MySQL Workbench. You can use a script file from the scripting shell command line to perform repetitive tasks programmatically.
The built-in grt module contains everything related to the GRT that’s exposed to Python, including:
custom types for GRT lists, dicts and objects
wrappers for GRT classes, that can be used and instantiated as a normal Python class;
wrappers for registered GRT modules, that can be used like normal modules;
a reference to the root node of the GRT globals tree;
Speaker bio
Sastry has 16+ years of rich, robust and diversified IT and Functional experience in multiple technologies spread across various domains, businesses and verticals. His strengths are in pre-sales/program/delivery/account management and on time and on budget delivery of large projects adhering to the quality norms and to the utmost customer satisfaction. He also has strong and proven expertise in providing Architectural Consultancy to global projects.
Joined Sun Microsystems in 2008 as Enterprise Solution Architect handling Deployment Architecture using JavaCAPS ( Middleware) applications. After MySQL Merger in to Sun and then later into Oracle worked different technologies including MySQL , Fusion Middleware Solutions. Currently working as sr. technical Consultant in the MySQL team.