def _refresh (self):
sql = self._get_sql()
self.sql_result = DB.fetchall_cacheable (sql)
return True
def get_org_id(mail = conf.USER):
username = mail.split('@')[0]
SQL = "select id from \"OrgChart2S.User\" u where u.Uid = '%s'" %(username)
return DB.fetchall_cacheable(SQL)[0]['id']
def get_manager(mail = conf.USER):
username = mail.split('@')[0]
SQL = "select uid,realname from \"OrgChart2S.User\" u where u.id = ( select Manager from \"OrgChart2S.User\" u where u.Uid = '%s' )" %(username)
return DB.fetchall_cacheable(SQL)
def get_direct_reports(mail = conf.USER):
manager_id = get_org_id()
SQL = "select uid,realname from \"OrgChart2S.User\" u where u.Manager = '%s'" %(manager_id)
return DB.fetchall_cacheable(SQL)
def get_user_id(username = conf.USER):
SQL = "select userid from BugzillaS.profiles profiles where profiles.login_name = '%s'" %(username)
return DB.fetchall_cacheable(SQL)[0]['userid']
def get_product_id(product = conf.TASKS_PRODUCT):
SQL = "select id from BugzillaS.products products where products.name = '%s'" %(product)
return DB.fetchall_cacheable(SQL)[0]['id']
