trace=0) mis.connect_to_metastore(dbms='mariadb', host='localhost', port=3306, user='******', password='******', database='TRIADB', trace=0) # Set DataModel eng = mis.restart(200, reset=True) print(mis) print(eng) mis.get_entities() mis.get_attributes() # Set AssociativeSet part_aset = mis.engine.get_aset(alias='PRT') # Construct Associations from dictionaries prt0 = { 'key': (7, 0), 'p_id': 223, 'p_name': 'Left Handed...', 'p_color': 'Red', 'p_weight': 15.5, 'p_unit': 'lb' } prt4 = {'key': (7, 4), 'p_id': 227, 'p_name': 'I Brake for Crop...'}
mis.connect_to_datastore(dbms='clickhouse', host='localhost', port=9000, user='******', password='******', database='TriaDB', trace=0) mis.connect_to_metastore(dbms='mariadb', host='localhost', port=3306, user='******', password='******', database='TRIADB', trace=0) # =========================================================================== # Select DataModel, DataResource, Start MIS # =========================================================================== eng = mis.restart(500, reset=True) print(mis) print(eng) mis.get_attributes(select='dim2, cname, alias') mis.get_entities(select='dim2, cname, alias') mis.get_asets() # Selections Set selections = [ eng.set_hacol(alias='p_color').cql.Select().Where("$v='Red'"), eng.set_hacol(alias='c_price').cql.Select().Where('$v<20'), eng.set_hacol(alias='c_quantity').cql.Select().Where('$v=200'), eng.set_hacol(alias='c_check').cql.Select().Where('$v=0') ] # Progressive (Single) filtering mode, filter ASETs each time with one selection # # Single Mode Filtering with one selection only eng.filter_selections(selections[0]) # Single Mode Filtering with a set of selections