def test_histogram2(self): fLOG(__file__, self._testMethodName, OutputPrint=__name__ == "__main__") filename = os.path.join( os.path.split(__file__)[0], "data", "database_linked.zip") temp = get_temp_folder(__file__, "temp_histogram2") filename = unzip(filename, temp) assert os.path.exists(filename) db = Database(filename, LOG=fLOG) db.connect() sql = db.histogram("url_QRW2", values={ "cat1": [(1, 1), (1, 0)], "cat2": [(1, 10), (2, 10), (2, 1)] }, col_sums=["sum_nb_click"], columns=("pos", "co")) view = db.execute_view(sql) assert view == [('cat1', 1115, 15), ('cat2', 3792, 411), ('none', 33309, 108894)] db.close()
def test_histogram(self): fLOG(__file__, self._testMethodName, OutputPrint=__name__ == "__main__") filename = os.path.join( os.path.split(__file__)[0], "data", "database_linked.zip") temp = get_temp_folder(__file__, "temp_histogram") filename = unzip(filename, temp) assert os.path.exists(filename) db = Database(filename, LOG=fLOG) db.connect() sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns=("pos", "url")) view = db.execute_view(sql) assert len(view) == 38216 sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns="url") view = db.execute_view(sql) assert len(view) == 28436 sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns="pos", values=[1, 2, 3, 4, 5]) view = db.execute_view(sql) assert view == [(1, 2370, 87049), (2, 5734, 11522), (3, 4009, 5383), (4, 4304, 1778), (5, 21799, 3588)] sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns="pos", values={ "pos123": [1, 2, 3], "others": [4, 5, 6, 7, 8, 9, 10] }) view = db.execute_view(sql) assert view == [('none', 21, 0), ('others', 26082, 5366), ('pos123', 12113, 103954)] db.close()
def test_histogram(self): fLOG(__file__, self._testMethodName, OutputPrint=__name__ == "__main__") filename = os.path.join(os.path.split( __file__)[0], "data", "database_linked.zip") temp = get_temp_folder(__file__, "temp_histogram") filename = unzip(filename, temp) assert os.path.exists(filename) db = Database(filename, LOG=fLOG) db.connect() sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns=("pos", "url")) view = db.execute_view(sql) assert len(view) == 38216 sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns="url") view = db.execute_view(sql) assert len(view) == 28436 sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns="pos", values=[1, 2, 3, 4, 5]) view = db.execute_view(sql) assert view == [(1, 2370, 87049), (2, 5734, 11522), (3, 4009, 5383), (4, 4304, 1778), (5, 21799, 3588)] sql = db.histogram("url_QRW2", col_sums=["sum_nb_click"], columns="pos", values={"pos123": [1, 2, 3], "others": [4, 5, 6, 7, 8, 9, 10]}) view = db.execute_view(sql) assert view == [('none', 21, 0), ('others', 26082, 5366), ('pos123', 12113, 103954)] db.close()
def test_histogram2(self): fLOG(__file__, self._testMethodName, OutputPrint=__name__ == "__main__") filename = os.path.join(os.path.split( __file__)[0], "data", "database_linked.zip") temp = get_temp_folder(__file__, "temp_histogram2") filename = unzip(filename, temp) assert os.path.exists(filename) db = Database(filename, LOG=fLOG) db.connect() sql = db.histogram("url_QRW2", values={"cat1": [(1, 1), (1, 0)], "cat2": [ (1, 10), (2, 10), (2, 1)]}, col_sums=["sum_nb_click"], columns=("pos", "co")) view = db.execute_view(sql) assert view == [('cat1', 1115, 15), ('cat2', 3792, 411), ('none', 33309, 108894)] db.close()