def get_active_username(self):
mdb = FGMySQLDB()
mdb.dbinfo(os.environ["FG_OPENSTACK_DB_HOST"], os.environ["FG_OPENSTACK_DB_ID"], os.environ["FG_OPENSTACK_DB_PASS"], os.environ["FG_OPENSTACK_DB_NAME"])
#mdb.dbinfo("hostname","id","pass","db")
mdb.connect()
res = mdb.select("select distinct name from keystone.user, (select user_id from instances where vm_state='active' and task_state is null) as a where id=a.user_id")
mdb.close()
return res
def convert_username(self, userids):
res = []
mdb = FGMySQLDB()
mdb.dbinfo(os.environ["FG_METRIC_DB_HOST"], os.environ["FG_METRIC_DB_ID"], os.environ["FG_METRIC_DB_PASS"], os.environ["FG_METRIC_DB_NAME"])
#mdb.dbinfo("hostname","id","pass","db")
mdb.connect()
for record in userids:
name = mdb.select("select first_name, last_name, email from userinfo where username='******' limit 1" % record["name"])
try:
name = name[0]
name["ownerid"] = record["name"]
res.append(name)
except:
pass
mdb.close()
return res
