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