def check_galaxy(self): """Check if user have galaxy triples""" query_laucher = QueryLauncher(self.settings, self.session) sqa = SparqlQueryAuth(self.settings, self.session) result = query_laucher.process_query( sqa.check_galaxy(self.username).query) return ParamManager.Bool(result[0]['status'])
def get_admin_blocked_by_email(self): """ get the admin status of the user by his username """ query_laucher = QueryLauncher(self.settings, self.session) sqa = SparqlQueryAuth(self.settings, self.session) result = query_laucher.process_query( sqa.get_admin_blocked_by_email(self.email).query) results = {} if len(result) <= 0: results['blocked'] = True results['admin'] = True else: results['blocked'] = ParamManager.Bool(result[0]['blocked']) results['admin'] = ParamManager.Bool(result[0]['admin']) return results
def ckeck_key_belong_user(self, key): """Check if a key belong to a user""" query_laucher = QueryLauncher(self.settings, self.session) sqa = SparqlQueryAuth(self.settings, self.session) result = query_laucher.process_query( sqa.ckeck_key_belong_user(self.username, key).query) self.log.debug('---> result: ' + str(result)) if len(result) <= 0: return False return ParamManager.Bool(result[0]['count'])
def get_admin_blocked_by_email(self): """ get the admin status of the user by his username """ database = DatabaseConnector(self.settings, self.session) query = ''' SELECT admin, blocked FROM users WHERE email=? ''' rows = database.execute_sql_query(query, (self.email, )) results = {} if len(rows) <= 0: results['blocked'] = True results['admin'] = False else: results['blocked'] = ParamManager.Bool(rows[0][1]) results['admin'] = ParamManager.Bool(rows[0][0]) return results
def check_email_in_database(self): """ Check if the email is present in the TS """ query_laucher = QueryLauncher(self.settings, self.session) sqa = SparqlQueryAuth(self.settings, self.session) result = query_laucher.process_query( sqa.check_email_presence(self.email).query) if len(result) <= 0: return False return ParamManager.Bool(result[0]['status'])
def test_bool(self): try: ParamManager.Bool(None) assert False except Exception as e: assert True assert not ParamManager.Bool("FALSE") assert not ParamManager.Bool("FaLsE") assert ParamManager.Bool("TRUE") assert ParamManager.Bool("TrUe") assert ParamManager.Bool("1") try: ParamManager.Bool(1) assert False except Exception as e: assert True