def update_attributes(self, username, hostname, user_attrs):
"""Change the attributes of an existing user."""
LOG.debug("Changing user attributes for user %s.", username)
user = self._get_user(username, hostname)
new_name = user_attrs.get('name')
new_host = user_attrs.get('host')
new_password = user_attrs.get('password')
if new_name or new_host or new_password:
with self.local_sql_client(self.mysql_app.get_engine()) as client:
if new_password is not None:
uu = sql_query.SetPassword(user.name,
host=user.host,
new_password=new_password)
t = text(str(uu))
client.execute(t)
if new_name or new_host:
uu = sql_query.RenameUser(user.name,
host=user.host,
new_user=new_name,
new_host=new_host)
t = text(str(uu))
client.execute(t)
def update_attributes(self, username, hostname, user_attrs):
"""Change the attributes of an existing user."""
LOG.debug("Changing user attributes for user %s.", username)
user = self._get_user(username, hostname)
new_name = user_attrs.get('name')
new_host = user_attrs.get('host')
new_password = user_attrs.get('password')
if new_name or new_host or new_password:
with mysql_util.SqlClient(self.mysql_app.get_engine(),
use_flush=True) as client:
if new_password is not None:
uu = sql_query.SetPassword(
user.name,
host=user.host,
new_password=new_password,
ds=CONF.datastore_manager,
ds_version=CONF.datastore_version)
t = text(str(uu))
client.execute(t)
if new_name or new_host:
uu = sql_query.RenameUser(user.name,
host=user.host,
new_user=new_name,
new_host=new_host)
t = text(str(uu))
client.execute(t)
def test_change_host(self):
username = '******'
hostname = 'localhost'
new_host = '%'
uu = sql_query.RenameUser(user=username,
host=hostname,
new_host=new_host)
self.assertEqual("RENAME USER 'root'@'localhost' "
"TO 'root'@'%';", str(uu))
def test_rename_user(self):
username = '******'
hostname = 'localhost'
new_user = '******'
uu = sql_query.RenameUser(user=username,
host=hostname,
new_user=new_user)
self.assertEqual(
"RENAME USER 'root'@'localhost' "
"TO 'root123'@'localhost';", str(uu))