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(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') # 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(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") # Redirects to the login page self.assertEqual(403, resp.status_code) # Admin sees queries self.login("admin") data = self.get_json_resp("/superset/queries/0") self.assertEqual(2, len(data)) data = self.get_json_resp("/superset/queries/0.0") self.assertEqual(2, len(data)) # Run 2 more queries self.run_sql("SELECT * FROM birth_names LIMIT 1", client_id="client_id_4") self.run_sql("SELECT * FROM birth_names LIMIT 2", client_id="client_id_5") self.login("admin") data = self.get_json_resp("/superset/queries/0") self.assertEqual(4, len(data)) now = datetime.now() + timedelta(days=1) query = ( db.session.query(Query) .filter_by(sql="SELECT * FROM birth_names LIMIT 1") .first() ) query.changed_on = now db.session.commit() data = self.get_json_resp( "/superset/queries/{}".format(float(datetime_to_epoch(now)) - 1000) ) self.assertEqual(1, len(data)) self.logout() resp = self.client.get("/superset/queries/0") # Redirects to the login page self.assertEqual(403, resp.status_code)