def test_queries_endpoint(self): self.run_some_queries() # Not logged in, should error out resp = self.client.get('/superset/queries/0') # Redirects to the login page self.assertEquals(403, resp.status_code) # Admin sees queries self.login('admin') data = self.get_json_resp('/superset/queries/0') self.assertEquals(2, len(data)) # Run 2 more queries self.run_sql('SELECT * FROM ab_user LIMIT 1', client_id='client_id_4') self.run_sql('SELECT * FROM ab_user LIMIT 2', client_id='client_id_5') self.login('admin') data = self.get_json_resp('/superset/queries/0') self.assertEquals(4, len(data)) now = datetime.now() + timedelta(days=1) query = db.session.query(Query).filter_by( sql='SELECT * FROM ab_user LIMIT 1').first() query.changed_on = now db.session.commit() data = self.get_json_resp('/superset/queries/{}'.format( int(utils.datetime_to_epoch(now)) - 1000)) self.assertEquals(1, len(data)) self.logout() resp = self.client.get('/superset/queries/0') # Redirects to the login page self.assertEquals(403, resp.status_code)
def test_queries_endpoint(self): self.run_some_queries() # Not logged in, should error out resp = self.client.get('/superset/queries/0') self.assertEquals(403, resp.status_code) # Admin sees queries self.login('admin') data = self.get_json_resp('/superset/queries/0') self.assertEquals(2, len(data)) # Run 2 more queries self.run_sql("SELECT * FROM ab_user1", client_id='client_id_4') self.run_sql("SELECT * FROM ab_user2", client_id='client_id_5') self.login('admin') data = self.get_json_resp('/superset/queries/0') self.assertEquals(4, len(data)) now = datetime.now() + timedelta(days=1) query = db.session.query(models.Query).filter_by( sql='SELECT * FROM ab_user1').first() query.changed_on = now db.session.commit() data = self.get_json_resp( '/superset/queries/{}'.format( int(utils.datetime_to_epoch(now))-1000)) self.assertEquals(1, len(data)) self.logout() resp = self.client.get('/superset/queries/0') self.assertEquals(403, resp.status_code)