mysql (module) ∞
Some handy mysql database query and insertion tools
Classes
|
a database object that can setup up a ssh tunnel (optional) and a database connection |
|
Take a sqlite database file and copy the tables within it to a MySQL database |
|
Take key-values from yaml files including a tablename(s) and add them to a mysql database table |
Functions
convert dictionary to mysql table |
|
|
A function to run all mysql scripts in a given directory (in a modified date order, oldest first) and then act on the script files in accordance with the succcess or failure of their execution |
|
execute a mysql script given its file path and return the success or failure status of the execution |
|
get database table column names |
insert list of dictionaries into database tables |
|
|
Given a mysql query, read the data from the database and return the results as a list of dictionaries (database rows) |
|
Start a database connection using settings in yaml file |
|
Probe a database to determine if a given table exists |
|
Execute a MySQL write command given a sql query |