from mysql.utilities.common.tools import (check_python_version,
check_connector_python,
join_and_build_str)
# Check Python version compatibility
from mysql.utilities.exception import UtilError, FormatError
check_python_version()
import os
import sys
# Check for connector/python
if not check_connector_python():
sys.exit(1)
# Constants
_VALID_PRIVS = set(["CREATE", "DROP", "GRANT OPTION", "LOCK TABLES",
"REFERENCES", "EVENT", "ALTER", "DELETE", "INDEX",
"INSERT", "SELECT", "UPDATE", "TRIGGER", "CREATE VIEW",
"CREATE TEMPORARY TABLES", "SHOW VIEW", "ALTER ROUTINE",
"CREATE ROUTINE", "EXECUTE", "FILE", "CREATE TABLESPACE",
"CREATE USER", "PROCESS", "RELOAD", "REPLICATION CLIENT",
"REPLICATION SLAVE", "SHOW DATABASES", "SHUTDOWN",
"SUPER", "ALL", "ALL PRIVILEGES", "USAGE", "REFERENCES"])
NAME = "MySQL Utilities - mysqlgrants"
DESCRIPTION = "mysqlgrants - display grants per object"
USAGE = ("%prog --server=user:pass@host:port \\\n"
from mysql.utilities.common.sql_transform import (is_quoted_with_backticks,
remove_backtick_quoting,
quote_with_backticks)
# Check Python version compatibility
check_python_version()
# Constants
NAME = "MySQL Utilities - mysqldbcompare "
DESCRIPTION = "mysqldbcompare - compare databases for consistency"
USAGE = "%prog --server1=user:pass@host:port:socket " + \
"--server2=user:pass@host:port:socket db1:db2"
PRINT_WIDTH = 75
# Check for connector/python
if not check_connector_python():
sys.exit(1)
if __name__ == '__main__':
# Setup the command parser
parser = setup_common_options(os.path.basename(sys.argv[0]),
DESCRIPTION, USAGE, server=False)
# Connection information for the source server
parser.add_option("--server1", action="store", dest="server1",
type="string", default=None,
help="connection information for first server in "
"the form: <user>[:<password>]@<host>[:<port>]"
"[:<socket>] or <login-path>[:<port>][:<socket>].")
# Connection information for the destination server
def test_check_connector_python(self):
"""Test valid detection of missing connector/python.
"""
res = check_connector_python(False)
self.assertEqual(False, res, "Test found connector/python when it "
"should not have!")
