def create_user(self, users):
"""Create users and grant them privileges for the specified databases"""
with LocalSqlClient(get_engine()) as client:
for item in users: user = models.MySQLUser() user.deserialize(item)
# TODO(cp16net):Should users be allowed to create users
# 'os_admin' or 'debian-sys-maint'
g = sql_query.Grant(user=user.name, host=user.host, clear=user.password)
t = text(str(g)) client.execute(t)
for database in user.databases: mydb = models.ValidatedMySQLDatabase() mydb.deserialize(database) g = sql_query.Grant(permissions='ALL', database=mydb.name, user=user.name, host=user.host, clear=user.password) t = text(str(g)) client.execute(t)
trove/guestagen t/datastore/ mysql/service. py
def create_user(self, users):
specified databases""" get_engine( )) as client:
user = models.MySQLUser()
user. deserialize( item) :Should users be allowed to create users Grant(user= user.name, host=user.host,
clear= user.password)
client. execute( t)
mydb = models. ValidatedMySQLD atabase( )
mydb. deserialize( database)
g = sql_query. Grant(permissio ns='ALL' , database=mydb.name,
user= user.name, host=user.host,
clear= user.password)
t = text(str(g))
client. execute( t)
"""Create users and grant them privileges for the
with LocalSqlClient(
for item in users:
# TODO(cp16net)
# 'os_admin' or 'debian-sys-maint'
g = sql_query.
t = text(str(g))
for database in user.databases: